[Apr 30, 2023] Free Microsoft DP-500 Exam Questions and Answer
Verified DP-500 dumps Q&As Latest DP-500 Download
The Microsoft DP-500 certification exam is recognized worldwide as a leading certification for professionals who work with Microsoft Azure and Microsoft Power BI. This certification demonstrates a candidate's deep understanding of the latest technologies and best practices for designing, implementing, and maintaining large-scale data solutions using Microsoft's cloud-based platform.
The DP-500 exam covers a wide range of topics related to enterprise-scale analytics solutions, including data processing and storage, data visualization and reporting, and machine learning. Candidates will need to demonstrate their ability to work with different types of data sources, design efficient data processing workflows, and create reports and dashboards that provide insights into complex data sets. They will also need to show their proficiency in using Azure services such as Azure Data Factory, Azure Synapse Analytics, and Azure Machine Learning.
NEW QUESTION # 58
You have an Azure Synapse Analytics serverless SQL pool.
You need to return a list of files and the number of rows in each file.
How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the targets. Each value 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
NEW QUESTION # 59
Your company is migrating its current, custom-built reporting solution to Power BI.
The Power BI tenant must support the following scenarios:
40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.
Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
You need to recommend a licensing solution for the company. The solution must minimize costs.
Which two Power BI license options should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. one Premium
- B. 70 Pro
- C. 70 Premium per user
- D. 35 Premium per user
- E. one Embedded
- F. 35 Pro
Answer: A,D
Explanation:
B:
Free - 40 reports that will be embedded in external websites. The websites control their own security.
Free - The reports will be consumed by 50 users monthly.
Free + 1 Premium for the Worspace -Forty-five users that require access to the workspaces and apps in the Power BI Admin portal.
F: Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
Power BI Premium per user features and capabilities
* Pixel perfect paginated reports are available for operational reporting capabilities based on SSRS technology. Users can create highly formatted reports in various formats such as PDF and PPT, which are embeddable in applications and are designed to be printed or shared.
Note: There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User.
Power BI (free): Access to content in My Workspace
Power BI (free) + Workspace is Premium: Consume content shared with them Power BI Pro: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Pro license Power BI Pro + Workspace is Premium: Distribute content to users who have free licenses Power BI Premium Per User: Publish content to other workspaces, share dashboards, subscribe to dashboards and reports, share with users who have a Premium Per User license Power BI Premium Per User + Workspace is Premium: Distribute content to users who have free and Pro licenses
NEW QUESTION # 60
You have a Power Bl report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency. What should you do?
- A. Add icons to represent the sales status of each product.
- B. Change the red background color to orange.
- C. Add additional measures to the table values.
- D. Change the font color of values in the Sales column to white.
Answer: D
Explanation:
Themes, contrast and colorblind-friendly colors
You should ensure that your reports have enough contrast between text and any background colors.
Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish. These include the following combinations:
**---> green and black
green and red
green and brown
blue and purple
green and blue
light green and yellow
blue and grey
green and grey
Avoid using these colors together in a chart, or on the same report page.
NEW QUESTION # 61
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. Yes
- B. No
Answer: B
Explanation:
Instead denormalize For Performance.
Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.
NEW QUESTION # 62
You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Row-level security (RLS) is missing from the dataset.
- B. The workspace is in shared capacity.
- C. Dataset certification is disabled for the Power Bl tenant.
- D. You have insufficient permissions.
- E. The sensitivity level for the dataset is set to Highly Confidential.
Answer: C,D
Explanation:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorsement-overview Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content
NEW QUESTION # 63
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. Denormalize the tables in DB1.
- B. Create calculated columns in Dataset1.
- C. Remove the relationships from Dataset1.
- D. Normalize the tables in DB1.
Answer: D
NEW QUESTION # 64
You need to identify the root cause of the data refresh issue.
What should you use?
- A. Query Diagnostics in Power Query Editor
- B. Performance analyzer in Power Bl Desktop
- C. the Usage Metrics Report in powerbi.com
Answer: A
Explanation:
Users indicate that the data in Power BI reports is stale. You discover that the refresh process of the Power BI model occasionally times out.
With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop. While we'll be expanding on this feature in the future, including adding the ability to use it during full refreshes, at this time you can use it to understand what sort of queries you're emitting, what slowdowns you might run into during authoring refresh, and what kind of background events are happening.
NEW QUESTION # 65
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. Execute foldable operations before non-foldable operations.
- B. Place the ingestion operations and transformation operations in separate dataflows.
- C. Execute non-foldable operations before foldable operations.
- D. Reduce the memory assigned to the dataflows.
- E. Place the ingestion operations and transformation operations in a single dataflow.
Answer: A,E
NEW QUESTION # 66
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. Yes
- B. No
Answer: A
Explanation:
Query Parquet files using serverless SQL pool in Azure Synapse Analytics.
Important
Ensure you are using a UTF-8 database collation (for example Latin1_General_100_BIN2_UTF8) because string values in PARQUET files are encoded using UTF-8 encoding. A mismatch between the text encoding in the PARQUET file and the collation may cause unexpected conversion errors. You can easily change the default collation of the current database using the following T-SQL statement: alter database current collate Latin1_General_100_BIN2_UTF8'.
Note: If you use the Latin1_General_100_BIN2_UTF8 collation you will get an additional performance boost compared to the other collations. The Latin1_General_100_BIN2_UTF8 collation is compatible with parquet string sorting rules. The SQL pool is able to eliminate some parts of the parquet files that will not contain data needed in the queries (file/column-segment pruning). If you use other collations, all data from the parquet files will be loaded into Synapse SQL and the filtering is happening within the SQL process. The Latin1_General_100_BIN2_UTF8 collation has additional performance optimization that works only for parquet and CosmosDB. The downside is that you lose fine-grained comparison rules like case insensitivity.
NEW QUESTION # 67
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. Create and save the dataflows to an Azure Data Lake Storage account.
- B. Create and save the dataflows to the internal storage of Power BL
- C. Associate the Power Bl tenant to an Azure Data Lake Storage account.
- D. Add the managed identity for Data Factory as a member of the workspaces.
Answer: C,D
NEW QUESTION # 68
How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?
- A. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.
- B. an incremental refresh of Product where the ModifiedDate value is during the last three days.
- C. a full refresh of all the tables
- D. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.
Answer: A
Explanation:
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Overview
Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.
NEW QUESTION # 69
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 70
You have a Power Bl report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users.
What should you do?
- A. From Tabular Editor, create a new perspective.
- B. From Visual options in Report settings, select Use the modern visual header with updated styling options.
- C. From Report setting, select Personalize visuals.
- D. From the Bookmarks pane, select Focus mode, and then select Add.
Answer: C
Explanation:
Enable personalization in a report
You can enable the feature either in Power BI Desktop or the Power BI service. You can also enable it in embedded reports.
To enable the feature in Power BI Desktop, go to File > Options and settings > Options > Current file > Report settings. Make sure Personalize visuals is turned on.
NEW QUESTION # 71
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 Bl dataset named Datasetl.
In Datasetl, 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 Power Bl Desktop, you group the measures in a display folder.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
Explanation:
Solution: From DAX Studio, you write a query that uses grouping sets.
A grouping is a set of discrete values that are used to group measure fields.
NEW QUESTION # 72
You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Grant the Build permission for the financial data to each customer.
- B. Configure the FinData workspace to use a Power Bl Premium capacity.
- C. Set Use datasets across workspaces to Enabled
- D. Publish the financial data to the web.
Answer: B,C
Explanation:
Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace
NEW QUESTION # 73
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 # 74
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. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
- D. Enable service principal authentication for read-only admin APIs.
Answer: A,B
Explanation:
Optimize datasets for write operations by enabling large models
When using the XMLA endpoint for dataset management with write operations, it's recommended you enable the dataset for large models. This reduces the overhead of write operations, which can make them considerably faster. For datasets over 1 GB in size (after compression), the difference can be significant.
Tabular Editor supports Azure Analysis Services and Power BI Premium Datasets through XMLA read/write.
Note: Tabular Editor - An open-source tool for creating, maintaining, and managing tabular models using an intuitive, lightweight editor. A hierarchical view shows all objects in your tabular model. Objects are organized by display folders with support for multi-select property editing and DAX syntax highlighting. XMLA read-only is required for query operations. Read-write is required for metadata operations.
Reference:
https://tabulareditor.github.io/
NEW QUESTION # 75
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 # 76
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 # 77
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 78
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. FIRST VALUE
- B. CONVERT
- C. FOR.JSON
- D. JS0N_VALUE
Answer: D
NEW QUESTION # 79
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. Public
- B. None
- C. Organizational
- D. Private
Answer: D
NEW QUESTION # 80
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 # 81
You plan to generate a line chart to visualize and compare the last six months of sales data for two
departments. You need to increase the accessibility of the visual. What should you do?
- A. Replace long text with abbreviations and acronyms.
- B. Configure a distinct color for each series.
- C. Move important information to a tooltip.
- D. Configure a unique marker for each series.
Answer: D
NEW QUESTION # 82
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.
- A. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
- B. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
- C. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
- D. Create a managed identity in Azure Active Directory (Azure AD).
- E. Register a data source.
Answer: A,D,E
NEW QUESTION # 83
......
Use Real Dumps - 100% Free DP-500 Exam Dumps: https://freetorrent.braindumpsvce.com/DP-500_exam-dumps-torrent.html