Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Power BI > Study questions > Flashcards

Study questions Flashcards

1
Q

Geoffrey is a data modeler at Adventure Works who developed a DirectQuery model that connects to the data warehouse. To improve the query performance of higher-grain sales queries, Geoffrey added an import aggregation table. What else should Geoffrey do to improve query performance of the higher-grain queries?

A

Set related dimension tables to dual storage mode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Breana is a data modeler at Adventure Works who developed a manufacturing model, which is an import model. Breana needs to ensure that manufacturing reports deliver real-time results. Which type of table should Breana create?

A

Hybrid table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Mousef is a business analyst at Adventure Works who wants to create a new model by extending the sales dataset, which is delivered by IT. Mousef wants to add a new table of census population data sourced from a web page. Which model framework should Mousef use?

A

Composite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Model frameworks:

A

Import, DirectQuery, composite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Define Hybrid Table

A

Power BI adds a DirectQuery partition for the current period

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

T/F You can covert a DirectQuery table to an import table.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

T/F You can covert an import table to a DirectQuery table.

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

In a Power BI Desktop model design, which type of object do you create to enforce row-level security?

A

Role

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following statements is correct regarding a star schema design?

A

Fact table store accumulations of business events

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In what order does an analytic query implement its phases?

A

Filter, Group, Summarize

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A good data model offers the following benefits:

A

Data exploration is faster.Aggregations are simpler to build.Reports are more accurate.Writing reports takes less time.Reports are easier to maintain in the future.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does data granularity mean?

A

Data granularity indicates the level the detail within the data, so the higher the granularity, the more detail that is represented in the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the difference between a fact table and a dimension table?

A

Fact tables contain observational data while dimension tables contain information about specific entities within the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Choose the best answer to explain relationship cardinality?

A

Cardinality is the measure of unique values in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a fully qualified column?

A

A column that has been identified with both the column and table name.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When should you use the DIVIDE function?

A

When the denominator is an expression that could return zero or BLANK.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You’re using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, you need a calculation to show the number of different customers who have placed orders. What type of DAX calculation will you add to the model?

A

Measure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

You’re using Power BI Desktop to develop a model. It has a table named Customer, which includes a column named DateOfBirth. In reports, you need to group customers by current age. What type of DAX calculation will you add to the Customer table?

A

Calculated Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

You’re using Power BI Desktop to develop a model. It has a table named Geography, which has two relationships to the Sales table. One relationship filters by customer region and the other filters by sales region. You need to create a role-playing dimension so that both filters are possible. What type of DAX calculation will you add to the model?

A

Calculated table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

You write a DAX formula that adds BLANK to the number 20. What will be the result?

A

20

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which statement about measures is correct?

A

Measures can reference other measures directly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which DAX function can summarize a table?

A

Countrows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which of the following statements describing similarity of measures and calculated columns in an Import model is true?

A

They can achieve summarization of model data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which statement about calculated tables is true?

A

Calculated tables store data inside the model, and adding them results in a larger model size.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Which statement about calculated columns is true?

A

Calculated column formulas are evaluated by using row context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

You’re developing a Power BI desktop model that sources data from an Excel workbook. The workbook has an employee table that stores one row for each employee. Each row has a reference to the employee’s manager, which is also a row in the employee table. You need to add several columns to the Employee table in your model to analyze payroll data within the organization hierarchy (like, executive level, manager level, and so on). Which technique will you use to add the columns?

A

Add calculated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Admin

A

Update & Delete the workspace, Add or remove people, including other admins

28
Q

Member

A

Add members or others with lower persmissions, Publish, unpublish, and change permsissions for an app

29
Q

Contributor

A

Create, edit, and delete content, such as reports, in the workspace, Publish reports to the workspace

30
Q

Viewere

A

View and interact with an item, Read data that?s stored in workspace dataflows

31
Q

In the context of data model calculations, which statement best describes time intelligence?

A

Filter context modifications involving a date table

32
Q

You’re developing a data model in Power BI Desktop. You’ve just added a date table by using the CALENDARAUTO function. You’ve extended it with calculated columns, and you’ve related it to other model tables. What else should you do to ensure that DAX time intelligence calculations work correctly?

A

Mark as a Date table

33
Q

You have a table that stores account balance snapshots for each date, excluding weekends. You need to ensure that your measure formula only filters by a single date. Also, if no record is on the last date of a time period, it should use the latest account balance. Which DAX time intelligence function should you use?

A

Lastonblank

34
Q

What benefit do you get from analyzing the metadata?

A

The benefit of analyzing the metadata is that you can clearly identify data inconstincies with your dataset

35
Q

What can be achieved by removing unnecessary rows and columns?

A

Deleting unnecessary rows and columns will reduce a dataset size and it’s good practice to load only necessary data into your data model.

36
Q

Which of the following statements about relationships in Power BI Desktop is true?

A

Relationships can be created between tables that contain different types of data.

37
Q

You plan to publish a dataset from Power BI Desktop.You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service.Which two actions should you perform? Each correct answer presents part of the solution.

A

Create a parameter, From the Data source settings, update the server source as a parameter

38
Q

From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection.You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record.You need to select individual fields from items in the collection that you want to load into Power BI Desktop.What should you do first?

A

Open Power Query Editor

39
Q

You need to create DAX calculated columns and measures in Power BI Desktop.In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

A

as an item in the Fields well of a slicer, as a filter in the “Filters on this page” wsell of the Filters pane

40
Q

You plan to run Power BI Desktop Performance Analyzer.You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop.What should you do first?

A

Connect DAX Studio to the data model

41
Q

You manage a Power BI workspace.You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege.Which role should you use?

A

Admin

42
Q

You are editing a report in Power BI Desktop.You need to adjust the behavior of the report by editing interactions.Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution.

A

Filter, Highlight

43
Q

In Power BI Desktop, you need to create a measure.Which two interfaces can you use? Each correct answer presents a complete the solution.

A

Data view, Report View

44
Q

You need to create a bookmark that toggles the visibility of a visual.This bookmark must only toggle the visibility state and perform no other action.Which three configurations should you make? Each correct answer presents part of the solution.

A

Disable the Data option, Endable the Display Option, Disable the current page option

45
Q

You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value.Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data?

A

filter

46
Q

You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.You need to implement an incremental refresh of DS1.What should you do first?

A

In Power BI Desktop, define filter parameters

47
Q

You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1.What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?

A

4

48
Q

You have a fact table that contains sales data.The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options.You load the fact table into Power BI Desktop.You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort.What should you do?

A

Add a separate date dimension table

49
Q

You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace. What should you do first?

A

Select Ask a question about your data.

50
Q

You need to create a histogram that will display ranges of integers in groups.Which two resources do you need to create the histogram? Each correct answer presents part of the solution.

A

a Numerical column, a Bin group type

51
Q

Which native AI visual helps explain correlations for a metric within the dataset?

A

Key influencers visual

52
Q

You plan to certify a Power BI dataset.You need to identify at which level within your organization the permissions to certify a dataset are assigned.Which level should you identify?

A

Tenant

53
Q

Joshua is a data modeler at Adventure Works who is developing a model for a large data warehouse. The model must enforce RLS, and the Power BI reports that connect to the model should deliver the fastest possible performance. What should Joshua do?

A

Apply rules to dimension tables

54
Q

Rupali is a data modeler at Adventure Works who is developing an import model to analyze employee timesheet data. The employee table stores the employee social security number (SSN) in a column. While the model will be available for all company managers, it will also be available to employees in the Payroll department. However, reports must only reveal employee SSNs to payroll employees. What feature should Rupali use to restrict access to the SSN column?

A

(OLS) Object Level Security

55
Q

Kasper is a data modeler at Adventure Works who is developing a model that must enforce RLS. It must restrict access to only the sales regions assigned to the report consumer. The source database includes a table that stores employee usernames and their assigned region(s). What should Kasper do?

A

Create an RLS role and use a dynamic rule

56
Q

Stephanie is an enterprise data analyst, working as a resource to data analysts sitting in the finance department. One of the finance analysts asked Stephanie to help troubleshoot why report visuals take 5 seconds to render after a slicer selection is made. What tool should Stephanie use first to begin troubleshooting?

A

Performance analyzer

57
Q

James has been asked to troubleshoot a report that contains a matrix visual that renders visibly slower than any other visuals on the page. After James runs the Performance analyzer, he notices the need to dig further into the DAX query for the matrix using DAX Studio to understand what’s causing the trouble. That same query is running in less than a second in DAX Studio. Has James solved the problem?

A

No. James needs to clear the model cache to ensure that query results aren’t cached in the model

58
Q

Mary-Jo is responsible for managing the maintenance and deployment of Power BI assets for the entire organization. What tool can Mary-Jo use to ensure all data models adhere to data modeling best practices?

A

Best Practice Analyzer in Tabular Editor

59
Q

Margaret is a data modeler at Adventure Works who is adding a measure to sales model. When evaluated, the measure must filter by filters already applied to an unrelated table.

A

Treatas

60
Q

Which of the following capabilities is unique to the Filters pane?

A

Top N Filtering

61
Q

Which of the following capabilities is unique to slicers?

A

Horizontal Orientation

62
Q

Which native AI visual helps explain correlations for a metric within the dataset?

A

Key influencers visual

63
Q

You plan to get data for a Power BI dataset from flat files.You need a location type to store the files. The data must NOT automatically synchronize between the original file and the dataset.Which location type should you recommend?

A

Local File

64
Q

In Power BI Desktop, you need to create a role.Which two interfaces can you use? Each correct answer presents a complete solution.

A

Model View, Report View

65
Q

You need to create DAX calculated columns and measures in Power BI Desktop.In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

A

as an item in the Fields well of a slicer, as a filter in the “Filters on this page” wsell of the Filters pane

66
Q

You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.You need to implement an incremental refresh of DS1.What should you do first?

A

In Power BI Desktop, define filter parameters

67
Q

You manage a Power BI workspace.You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege.Which role should you use?

A

Contributor

Power BI (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions