Question 101
You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is
expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl
service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl
service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 102
You have a file named File1.txt that has the following characteristics:
* A header row
* Tab delimited values
* UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?
* A header row
* Tab delimited values
* UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?
Question 103
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the
following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity
label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity
label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Question 104
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo. Dim Product. You need to write a query to meet the following requirements:
* Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties.
* Specify the quartile in which each product's list price falls within each product category.
How should you complete the query? To answer, select the appropriate options in the answer area.
* Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties.
* Specify the quartile in which each product's list price falls within each product category.
How should you complete the query? To answer, select the appropriate options in the answer area.
Question 105
You have a Power Bl tenant that contains 10 workspaces.
You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulting data by using Azure Data Factory.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulting data by using Azure Data Factory.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point