HOTSPOT -
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power BI to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: Chart type: Line
Chart configuration: Populate the axis with a date field
Explanation: Power BI's anomaly detection (Show anomalies) is supported on line charts and requires a time-based X-axis, such as a date field, to analyze trends and detect outliers.
Question 6
HOTSPOT
-
You have a semantic model as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: add an additional date table
role-playing
Explanation: A single Date dimension cannot independently filter multiple date roles (such as OrderDate and PaymentDate) at the same time. To slice by both dates simultaneously, use a separate Date table for the additional role. A Date table related to multiple date columns serves as a role-playing dimension.
Question 7
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
A. Create a new aggregation that summarizes by state.
B. Create a new aggregation that summarizes by employee.
C. Create a new group on the state column and set the Group type to List.
D. Create a new group on the state column and set the Group type to Bin.
Show Answer
Correct Answer: C
Explanation: Create a group on the State column using the List group type. List grouping allows you to manually assign states into custom categories such as East, West, and North without modifying the underlying data model. Aggregations do not create new categorical mappings, and Bin grouping is intended for numeric/date ranges rather than manually defined geographic regions.
Question 7
You have a Power BI dataset that contains a table named Goal. Goal contains the following columns.
You need to use the Q&A feature to create a visual that answers the following question: "How many goals were scored last month?"
Which type of visual will be generated by the Q&A feature?
A. table
B. smart narrative
C. card
D. gauge chart
Show Answer
Correct Answer: C
Explanation: A Q&A query that asks for a single aggregated value ('How many goals were scored last month?') returns a single numeric result. Power BI Q&A typically renders a single aggregate as a card visual rather than a table, smart narrative, or gauge (which requires a target/context).
Question 8
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.
Which type of visual should you use?
A. smart narrative
B. decomposition tree
C. Q&A
D. key influencers
Show Answer
Correct Answer: B
Explanation: The correct visual is the decomposition tree. In Power BI, the decomposition tree is specifically designed for ad hoc exploration and root-cause analysis, allowing users to drill down dynamically across dimensions to investigate how a measure is broken down. Smart narrative generates text summaries, Q&A uses natural language queries, and Key influencers identifies factors affecting a metric rather than providing interactive hierarchical exploration.
Question 8
HOTSPOT
-
You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database.
Model1 will have the following tables.
You create DimDate and DimProduct by using import storage mode.
You need to configure the storage mode for each remaining table. The solution must meet the following requirements:
• The data in FactSales must be available within five minutes of being available in the source data.
• The query response time for reports connected to the model must be minimized.
Which storage mode should you configure for each table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation: FactSales requires near-real-time freshness, so DirectQuery satisfies the five-minute requirement. FactMarketingEmail changes only daily, so Import provides the fastest report performance. DimCustomer should be Dual so it can behave as Import with imported tables and DirectQuery with the DirectQuery fact, optimizing composite model queries.
Question 9
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What should you do?
A. Add salary to the drillthrough fields.
B. Add salary to the visual filters.
C. Add salary to the tooltips.
Show Answer
Correct Answer: C
Explanation: To display additional information such as total salary costs when hovering over a data point in a Power BI line chart, add the salary measure to the visual's Tooltips field well. Drillthrough fields are for navigating to a detail page, and visual filters restrict displayed data rather than providing hover information.
Question 9
HOTSPOT
-
You have a semantic model named Model1 that contains a table named Table1.
Table1 contains three columns named CustomerID, Age, and LoyaltyStatus.
You have an order system that tracks the order history of each customer.
You need to import the order system data into Model1 and create a single table that combines LoyaltyStatus with the number of orders. The solution must ensure that only customers that have orders are stored in the dataset.
How should you create the table, and which join kind should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Create the table by: Merging the queries
Join kind: Inner
Explanation: Combine customer data with order data using a merge on CustomerID. An inner join keeps only customers that exist in both tables, ensuring only customers with orders are stored. After the merge, aggregate the orders as needed.
Question 10
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 clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: A constant line with a value of 0.5 would draw the line at $0.50 on the salary axis, not at the median salary. To identify employees above the median salary, the reference line must be based on the median aggregation (or set to the actual median salary value), not a fixed value of 0.5.
Question 10
You use Power Query Editor to ingest data into Power BI Desktop from two Microsoft SharePoint Online lists named Customers and Locations.
Each list contains more than 25,000 rows. Locations is referenced in Customers to generate qualified values in a drop-down list.
You create the following query in Power Query Editor.
You experience long load times and discover that Power Query Editor makes calls to the URL of each row in the final dataset.
You need to optimize the query. The solution must minimize development effort.
What should you do?
A. Read the lists separately, and then merge the lists.
B. Read the lists separately, and then append the lists.
C. Create a custom function to read the referenced SharePoint list.
D. Expand the referenced column of the query.
Show Answer
Correct Answer: D
Explanation: The SharePoint lookup/reference column causes Power Query to issue additional HTTP requests when values are resolved row by row. Expanding the referenced column allows Power Query to retrieve the related data efficiently instead of making a separate request for each row, significantly improving load performance with minimal changes to the existing query. Appending is unrelated, and creating a custom function or rebuilding the query by loading and merging separate lists requires more development effort.
$19
Get all 369 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
