Question # 1
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
A. Microsoft Teams Personal Analytics
B. SQL Server database
C. Dataverse
D. Dataflows
Correct Answer: C
Question # 2
HOTSPOT –
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customer.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled
refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question # 3
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Excel Workbook
B. Text/CSV
C. Folder
D. SharePoint folder
E. Web
Correct Answer: D
Question # 4
You attempt to connect Power BI Desktop to a Cassandra database.
From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.
You need to select an alternate data connector that will connect to the database.
Which type of connector should you choose?
A. Microsoft SQL Server database
B. ODBC
C. OLE DB
D. OData
Correct Answer: B
Question # 5
HOTSPOT
–
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power BI deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Question # 6
From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: Could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. You do not have permissions to the file.
B. An incorrect privacy level was used for the data source.
C. The file is locked.
D. The referenced file was moved to a new location.
Correct Answer: AD
Question # 7
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.
Each sales region has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?
A. Publish the reports in an app and grant the HR managers access permission.
B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
C. Publish the reports to a different workspace other than the one hosting the datasets.
D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
Correct Answer: A
Question # 8
HOTSPOT –
You create a Power BI dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type in Microsoft Excel.
How should you configure the properties of the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question # 9
DRAG DROP –
You plan to create a report that will display sales data from the last year for multiple regions.
You need to restrict access to individual rows of the data on a per region-basis by using roles.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Question # 10
HOTSPOT –
You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are
usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
Sales contains the data shown in the following table.
You are evaluating how to optimize the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question # 11
HOTSPOT –
You plan to create Power BI dataset to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an
Azure SQL database.
View1 contains the columns shown in the following table.
View2 contains the columns shown in the following table.
The views can be related based on the Class ID column.
Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same
teacher during two different periods, but the class will have a different class ID.
You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:
✑ The count of classes that occur by period
✑ The count of students in attendance by period by day
✑ The average number of students attending a class each month
In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question # 12
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
✑ Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Create one-to-many relationships between the tables.
B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
C. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
D. Create a calculated measure that aggregates by using the COUNTROWS function.
Correct Answer: AB
Question # 13
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that
might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following
date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Question # 14
HOTSPOT –
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question # 15
DRAG DROP –
You need create a date table in Power BI that must contain 10 full calendar years, including the current year.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Question # 16
DRAG DROP –
You are modifying a Power BI model by using Power BI Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once,
or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Question # 17
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You remove the IoT GUID column and retain the IoT ID column.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Question # 18
You have a Power BI data model that analyzes product sales over time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model is enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
A. Create a relationship between the Date table and the Sales table.
B. Disable the auto date/time option.
C. Create a Date table and select Mark as Date Table.
D. Disable the load on the Date table.
E. Remove the relationship between the Product table and the Sales table.
Correct Answer: AC
Question # 19
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of
powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh
twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Replace the default visuals with AppSource visuals.
B. Remove unused columns from tables in the data model.
C. Change the imported dataset to DirectQuery
D. Increase the number of times that the dataset is refreshed.
Correct Answer: B
Question # 20
You have a Power BI data model that contains a table named Employees. The table has the following columns:
• Employee Name
• Email Address
• Start Date
• Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
• Users must see only their own employee data.
• The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
A. [Email Address] – USERNAME()
B. [Employee Name] – USERPRINCIPALNAME()
C. [Employee Name] = USERNAME()
D. [Email Address] = USERPRINCIPALNAME()
Correct Answer: D