Microsoft DP-500 Practice Test - Questions Answers, Page 5

You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement

• Minimize development effort.

• Avoid including data in the file.

Which type of file should you create?

You are planning a Power Bl solution for a customer.

The customer will have 200 Power Bl users. The customer identifies the following requirements:

• Ensure that all the users can create paginated reports.

• Ensure that the users can create reports containing Al visuals.

• Provide autoscaling of the CPU resources during heavy usage spikes.

You need to recommend a Power Bl solution for the customer. The solution must minimize costs.

What should you recommend?

You have a 2-GB Power Bl dataset.

You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.

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

NOTE: Each correct selection is worth one point

You have five Power Bl reports that contain R script data sources and R visuals.

You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.

What should you include in the solution?

You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.

• New reports can be embedded only in locations that require authentication.

• Live connections are permitted only for workspaces that use Premium capacity datasets.

Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have an Azure Synapse Analytics serverless SQL pool.

You need to catalog the serverless SQL pool by using Azure Purview.

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

NOTE: Each correct selection is worth one point.

You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.

You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.

In which file format should you recommend storing the table data?

You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.

You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?