Microsoft DP-500 Quiz:1 Topic:7 Questions:1-5

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 have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.

You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.

Which type of pool should you recommend?

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

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)

B)

C)

D)

You have a Power Bl workspace named Workspacel that contains five dataflows.

You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account

What should you do first?