DP-500 Dump Free – 50 Practice Questions to Sharpen Your Exam Readiness.
Looking for a reliable way to prepare for your DP-500 certification? Our DP-500 Dump Free includes 50 exam-style practice questions designed to reflect real test scenarios—helping you study smarter and pass with confidence.
Using an DP-500 dump free set of questions can give you an edge in your exam prep by helping you:
- Understand the format and types of questions you’ll face
- Pinpoint weak areas and focus your study efforts
- Boost your confidence with realistic question practice
Below, you will find 50 free questions from our DP-500 Dump Free collection. These cover key topics and are structured to simulate the difficulty level of the real exam, making them a valuable tool for review or final prep.
You open a Power BI Desktop report that contains an imported data model and a single report page. You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit.What can you identify from the results?
A. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
B. The Actual/Forecast Billable Hrs YTD visual displays the most data.
C. Unoptimized DAX queries cause the page to load slowly.
D. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
DRAG DROP - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - Existing environment - Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries. Azure Resources - Litware has the following Azure resources: An Azure Synapse Analytics workspace named synapseworkspace1 An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1 A Synapse Analytics dedicated SQL pool named SQLDW Dedicated SQL Pool - SQLDW contains a dimensional model that contains the following tables.SQLDW contains the following additional tables.
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customerID], dbo.Customer [CustomerEmail], dbo.Product [ProductID] and dbo.Product [ProductName]. 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. Power BI - Litware has a new Power BI tenant that contains an empty workspace named Sales Analytics. All users have Power BI Premium per user licenses. IT data analytics are workspace administrators. The IT data analysts will create datasets and reports. A single imported dataset will be created to support the company’s sales analytics goals. The dataset will be refreshed every 30 minutes. Requirements - Analytics Goals - Litware identifies the following analytics goals: Provide historical reporting of sales by product and channel over time. Allow sales managers to perform ad hoc sales reporting with minimal effort. Perform market basket analysis to understand which products are commonly purchased in the same transaction. Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products. Litware plans to monitor the adoption of Power BI reports over time. The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month. Security Requirements - Litware identifies the following security requirements for the analytics environment: All the users in the sales department and the marketing department must be able to see Power BI reports that contain market basket analysis and data about which customers are likely to purchase a product. Customer contact data in SQLDW and the Power BI dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data. Sales associates must be prevented from seeing the CustomerEmail column in Power BI reports. Sales managers must be prevented from modifying reports created by other users. Development Process Requirements Litware identifies the following development process requirements: SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace. Power BI content must be deployed to test and production by using deployment pipelines. All SQL scripts must be stored in Azure Repos. The IT data analysts prefer to build Power BI reports in Synapse Studio. You need to create the customized Power BI usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort. 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.
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. JSON_VALUE
B. CONVERT
C. FIRST_VALUE
D. FOR_JSON
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. 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. Existing Environment - Data Infrastructure - Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines. The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data. Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently query the Synapse Analytics workspace by using Transact-SQL. User Problems - Contoso identifies the following user issues: Some users indicate that the visuals in Power BI reports are slow to render when making filter selections. Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded. 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. Planned Changes - Contoso plans to implement the following changes: Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API. 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. Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data. Deploy prebuilt datasets to Power BI to simplify the query experience of the customers. Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool. You need to identify the root cause of the data refresh issue. What should you use?
A. the Usage Metrics Report in powerbi.com
B. Query Diagnostics in Power Query Editor
C. Performance analyzer in Power BI Desktop
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - General Overview - Fabrikam, Inc. is a software company that develops educational software for higher education. Organizational Structure - Fabrikam has the following business units: • Finance and Accounting • Sales and Marketing • Operations • Product The Product business unit contains the following groups: • User experience designers • Software engineers • Product managers • Testers The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team. Existing Environment - Data Storage - Fabrikam has three Azure Synapse Analytics workspaces named workspace1prod, workspace1test, and workspace1dev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power BI. The company imports the following files into the Data Lake Storage accounts: • User experience data stored as JSON files • Finance data stored as CSV files • Sales data stored as CSV files Reporting - Fabrikam has a Power BI tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQueiy datasets. All reports are interactive. Fabrikam has three frequently used workspaces as shown in the following table.The Corporate Data Models workspace contains a dataset named Financial Model that is used by reports in the P&L workspace. Financial Model is maintained by the enterprise analytics team. The Corporate Data Models workspace and the User Experience workspace have corresponding development and test workspaces. User Problems - Administrators report an increase in the maintenance of Power BI tenant assets due to analysts in the Finance and Accounting business unit who create new Power BI datasets when the existing datasets already meet their needs. Analysts in the Product business unit report the following issues: • Datasets are published to the User Experience workspace, while the data sources reference workspace1test. • The parsing of user experience data in Power Query is very slow. The enterprise analytics team identifies two DAX measures in the Financial Model dataset that are consistently slow to execute. The team must identify all the reports that use the Financial Model dataset and notify the report owners of changes to the measures. Members of the enterprise analytics team report that creating Power BI reports and adjusting tables and views in Azure Synapse is tedious because they must switch between the Power BI workspaces and the Azure Synapse workspaces. The information security team identifies that the user experience data is being shared externally. Requirements - Planned Changes - Fabrikam plans to implement the following changes: • Power BI will be registered as a data source in Microsoft Purview. • The analysts in the Product business unit will create a more automated process for deploying Power BI reports and datasets to the User Experience workspace. The enterprise analytics team plans to perform the following tasks: • Update the DAX calculations in the Financial Model dataset. • Create views in the Azure Synapse workspaces to speed up the parsing of user experience data. • Create and document the change management process for shared Power BI datasets. Technical Requirements - From Microsoft Purview, analysts in all the business units must be able to see all the assets in the Power BI tenant and the Azure Synapse workspaces. Power BI asset information must include lineage to identify the data sources used by each report. The information security team must identify all the Power BI reports and datasets that contain Personally Identifiable Information (PII). Fabrikam requires a security solution for the Power BI tenant. The solution must meet the following requirements: • Access to the tenant by external users must be approved by a manager and granted by the IT group. • The external users must be prevented from publishing or modifying content in the tenant. • Users must be prevented from sharing Power BI reports publicly to the internet. 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. The IT group registers the Power BI tenant as a data source in Microsoft Purview. You need to ensure that all the analysts can view the assets in the Power BI tenant. The solution must meet the technical requirements for Microsoft Purview and Power BI. What should you do?
A. Create a scan.
B. Deploy a Power BI gateway.
C. Search the data catalog.
D. Create a linked service.
HOTSPOT - You are building a financial report by using Power BI. You have a table named financials that contains two columns named Date and Sales. You need to create a DAX measure that calculates the relative change in sales compared to the previous quarter. How should you complete the measure? To answer, select the appropriate options m the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. 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. Existing Environment - Data Infrastructure - Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines. The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data. Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently query the Synapse Analytics workspace by using Transact-SQL. User Problems - Contoso identifies the following user issues: Some users indicate that the visuals in Power BI reports are slow to render when making filter selections. Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded. 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. Planned Changes - Contoso plans to implement the following changes: Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API. 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. Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data. Deploy prebuilt datasets to Power BI to simplify the query experience of the customers. Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool. You need to build a Transact-SQL query to implement the planned changes for the internal users. How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. 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. Existing Environment - Data Infrastructure - Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines. The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data. Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently query the Synapse Analytics workspace by using Transact-SQL. User Problems - Contoso identifies the following user issues: Some users indicate that the visuals in Power BI reports are slow to render when making filter selections. Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded. 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. Planned Changes - Contoso plans to implement the following changes: Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API. 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. Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data. Deploy prebuilt datasets to Power BI to simplify the query experience of the customers. Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool. You need to recommend a solution to add new fields to the financial data Power BI dataset with data from the Microsoft SQL Server data warehouse. What should you include in the recommendation?
A. Azure Purview
B. an XMLA endpoint
C. Site-to-Site VPN
D. the on-premises data gateway
You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model. You change a fact table named Table1 into a hybrid table. What else occurred on DM1 automatically after the change?
A. Table1 was removed from the scheduled refresh.
B. Dimension tables that relate to Table1 were changed to dual storage mode.
C. A related aggregation table was created.
D. A DirectQuery partition was added to Table1.
You have a Power BI workspace that contains one dataset and four reports that connect to the dataset. The dataset uses import storage mode and contains the following data source: A CSV file in an Azure Storage account. An Azure Database for PostgreSQL database. You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage. What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?
A. auto-binding across pipelines
B. data source rules
C. selective deployment
D. parameter rules
DRAG DROP - 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, 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 need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?
A. organizational account
B. Basic
C. Web API
D. Anonymous
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 BI Premium capacity. From the Power BI Premium Capacity Metrics app, you discover the following: • There is insufficient CPU to execute dataset refreshes. • Out-of-memory throttling occurs when the dataset is waiting. You need to recommend a solution to resolve the performance issues. Solution: You scale up the capacity. Does this meet the goal?
A. Yes
B. No
You have a Power BI 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?
A. In storage1, create a folder named dataflows.
B. Delete the dataflows from workspace1.
C. In storage1, create a folder named reports.
D. Delete the reports from workspace1.
HOTSPOT - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - Existing environment - Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries. Azure Resources - Litware has the following Azure resources: An Azure Synapse Analytics workspace named synapseworkspace1 An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1 A Synapse Analytics dedicated SQL pool named SQLDW Dedicated SQL Pool - SQLDW contains a dimensional model that contains the following tables.
You have a Power BI report that contains a single page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: • Switch the measures used in the visuals. • Change the visual type. • Add a legend. The solution must minimize development effort. What should you do?
A. Enable personalization for each visual.
B. Enable personalization for the report.
C. Create a bookmark for each acceptable combination of visual type, measure, and legend in the bar chart.
D. Edit the interactions between the three visuals.
DRAG DROP - You have a Power BI 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.
HOTSPOT - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - Existing environment - Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries. Azure Resources - Litware has the following Azure resources: An Azure Synapse Analytics workspace named synapseworkspace1 An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1 A Synapse Analytics dedicated SQL pool named SQLDW Dedicated SQL Pool - SQLDW contains a dimensional model that contains the following tables.
HOTSPOT - You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements: Code must always be merged to the main branch before being published, and the main branch must be used for publishing resources. The workspace templates must be stored in the publish branch. A branch named dev123 will be created to support the development of a new feature. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a Power BI tenant. You plan to publish 10 paginated reports that will be used by a team of business analysts. You need to create a new workspace for the reports. The solution must minimize costs. Which license mode should you select for the new workspace?
A. Pro
B. Premium per user
C. Embedded
D. Premium per capacity
DRAG DROP - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. 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. Existing Environment - Data Infrastructure - Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines. The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data. Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently query the Synapse Analytics workspace by using Transact-SQL. User Problems - Contoso identifies the following user issues: Some users indicate that the visuals in Power BI reports are slow to render when making filter selections. Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded. 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. Planned Changes - Contoso plans to implement the following changes: Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API. 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. Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data. Deploy prebuilt datasets to Power BI to simplify the query experience of the customers. Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool. You need to create Power BI 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.
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode. A database administrator reports a drastic increase in the number of queries sent from the Power BI service to an Azure SQL database since the creation of the deployment pipeline. An investigation into the issue identifies the following: One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows. When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset. You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production. What should you recommend?
A. Turn off auto refresh when publishing the dataset changes to the Power BI service.
B. In the dataset, change the fact table from an import table to a hybrid table.
C. Enable the large dataset storage format for workspace.
D. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.
You have a sales report as shown in the following exhibit.The sales report has the following characteristics: The measures are optimized. The dataset uses import storage mode. Data points, hierarchies, and fields cannot be removed or filtered from the report page. From powerbi.com, users experience slow load times when viewing the report. You need to reduce how long it takes for the report to load without affecting the data displayed in the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Change the report theme to monochromatic.
B. Replace the single-value cards with a multi-row card.
C. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.
D. Replace all the filters on the Filters pane with visual slicers on the report page.
HOTSPOT - You are building a Power BI dataset that contains a table named Calendar. Calendar contains the following calculated column.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.
After you answer a question in this question, 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 OPENROWSET 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. Yes
B. No
HOTSPOT - 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.
HOTSPOT - You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips. You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.How should you configure the chart? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a Power BI 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 the internal storage of Power BI.
B. Add the managed identity for Data Factory as a member of the workspaces.
C. Associate the Power BI tenant to an Azure Data Lake Storage account.
D. Create and save the dataflows to an Azure Data Lake Storage account.
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. explain
C. cov
D. corr
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - General Overview - Fabrikam, Inc. is a software company that develops educational software for higher education. Organizational Structure - Fabrikam has the following business units: • Finance and Accounting • Sales and Marketing • Operations • Product The Product business unit contains the following groups: • User experience designers • Software engineers • Product managers • Testers The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team. Existing Environment - Data Storage - Fabrikam has three Azure Synapse Analytics workspaces named workspace1prod, workspace1test, and workspace1dev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power BI. The company imports the following files into the Data Lake Storage accounts: • User experience data stored as JSON files • Finance data stored as CSV files • Sales data stored as CSV files Reporting - Fabrikam has a Power BI tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQueiy datasets. All reports are interactive. Fabrikam has three frequently used workspaces as shown in the following table.
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.
HOTSPOT - You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo.DimProduct. You need to write a query to meet the following requirements: • Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties. • Specify the quartile in which each product's list price falls within each product category. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You discover a poorly performing measure in a Power BI 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. Vertipaq Analyzer
C. DAX Studio
D. Performance analyzer in Power BI Desktop
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. 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. Existing Environment - Data Infrastructure - Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines. The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data. Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently query the Synapse Analytics workspace by using Transact-SQL. User Problems - Contoso identifies the following user issues: Some users indicate that the visuals in Power BI reports are slow to render when making filter selections. Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded. 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. Planned Changes - Contoso plans to implement the following changes: Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API. 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. Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data. Deploy prebuilt datasets to Power BI to simplify the query experience of the customers. Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool. You need to recommend a solution for the customer workspace 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. Publish the financial data to the web.
B. Configure the FinData workspace to use a Power BI Premium capacity.
C. Grant the Build permission for the financial data to each customer.
D. Set Use datasets across workspaces to Enabled.
You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement: Minimize development effort. Avoid including data in the file. Which type of file should you create?
A. PBIT
B. PBIDS
C. PBIX
You have two Power BI reports named Report1 and Report2. Report1 connects to a shared dataset named Dataset1. Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters. You need to prepare Report2 to use Dataset1. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Remove the data source permissions.
B. Delete all the Power Query Editor objects.
C. Modify the source of each query.
D. Update all the parameter values.
E. Delete all the calculated tables.
You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?
A. [UserPermissions] = USERPRINCIPALNAME()
B. [User] = USERPRINCIPALNAME()
C. [User] = USEROBJECTID()
D. [UserPermissions] = USERNAME()
E. [User] = USERNAME()
You have a Power BI tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1. You create a paginated report that does NOT use row-level security (RLS). You need to send a copy of the report to Group1 every Monday at 9 AM UTC. Which two actions should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Create a subscription for Group1.
B. Publish the paginated report to a Pro workspace.
C. Create a data alert for Group1.
D. Publish the paginated report to a Premium Per User workspace.
HOTSPOT - You have a Power BI tenant that uses a primary domain named fabrikam.com and contains a Power BI Premium workspace named Workspace1. Workspace1 contains a dataset named DS1. DS1 is an imported model that has one data source. You have a guest user named user1@contoso.com that is assigned the Contributor role for Workspace1. You need to ensure that User1 can connect to the XMLA endpoint of DS1. How should you complete the URL of the XMLA connection? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
After you answer a question in this question, 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 BI dataset named Dataset1. 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 Tabular Editor, you create a calculation group. Does this meet the goal?
A. Yes
B. No
HOTSPOT - You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is 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.
HOTSPOT - You are enhancing a Power BI model that has DAX calculations. You need to create a DAX measure that returns the year-to-date total sales from the same date from the previous calendar year. How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - Existing environment - Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries. Azure Resources - Litware has the following Azure resources: An Azure Synapse Analytics workspace named synapseworkspace1 An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1 A Synapse Analytics dedicated SQL pool named SQLDW Dedicated SQL Pool - SQLDW contains a dimensional model that contains the following tables.
You have a Power BI workspace named Workspace1 in a Premium capacity. Workspace1 contains a dataset. During a scheduled refresh, you receive the following error message: “Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB.” You need to ensure that you can refresh the dataset. What should you do?
A. Change License mode to Premium per user.
B. Turn on Large dataset storage format.
C. Connect Workspace1 to an Azure Data Lake Storage Gen2 account.
D. Change the location of the Premium capacity.
DRAG DROP - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview - General Overview - Fabrikam, Inc. is a software company that develops educational software for higher education. Organizational Structure - Fabrikam has the following business units: • Finance and Accounting • Sales and Marketing • Operations • Product The Product business unit contains the following groups: • User experience designers • Software engineers • Product managers • Testers The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team. Existing Environment - Data Storage - Fabrikam has three Azure Synapse Analytics workspaces named workspace1prod, workspace1test, and workspace1dev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power BI. The company imports the following files into the Data Lake Storage accounts: • User experience data stored as JSON files • Finance data stored as CSV files • Sales data stored as CSV files Reporting - Fabrikam has a Power BI tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQueiy datasets. All reports are interactive. Fabrikam has three frequently used workspaces as shown in the following table.
You are creating a Power BI single-page report. Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader. You need to ensure that the users can consume content on a report page in a logical order. What should you configure on the report page?
A. the X position
B. the bookmark order
C. the layer order
D. the tab order
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode. A database administrator reports a drastic increase in the number of queries sent from the Power BI service to an Azure SQL database since the creation of the deployment pipeline. An investigation into the issue identifies the following: One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows. When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset. You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production. What should you recommend?
A. From Capacity settings in the Power BI Admin portal, reduce the Max Intermediate Row Set Count setting.
B. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
C. Enable the large dataset storage format for workspace.
D. From Capacity settings in the Power BI Admin portal, increase the Max Intermediate Row Set Count setting.
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. PREDICT
B. CAST
C. GROUPING
D. PIVOT
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. rollup
B. cov
C. explain
D. describe
After you answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. 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 change the IoT DateTime column to the date data type. Does this meet the goal?
A. Yes
B. No
HOTSPOT - You use Power Query Editor to transform data. You need to create a function named ConvertF2C that accepts a temperature value in Fahrenheit and returns a temperature value in Celsius. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Access Full DP-500 Dump Free
Looking for even more practice questions? Click here to access the complete DP-500 Dump Free collection, offering hundreds of questions across all exam objectives.
We regularly update our content to ensure accuracy and relevance—so be sure to check back for new material.
Begin your certification journey today with our DP-500 dump free questions — and get one step closer to exam success!