The Best Microsoft DP-500 Study Guides and Dumps of 2022
Top Microsoft DP-500 Exam Audio Study Guide! Practice Questions Edition
NEW QUESTION 19
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)
- A. Option C
- B. Option B
- C. Option A
- D. Option D
Answer: C
NEW QUESTION 20
You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to
modify the source control solution to use an Azure DevOps Git repository. What should you do first?
- A. Change the workspace to live mode.
- B. Change the active branch.
- C. Create a new pull request.
- D. Disconnect from the GitHub repository.
Answer: D
NEW QUESTION 21
You have a Power Bl report that contains the table shown in the following exhibit.
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota
for returns. You need to ensure that the table is accessible to consumers of reports who have color vision
deficiency. What should you do?
- A. Move the conditional formatting icons to a tooltip report.
- B. Add alt text to explain the information that each color conveys.
- C. Change the icons to use a different shape for each color.
- D. Remove the icons and use red, yellow, and green background colors instead.
Answer: D
NEW QUESTION 22
You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
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.
Answer:
Explanation:
NEW QUESTION 23
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 the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)
Users indicate that when they build reports from the data model, the reports take a long time to load.
You need to recommend a solution to reduce the load times of the reports.
Solution: You recommend normalizing the data model.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
NEW QUESTION 24
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.
Answer:
Explanation:
NEW QUESTION 25
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.
Answer:
Explanation:
NEW QUESTION 26
You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is
expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl
service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Publish the complete dataset.
- B. Increase the Max Offline Dataset Size setting.
- C. Invoke a refresh to load historical data based on the incremental refresh policy.
- D. Publish an initial dataset that is less than 10 GB.
- E. Restart the capacity.
Answer: A,E
NEW QUESTION 27
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. Normalize the tables in DB1.
- B. Remove the relationships from Dataset1.
- C. Denormalize the tables in DB1.
- D. Create calculated columns in Dataset1.
Answer: A
NEW QUESTION 28
Note: This question is part of a scries 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 the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)
Users indicate that when they build reports from the data model, the reports take a long time to load.
You need to recommend a solution to reduce the load times of the reports.
Solution: You recommend creating a perspective that contains the commonly used fields.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION 29
You need to create Power Bl reports that will display data based on the customers' subscription level.
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.
Answer:
Explanation:
NEW QUESTION 30
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
Answer:
Explanation:
NEW QUESTION 31
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
- A. Turn on Large dataset storage format.
- B. Enable XMLA read-write.
- C. Enable service principal authentication for read-only admin APIs.
- D. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
Answer: B
NEW QUESTION 32
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. the on-premises data gateway
- C. an XMLA endpoint
- D. Site-to-Site VPN
Answer: B
NEW QUESTION 33
You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication.
You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?
- A. None
- B. Public
- C. Organizational
- D. Private
Answer: D
NEW QUESTION 34
You have a Power Bl tenant that contains 10 workspaces.
You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can
access the resulting data by using Azure Data Factory.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. Add the managed identity for Data Factory as a member of the workspaces.
- B. Create and save the dataflows to an Azure Data Lake Storage account.
- C. Create and save the dataflows to the internal storage of Power BL
- D. Associate the Power Bl tenant to an Azure Data Lake Storage account.
Answer: A,D
NEW QUESTION 35
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.
Answer:
Explanation:
NEW QUESTION 36
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.
Answer:
Explanation:
NEW QUESTION 37
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 using openrowset with to explicitly specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION 38
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 using openrowset with to explicitly define the collation for businessName and
surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
NEW QUESTION 39
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 40
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. summary
- B. rollup
- C. explain
- D. freqltems
Answer: A
NEW QUESTION 41
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.
Answer:
Explanation:
NEW QUESTION 42
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.
Answer:
Explanation:
NEW QUESTION 43
......
Valid DP-500 Exam Updates - 2022 Study Guide: https://www.dumpsking.com/DP-500-testking-dumps.html
DP-500 Certification - The Ultimate Guide: https://drive.google.com/open?id=1tK17BAsvRU6D0Dbz6LcW8fQM8fLJEvkR
