This page was exported from Latest Exam Prep [ http://certify.vceprep.com ] Export date:Sat Sep 21 11:39:26 2024 / +0000 GMT ___________________________________________________ Title: DP-500 PDF Dumps 2022 Exam Questions with Practice Test [Q46-Q70] --------------------------------------------------- DP-500 PDF Dumps 2022 Exam Questions with Practice Test Dumps for Free DP-500 Practice Exam Questions NEW QUESTION 46You need to save Power Bl dataflows in an Azure Storage account.Which two prerequisites are required to support the configuration? Each correct answer presents part of thesolution.NOTE: Each correct selection is worth one point.  The storage account must be protected by using an Azure Firewall.  The connection must be created by a user that is assigned the Storage Blob Data Owner role.  The storage account must have hierarchical namespace enabled.  Dataflows must exist already for any directly connected Power Bl workspaces.  The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces. NEW QUESTION 47You plan to generate a line chart to visualize and compare the last six months of sales data for twodepartments. You need to increase the accessibility of the visual. What should you do?  Replace long text with abbreviations and acronyms.  Configure a unique marker for each series.  Configure a distinct color for each series.  Move important information to a tooltip. NEW QUESTION 48You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that isexpected to consume 50 GB of memory.Which two actions should you perform to ensure that you can publish the model successfully to the Power Blservice? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.  Increase the Max Offline Dataset Size setting.  Invoke a refresh to load historical data based on the incremental refresh policy.  Restart the capacity.  Publish an initial dataset that is less than 10 GB.  Publish the complete dataset. NEW QUESTION 49Note: 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 NEW QUESTION 50After 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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet filesby using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded businessnames, 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 andsurveyName as Latim_Generai_100_BiN2_UTF8.Does this meet the goal?  Yes  No NEW QUESTION 51You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need toscore the dataset to identify the likelihood of an engine failure. Which function should you use in the query?  PIVOT  GROUPING  PREDICT  CAST NEW QUESTION 52You 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 onthe current users. What should you include in the DAX expression?  [UserPermissions] – USERNAME()  [UserPermissions] – USERPRINCIPALNAME()  [User] = USERPRINCIPALNAME()  [User] = USERNAMEQ()  [User] = USEROBJECTID() NEW QUESTION 53You have a Power Bl workspace named Workspacel that contains five dataflows.You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 accountWhat 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. NEW QUESTION 54You have the following code in an Azure Synapse notebook.Use the drop-down menus to select the answer choice that completes each statement based on the informationpresented in the code.NOTE: Each correct selection is worth one point. NEW QUESTION 55You need to create Power Bl reports that will display data based on the customers’ subscription level.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order. NEW QUESTION 56Note: 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 the Power BI 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 denormalizing the data model.Does this meet the goal?  Yes  No NEW QUESTION 57You have a Power Bl dataset that contains the following measures:* Budget* Actuals* ForecastYou create a report that contains 10 visuals.You need provide users with the ability to use a slicer to switch between the measures in two visuals only.You create a dedicated measure named cg Measure switch.How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriatevalues to the targets. Each value may be used once, more than once, or not at all. You may need to drag thesplit bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. NEW QUESTION 58You 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. NEW QUESTION 59You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the followingcalculated column.pfflag = IF(‘Calendar'[Date] < TOOAYQ, “Past”, “Future”)You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the followingrequirements:* 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 futureHow should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. NEW QUESTION 60Note: 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 Datasetl.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 DAX Studio, you write a query that uses grouping sets.Does this meet the goal?  Yes  No NEW QUESTION 61You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database namedDB1. 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 mustmaintain the current functionality. What should you include in the recommendation?  Create calculated columns in Dataset1.  Remove the relationships from Dataset1.  Normalize the tables in DB1.  Denormalize the tables in DB1. NEW QUESTION 62You 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 canaccess 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  Associate the Power Bl tenant to an Azure Data Lake Storage account.  Add the managed identity for Data Factory as a member of the workspaces.  Create and save the dataflows to an Azure Data Lake Storage account.  Create and save the dataflows to the internal storage of Power BL NEW QUESTION 63You need to integrate the external data source to support the planned changes.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order. NEW QUESTION 64You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from theMicrosoft SQL Server data warehouse.What should you include in the recommendation?  Azure Purview  Site-to-Site VPN  an XMLA endpoint  the on-premises data gateway NEW QUESTION 65After 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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet filesby using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded businessnames, survey names, and participant counts. The database is configured to use the default collation.The queries use open row set and infer the schema shown in the following table.You need to recommend changes to the queries to reduce I/O reads and tempdb usage.Solution: You recommend using openrowset with to explicitly specify the maximum length for businessNameand surveyName.Does this meet the goal?  Yes  No NEW QUESTION 66You discover a poorly performing measure in a Power Bl data model.You need to review the query plan to analyze the amount of time spent in the storage engine and the formulaengine.What should you use?  Tabular Editor  Performance analyzer in Power Bl Desktop  Vertipaq Analyzer  DAX Studio NEW QUESTION 67Note: 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 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 moving all the measures to a calculation group.Does this meet the goal?  Yes  No NEW QUESTION 68You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all theentities from two different collections by using the same service rootThe OData feed is still in development. The location of the feed will change once development is complete.The report will be published before the OData feed development is complete.You need to minimize development effort to change the data source once the location changes.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order. NEW QUESTION 69You 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 asshown 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. NEW QUESTION 70You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the ApacheParquet 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?  JS0N_VALUE  FOR.JSON  CONVERT  FIRST VALUE  Loading … Check your preparation for Microsoft DP-500 On-Demand Exam: https://www.vceprep.com/DP-500-latest-vce-prep.html --------------------------------------------------- Images: https://certify.vceprep.com/wp-content/plugins/watu/loading.gif https://certify.vceprep.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-08-29 09:20:38 Post date GMT: 2022-08-29 09:20:38 Post modified date: 2022-08-29 09:20:38 Post modified date GMT: 2022-08-29 09:20:38