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

You have a Power Bl workspace named workspace1 that contains three reports and two dataflows.

You have an Azure Data Lake Storage account named storage1.

You need to integrate workspace1 and storage1.

What should you do first?

HOTSPOT

You have a Power Bl tenant that is configured as 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 answer is worth one point.

DRAG DROP

You have a Power Bl data model that contains two tables named Products and Sales.

A one-to-many relationship exists between the tables.

You have a report that contains a report-level filter for Products.

You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.

How should you complete the measure? To answer, drag the appropriate DAX functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

You have an Azure Synapse Analytics notebook.

You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.

display (df1, summary = true)

Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.

You discover that the model fails to process a source time field.

You need to ensure that the model processes the field.

Solution: You add a Power Query step to convert the time column into an integer column that represents the number of seconds.

Does this meet the requirement?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question se might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.

You discover that the model fails to process a source time field.

You need to ensure that the model processes the field.

Solution: You add a Power Query step to convert the time column into an integer column that represents the number of minutes.

Does this meet the requirement?

HOTSPOT

You have an app named App1 that processes loan applications. App1 is connected to an Azure Synapse Analytics dedicated SQL pool.

You need to score the quality of the loan applications.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have the following Power Bl query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model. You discover that the model fails to process a source time field. You need to ensure that the model processes the field.

Solution: You convert the time column into the Text data type.

Does this meet the requirement?