You have the Power BI workspaces 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.
You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication.
You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly
telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry
was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files
by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business
names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend using openrowset with to explicitly specify the maximum length for businessName
and surveyName.
Does this meet the goal?
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 Bl dataset named Datasetl.
In Datasetl, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Power Bl Desktop, you group the measures in a display folder.
Does this meet the goal?
