Certbus > Microsoft > Microsoft Certified: Azure Enterprise Data Analyst Associate > DP-500 > DP-500 Online Practice Questions and Answers

DP-500 Online Practice Questions and Answers

Questions 4

DRAG DROP

You have a shared dataset in Power Bl named Dataset1.

You have an on-premises Microsoft SQL Server database named DB1.

You need to ensure that Dataset1 refreshes data from DB1.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Select and Place:

Browse 181 Q&As
Questions 5

HOTSPOT

You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.

You have the following query in Power Query Editor.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point

Hot Area:

Browse 181 Q&As
Questions 6

HOTSPOT

You have the Power BI workspaces 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.

Hot Area:

Browse 181 Q&As
Questions 7

HOTSPOT

You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.

pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")

You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:

Returns the fiscal prior year-to-date value for [sales Amount]

Uses a fiscal year end of June 30

Produces no result for dates in the future

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

NOTE: Each correct selection is worth one point.

Hot Area:

Browse 181 Q&As
Questions 8

HOTSPOT

You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code. NOTE: Each correct selection is worth one point.

Hot Area:

Browse 181 Q&As
Questions 9

HOTSPOT

You are using an Azure Synapse notebook to create a Python visual.

You run the following code cell to import a dataset named Iris.

A sample of the data is shown in the following table.

You need to create the visual shown in the exhibit. (Click the Exhibit tab.)

How should you complete the Python code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Hot Area:

Browse 181 Q&As
Questions 10

You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Reduce the memory assigned to the dataflows.

B. Execute non-foldable operations before foldable operations.

C. Execute foldable operations before non-foldable operations.

D. Place the ingestion operations and transformation operations in a single dataflow.

E. Place the ingestion operations and transformation operations in separate dataflows.

Browse 181 Q&As
Questions 11

You are creating a Python visual in Power Bl Desktop.

You need to retrieve the value of a column named Unit Price from a DataFrame.

How should you reference the Unit Price column in the Python code?

A. pandas.DataFrame('Unit Price')

B. dataset['Unit Price']

C. data = [Unit Price]

D. ('Unit Price')

Browse 181 Q&As
Questions 12

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?

A. Create calculated columns in Dataset1.

B. Remove the relationships from Dataset1.

C. Normalize the tables in DB1.

D. Denormalize the tables in DB1.

Browse 181 Q&As
Questions 13

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?

A. JSON

B. Apache Parquet

C. CSV

D. Delta

Browse 181 Q&As
Questions 14

You have a Power Bl dataset named Datasetl.

In Dataset1, you currently have 50 measures that use the same time intelligence logic.

You need to reduce the number of measures, while maintaining the current functionality.

Solution: From DAX Studio, you write a query that uses grouping sets.

Does this meet the goal?

A. Yes

B. No

Browse 181 Q&As
Questions 15

You have a development workspace in the Power BI service.

You plan to use Tabular Editor to develop and deploy a new dataset, and then use Power BI Desktop to create and publish a report to the Power BI service.

Which three components should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. the Read Write XMLA endpoint in a capacity

B. a Premium Per User workspace

C. the Read Write XMLA endpoint in the tenant

D. a .pbix file that has an imported dataset

E. a .pbix file that has a live connection

Browse 181 Q&As
Questions 16

The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.

You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace.

What should you do?

A. From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.

B. From the Corporate Data Models and User Experience workspace, set License mode to Premium per user.

C. From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.

D. From the Developer settings, set Allow service principals to use Power BI APIs to Enable.

Browse 181 Q&As
Questions 17

The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?

A. Use Performance analyzer in Power BI 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 Vertipaq Analyzer metrics.

D. Use Tabular Editor to create calculation groups.

Browse 181 Q&As
Questions 18

From Power Query Editor, you profile the data shown in the following exhibit.

The IoT GUID and IoT ID columns are unique to each row in the query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You split the IoT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

A. Yes

B. No

Browse 181 Q&As
Exam Code: DP-500
Exam Name: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Last Update: Mar 25, 2024
Questions: 181 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99