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...

September 7, 2024No CommentsREAD MORE +

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...

September 5, 2024No CommentsREAD MORE +

What should you configure in the deployment pipeline?

What should you configure in the deployment pipeline?A . a backward deploymentB . a selective deploymentC . auto-bindingD . a data source ruleView AnswerAnswer: D Explanation: Development Process Requirements Litware identifies the following development process requirements: SQLDW and datalake1 will act as the development environment. Once feature development is complete,...

September 4, 2024No CommentsREAD MORE +

How should you complete the Python code?

HOTSPOT You are creating a Power Bl Desktop report. You add a Python visual to the report page. You plan to create a scatter chart to visualize the data. You add Python code to the Python script editor. You need to create the scatter chart. How should you complete the...

September 4, 2024No CommentsREAD MORE +

Which tenant setting should you recommend disabling?

You need to recommend changes to the Power Bl tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?A . Allow shareable links to grant access to everyone in your organizationB . Allow Azure Active Directory guest users to edit and manage content...

September 3, 2024No CommentsREAD MORE +

How should you complete the DAX expression for the Actuals measure?

DRAG DROP You have a Power Bl dataset that contains the following measures: • Budget • Actuals • Forecast You create a report that contains 10 visuals. You need provide users with the ability to use a slicer to switch between the measures in two visuals only. You create a...

September 2, 2024No CommentsREAD MORE +

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...

September 1, 2024No CommentsREAD MORE +

You have a Power Bl dataset that has the query dependencies shown in the following exhibit

HOTSPOT You have a Power Bl dataset that has the query dependencies 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. View AnswerAnswer: Explanation: Box...

September 1, 2024No CommentsREAD MORE +

What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources: • A CSV file in an Azure Storage account • An Azure Database for PostgreSQL database You plan to use...

August 31, 2024No CommentsREAD MORE +

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...

August 31, 2024No CommentsREAD MORE +