Power BI Exam - Module 3 - Model data with Power BI

Choose the best answer to explain relationship cardinality? a. Cardinality is the measure of unique values in a table. b. Cardinality is the granularity of the data. c. Cardinality is how long it takes for the data to load.

a

In a Power BI Desktop model design, which type of object do you create to connect multiple tables?\ a. Relationship b. Column c. Measure

a

In what order does an analytic query implement its phases? a. Filter, Group, Summarize b. Group, Filter, Summarize c. Summarize, Filter, Group

a

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. b. Apply rules to hierarchies. c. Apply rules to fact tables.

a

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. b. DirectQuery. c. Live connection.

a

What benefit do you get from analyzing the metadata? a. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your semantic model. b. The benefit of analyzing the metadata is to get familiar with your data. c. The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model.

a

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. b. Fact tables contain information about specific entities while dimension tables contain information about observational data. c. There is no difference.

a

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. b. They store values in the semantic model. c. They're evaluated during data refresh. d. They can be created by using quick calculations.

a

Which of the following statements is correct regarding a star schema design? a. Fact tables store accumulations of business events. b. Fact tables store accumulations of business entities. c. Fact tables must have a unique column.

a

Which statement about calculated tables is true? a. Calculated tables increase the size of the semantic model. b. Calculated tables are evaluated by using row context. c. Calculated tables are created in Power Query. d. Calculated tables cannot include calculated columns.

a

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 b. Calculated column c. Computed column d. Measure

a

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. Aggregation table. b. Hybrid table. c. Partitioned table.

b

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 as aggregation tables. b. Set related dimension tables to dual storage mode. c. Set related dimension tables to import storage mode.

b

In the context of semantic model calculations, which statement best describes time intelligence? a. Snapshot balance reporting b. Filter context modifications involving a date table c. Complex calculations involving time d. Calculations involving hours, minutes, or seconds

b

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 OLS role and use a dynamic rule. b. Create an RLS role and use a dynamic rule. c. Create an RLS role and use a static rule.

b

What can be achieved by removing unnecessary rows and columns? a. It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact. b. Deleting unnecessary rows and columns will reduce a semantic model size and it's good practice to load only necessary data into your semantic model. c. Deleting unnecessary rows and columns can damage the structure of the semantic model.

b

What does data granularity mean? a. The amount of data that you have, meaning that higher granularity means more data to work with. b. The level of detail in your data, meaning that higher granularity means more detailed data. c. Data granularity is a type of schema design.

b

Which statement about calculated columns is true? a. Calculated columns are created in the Power Query Editor window. b. Calculated column formulas are evaluated by using row context. c. Calculated column formulas can only reference columns from within their table. d. Calculated columns can't be related to non-calculated columns.

b

You write a DAX formula that adds BLANK to the number 20. What will be the result? a. The result will be zero (0). b. The result will be 20. c. The result will be BLANK. d. The result will be NULL.

b

You're developing a semantic 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. Add time intelligence measures to the date table. b. Mark as a Date table. c. Add a fiscal hierarchy. d. Add a date column.

b

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 table b. Calculated column c. Computed column d. Measure

b

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. RLS. b. SSO. c. OLS.

c

Which DAX function can summarize a table? a. SUM b. AVERAGE c. COUNTROWS d. DISTINCTCOUNT

c

Which of the following statements about relationships in Power BI Desktop is true? a. Relationships can only be created between columns that contain the same data type. b. Relationships can only be created between tables that contain the same number of rows. c. Relationships can be created between tables that contain different types of data.

c

Which statement about measures is correct? a. Measures store values in the semantic model. b. Measures must be added to the semantic model to achieve summarization. c. Measures can reference columns directly. d. Measures can reference other measures directly.

d

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. FIRST b. FIRSTNONBLANK c. LAST d. LASTNONBLANK

d

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 persisted columns to a table by using T-SQL. b. Add column expressions in a view by using T-SQL. c. Add computed columns by using M. d. Add calculated columns by using DAX.

d

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. Calculated table b. Calculated column c. Computed column d. Measure

d