Up To Date DP-500 Dumps For Designing And Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure And Microsoft Power BI Certification

NEW QUESTION 1

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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 2

You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
• Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
• Power Bl admins must identify updates or changes to the Power Bl capacity.
• The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 3

You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 4

You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.
What should you include in the recommendation?

• A. Azure Purview
• B. Site-to-Site VPN
• C. an XMLA endpoint
• D. the on-premises data gateway

Answer: D

NEW QUESTION 5

You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present the data distribution statistics from a DataFrame in a tabular view. Which method should you invoke on the DataFrame?

• A. freqltems
• B. explain
• C. rollup
• D. summary

Answer: D

NEW QUESTION 6

What should you configure in the deployment pipeline?

• A. a backward deployment
• B. a selective deployment
• C. auto-binding
• D. a data source rule

Answer: C

NEW QUESTION 7

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

Answer: C

NEW QUESTION 8

You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 9

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 10

You have a Power Bl dataset that has only the necessary fields visible for report development.
You need to ensure that end users see only 25 specific fields that they can use to personalize visuals. What should you do?

• A. From Tabular Editor, create a new role.
• B. Hide all the fields in the dataset.
• C. Configure object-level security (OLS).
• D. From Tabular Editor, create a new perspective.

Answer: B

NEW QUESTION 11

You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. The storage account must be protected by using an Azure Firewall.
• B. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
• C. The storage account must have hierarchical namespace enabled.
• D. Dataflows must exist already for any directly connected Power Bl workspaces.
• E. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

Answer: BC

NEW QUESTION 12

You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
Which four 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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 13

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

• A. PIVOT
• B. GROUPING
• C. PREDICT
• D. CAST

Answer: A

NEW QUESTION 14

You are configuring an aggregation table as shown in the following exhibit.

The detail table is named FactSales and the aggregation table is named FactSales(Agg). You need to aggregate SalesAmount for each store.
Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area,
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 15

You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes. What should you do first?

• A. Enable the XMLA endpoint.
• B. Define an incremental refresh policy.
• C. Change the storage mode of the dataset.
• D. Configure a scheduled refresh.

Answer: A

NEW QUESTION 16

You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?

• A. Tabular Editor
• B. Performance analyzer in Power Bl Desktop
• C. Vertipaq Analyzer
• D. DAX Studio

Answer: B

NEW QUESTION 17

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?

• A. JS0N_VALUE
• B. FOR.JSON
• C. CONVERT
• D. FIRST VALUE

Answer: A

NEW QUESTION 18
......