This page was exported from Exam for engine [ http://blog.test4engine.com ] Export date:Mon Nov 18 2:51:59 2024 / +0000 GMT ___________________________________________________ Title: [Mar-2023] Microsoft DP-500 Official Cert Guide PDF [Q17-Q35] --------------------------------------------------- [Mar-2023] Microsoft DP-500 Official Cert Guide PDF Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI - Test4Engine What is the salary of Microsoft DP-500 Certified Professional The average salary in different countries for Microsoft DP-500 Certified Professional UK: 60,000 PoundsIND: 10,00,000 INRUS: 106,000 USD   QUESTION 17You manage a dataset that contains the two data sources as shown in the following table.When you attempt to refresh the dataset in powerbi.com, you receive the following error message: “[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.” You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.You need to resolve the error. The solution must provide the highest privacy possible.Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. QUESTION 18You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement* Minimize development effort.* Avoid including data in the file.Which type of file should you create?  PBIDS  PBIX  PBIT A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.A PBIT file acts as a Power BI template. It doesn’t include any data from your source systems.QUESTION 19You 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.  Set Use datasets across workspaces to Enabled  Publish the financial data to the web.  Grant the Build permission for the financial data to each customer.  Configure the FinData workspace to use a Power Bl Premium capacity. 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 workspaceQUESTION 20Note: 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?  Yes  No 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.QUESTION 21You have five Power Bl reports that contain R script data sources and R visuals.You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.What should you include in the solution?  a Power Bl Embedded capacity  an on-premises data gateway (standard mode)  a workspace that connects to an Azure Data Lake Storage Gen2 account  an on-premises data gateway (personal mode) To schedule refresh of your R visuals or dataset, enable scheduled refresh and install an on-premises data gateway (personal mode) on the computer containing the workbook and R.QUESTION 22You 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. Reference:https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspacesQUESTION 23Note: This question is part of a series of questions that present the same scenario. Each question in the seriescontains a unique solution that might meet the stated goals. Some question sets might have more than onecorrect 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 questionswill not appear in the review screen.You have a Power Bl 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 Power Bl Desktop, you create a hierarchy.Does this meet the goal?  Yes  No QUESTION 24You have a Power Bl data model.You need to refresh the data from the source every 15 minutes.What should you do first?  Enable the XMLA endpoint.  Define an incremental refresh policy.  Change the storage mode of the dataset.  Configure a scheduled refresh. You cannot schedule a refresh on 15-minute increments. Only 30, unless using XMLA endpoint.QUESTION 25Note: 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 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?  Yes  No 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.QUESTION 26You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.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. 1 – From Power BI Desktop, create a role for the sales associates.2 – From Tabular Editor, set Object Level Security to None for the Customer[Email] column and save the changes.3 – From Power Bl Desktop, publish the dataset to the sales analytics workspace.QUESTION 27Note: This question is part of a scries of questions that present the same scenario. Each question in the seriescontains a unique solution that might meet the stated goals. Some question sets might have more than onecorrect 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 questionswill 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?  Yes  No QUESTION 28You 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?  From Report setting, select Personalize visuals.  From Tabular Editor, create a new perspective.  From the Bookmarks pane, select Focus mode, and then select Add.  From Visual options in Report settings, select Use the modern visual header with updated styling options. Enable personalization in a reportYou 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.QUESTION 29You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. Thedataset uses Import storage mode and contains the following data sources:* A CSV file in an Azure Storage account* An Azure Database for PostgreSQL databaseYou plan to use deployment pipelines to promote the content from development to test to production. Therewill be different data source locations for each stage. What should you include in the deployment pipeline toensure that the appropriate data source locations are used during each stage?  parameter rules  selective deployment  auto-binding across pipelines  data source rules QUESTION 30You 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?  [UserPermissions] – USERNAME()  [UserPermissions] – USERPRINCIPALNAME()  [User] = USERPRINCIPALNAME()  [User] = USERNAME()  [User] = USEROBJECTID() USERNAME() returns the domain name and username from the credentials given to the system at connection time.It should be compared to column name of User, which in DAX is expressed through [User].QUESTION 31You are implementing a reporting solution that has the following requirements:* Reports for external customers must support 500 concurrent requests. The data for these reports isapproximately 7 GB and is stored in Azure Synapse Analytics.* Reports for the security team use data that must have local security rules applied at the database level torestrict access. The data being reviewed is 2 GB.Which storage mode provides the best response time for each group of users?  DirectQuery for the external customers and import for the security team.  DirectQuery for the external customers and DirectQuery for the security team.  Import for the external customers and DirectQuery for the security team.  Import for the external customers and import for the security team. QUESTION 32You 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.  The workspace is in shared capacity.  You have insufficient permissions.  Dataset certification is disabled for the Power Bl tenant.  The sensitivity level for the dataset is set to Highly Confidential.  Row-level security (RLS) is missing from the dataset. 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-contentQUESTION 33You have a Power BI workspace named Workspace1 that contains five dataflows.You need to configure Workspace1 to store the dataflows in an Azure Data Lake Storage Gen2 account.What should you do first?  Delete the dataflow queries.  From the Power Bl Admin portal, enable tenant-level storage.  Disable load for all dataflow queries.  Change the Data source settings in the dataflow queries. Configuring Azure connections is an optional setting with additional properties that can optionally be set:* Tenant Level storage, which lets you set a default, and/or* Workspace-level storage, which lets you specify the connection per workspace You can optionally configure tenant-level storage if you want to use a centralized data lake only, or want this to be the default option.QUESTION 34You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need tomodify the source control solution to use an Azure DevOps Git repository. What should you do first?  Disconnect from the GitHub repository.  Create a new pull request.  Change the workspace to live mode.  Change the active branch. QUESTION 35You 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.  Change the report theme to monochromatic.  Replace the single-value cards with a multi-row card.  Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.  Replace all the filters on the Filters pane with visual slicers on the report page.  Loading … Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Candidates for this exam should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data. Passing score: 700. Learn more about exam scores. Part of the requirements for: Microsoft Certified: Azure Enterprise Data Analyst Associate Download exam skills outline What is the exam cost of Microsoft DP-500 Certification The exam cost of Microsoft DP-500 Certification is $165   Free DP-500 Exam Dumps to Improve Exam Score: https://www.test4engine.com/DP-500_exam-latest-braindumps.html --------------------------------------------------- Images: https://blog.test4engine.com/wp-content/plugins/watu/loading.gif https://blog.test4engine.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-03-24 15:42:29 Post date GMT: 2023-03-24 15:42:29 Post modified date: 2023-03-24 15:42:29 Post modified date GMT: 2023-03-24 15:42:29