HOTSPOT
You have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
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?
A. Yes
B. No
You have a Power Bl report that contains the table shown in the following exhibit.
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?
A. Add alt text to explain the information that each color conveys.
B. Move the conditional formatting icons to a tooltip report.
C. Change the icons to use a different shape for each color.
D. Remove the icons and use red, yellow, and green background colors instead.
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power Bi service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows. When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?
A. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
B. In the dataset, delete the fact table.
C. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
D. From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.
You have the following code in a cell in an Azure Synapse notebook.
You need to replace the comment on the first line of the code with the correct magic command. Which magic command should you use?
A. %%sparkr
B. %%pyspark
C. %%spark
D. %%sql
The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?
A. Use Performance analyzer in Power BI Desktop to get the DAX durations.
B. Use DAX Studio to get detailed statistics on the server timings.
C. Use DAX Studio to review the Vertipaq Analyzer metrics.
D. Use Tabular Editor to create calculation groups.
You have an Azure Synapse Analytics notebook.
You run the %%sql magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.
display(df1, summary = true)
Which three attributes will be returned by the command? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. type
B. range
C. missing
D. unique
E. ordinal
You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model.
You change a fact table named Table1 into a hybrid table.
What else occurred on DM1 automatically after the change?
A. Table1 was removed from the scheduled refresh.
B. Dimension tables that relate to Table1 were changed to dual storage mode.
C. A related aggregation table was created.
D. A DirectQuery partition was added to Table1.
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 change the IoT DateTime column to the date data type.
Does this meet the goal?
A. Yes
B. No
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse. What should you include in the recommendation?
A. Azure Purview
B. Site-to-Site VPN
C. an XMLA endpoint
D. the on-premises data gateway
