Study questions

Question 1

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?

Answer 1

Set related dimension tables to dual storage mode

Question 2

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?

Answer 2

Hybrid table

Question 3

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?

Answer 3

Composite

Question 4

Model frameworks:

Answer 4

Import, DirectQuery, composite

Question 5

Define Hybrid Table

Answer 5

Power BI adds a DirectQuery partition for the current period

Question 6

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

Answer 6

TRUE

Question 7

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

Answer 7

FALSE

Question 8

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

Answer 8

Role

Question 9

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

Answer 9

Fact table store accumulations of business events

Question 10

In what order does an analytic query implement its phases?

Answer 10

Filter, Group, Summarize

Question 11

A good data model offers the following benefits:

Answer 11

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.

Question 12

What does data granularity mean?

Answer 12

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

Question 13

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

Answer 13

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

Question 14

Choose the best answer to explain relationship cardinality?

Answer 14

Cardinality is the measure of unique values in a table.

Question 15

What is a fully qualified column?

Answer 15

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

Question 16

When should you use the DIVIDE function?

Answer 16

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

Question 17

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?

Answer 17

Measure

Question 18

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?

Answer 18

Calculated Column

Question 19

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?

Answer 19

Calculated table

Question 20

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

Answer 20

20

Question 21

Which statement about measures is correct?

Answer 21

Measures can reference other measures directly

Question 22

Which DAX function can summarize a table?

Answer 22

Countrows

Question 23

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

Answer 23

They can achieve summarization of model data

Question 24

Which statement about calculated tables is true?

Answer 24

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

Question 25

Which statement about calculated columns is true?

Answer 25

Calculated column formulas are evaluated by using row context.

Question 26

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?

Answer 26

Add calculated

Question 27

Admin

Answer 27

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

Question 28

Member

Answer 28

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

Question 29

Contributor

Answer 29

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

Question 30

Viewere

Answer 30

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

Question 31

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

Answer 31

Filter context modifications involving a date table

Question 32

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?

Answer 32

Mark as a Date table

Question 33

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?

Answer 33

Lastonblank

Question 34

What benefit do you get from analyzing the metadata?

Answer 34

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

Question 35

What can be achieved by removing unnecessary rows and columns?

Answer 35

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

Question 36

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

Answer 36

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

Question 37

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.

Answer 37

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

Question 38

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?

Answer 38

Open Power Query Editor

Question 39

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.

Answer 39

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

Question 40

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?

Answer 40

Connect DAX Studio to the data model

Question 41

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?

Answer 41

Admin

Question 42

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.

Answer 42

Filter, Highlight

Question 43

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

Answer 43

Data view, Report View

Question 44

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.

Answer 44

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

Question 45

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?

Answer 45

filter

Question 46

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?

Answer 46

In Power BI Desktop, define filter parameters

Question 47

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?

Answer 47

4

Question 48

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?

Answer 48

Add a separate date dimension table

Question 49

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?

Answer 49

Select Ask a question about your data.

Question 50

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.

Answer 50

a Numerical column, a Bin group type

Question 51

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

Answer 51

Key influencers visual

Question 52

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?

Answer 52

Tenant

Question 53

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?

Answer 53

Apply rules to dimension tables

Question 54

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?

Answer 54

(OLS) Object Level Security

Question 55

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?

Answer 55

Create an RLS role and use a dynamic rule

Question 56

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?

Answer 56

Performance analyzer

Question 57

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?

Answer 57

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

Question 58

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?

Answer 58

Best Practice Analyzer in Tabular Editor

Question 59

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.

Answer 59

Treatas

Question 60

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

Answer 60

Top N Filtering

Question 61

Which of the following capabilities is unique to slicers?

Answer 61

Horizontal Orientation

Question 62

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

Answer 62

Key influencers visual

Question 63

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?

Answer 63

Local File

Question 64

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

Answer 64

Model View, Report View

Question 65

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.

Answer 65

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

Question 66

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?

Answer 66

In Power BI Desktop, define filter parameters

Question 67

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?

Answer 67

Contributor