- (Topic 4)
You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.
You publish the report to the Bl service.
You need to be notified when the temperature rises above four degrees Celsius. What should you do?
Correct Answer:
A
- (Topic 4)
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 ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
Correct Answer:
B
DRAG DROP - (Topic 4)
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.
You implement the Power BI model.
You need to edit the Product Category table query to match the desired Power BI model. How should you complete the advanced query? 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 frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Solution:
https://msdn.microsoft.com/en-us/library/mt260776.aspx https://msdn.microsoft.com/en-us/library/mt260808.aspx
Does this meet the goal?
Correct Answer:
A
- (Topic 4)
You are creating a Power BI model that contains a table named Store. Store contains the following fields.
You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?
Correct Answer:
A
HOTSPOT - (Topic 4)
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 Customers. 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.
Solution:
Graphical user interface, text
Description automatically generated with medium confidence
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
✑ When you have one or more columns that you’d like to add to another query, you merge the queries.
✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Does this meet the goal?
Correct Answer:
A
