- All Exams Instant Download
What should you do?
HOTSPOT You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements: • Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource • The workspace templates must be stored...
You have the following code in an Azure Synapse notebook
HOTSPOT You have the following code in an Azure Synapse notebook. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: stacked bar chart matplotlib.pyplot.bar makes...
What should you use?
You need to identify the root cause of the data refresh issue. What should you use?A . the Usage Metrics Report in powerbi.comB . Query Diagnostics in Power Query EditorC . Performance analyzer in Power Bl DesktopView AnswerAnswer: B Explanation: Users indicate that the data in Power BI reports is...
Which two settings should you select?
You have a Power Bl dataset that uses DirectQuery against an Azure SQL database. Multiple reports use the dataset. A database administrator reports that too many queries are being sent from Power Bl to the database. You need to reduce the number of queries sent to the database. The solution...
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Synapse StudioB . DAX StudioC . Azure Data StudioD . Performance analyzer in Power Bl DesktopView AnswerAnswer: BD...
Which two settings should you configure in the Customize theme window?
You are configuring a Power Bl report for accessibility as shown in the following table. You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window?...
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl service?
Topic 4, Misc. Questions 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...
What should the team do first?
The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?A . Use Performance analyzer in Power Bl 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...
Which method should you invoke on the DataFrame?
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present the data distribution statistics from a DataFrame in a tabular view. Which method should you invoke on the DataFrame?A . freqltemsB . explainC . rollupD . describeView AnswerAnswer: D Explanation: The...
What should you do?
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements. What should you do?A . Grant the sales managers the Build permission for the existing Power Bl datasets.B . Grant the sales managers admin access to the existing Power Bl workspace.C . Create a deployment...
