Get Microsoft DP-500 Exam Dumps

You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake Storage Gen2 account and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)

The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)

You need to reduce the model size by eliminating invalid relationships.

Which column should you remove?

You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.

You need to review statistics for a DataFrame that includes:

The column name

The column type

The number of distinct values

Whether the column has missing values

Which function should you use?

You have two Power BI reports named Report1 and Report2.

Report1 connects to a shared dataset named Dataset1.

Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.

You need to prepare Report2 to use Dataset1.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Your company is migrating its current, custom-built reporting solution to Power BI.

The Power BI tenant must support the following scenarios:

40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.

Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.

Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.

You need to recommend a licensing solution for the company. The solution must minimize costs.

Which two Power BI license options should you include in the recommendation? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.