This page was exported from Free Exam Dumps Collection [ http://free.examcollectionpass.com ] Export date:Fri Apr 11 19:31:40 2025 / +0000 GMT ___________________________________________________ Title: Maximum Grades By Making ready With DP-500 Dumps UPDATED 2023 [Q60-Q82] --------------------------------------------------- Maximum Grades By Making ready With DP-500 Dumps UPDATED 2023 Prepare DP-500 Exam Questions [2023] Recently Updated Questions NO.60 You 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. NO.61 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?  JS0N_VALUE  FOR.JSON  CONVERT  FIRST VALUE NO.62 After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.The queries use open row set and infer the schema shown in the following table.You need to recommend changes to the queries to reduce I/O reads and tempdb usage.Solution: You recommend using openrowset with to explicitly define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.Does this meet the goal?  Yes  No Query Parquet files using serverless SQL pool in Azure Synapse Analytics.ImportantEnsure you are using a UTF-8 database collation (for example Latin1_General_100_BIN2_UTF8) because string values in PARQUET files are encoded using UTF-8 encoding. A mismatch between the text encoding in the PARQUET file and the collation may cause unexpected conversion errors. You can easily change the default collation of the current database using the following T-SQL statement: alter database current collate Latin1_General_100_BIN2_UTF8′.Note: If you use the Latin1_General_100_BIN2_UTF8 collation you will get an additional performance boost compared to the other collations. The Latin1_General_100_BIN2_UTF8 collation is compatible with parquet string sorting rules. The SQL pool is able to eliminate some parts of the parquet files that will not contain data needed in the queries (file/column-segment pruning). If you use other collations, all data from the parquet files will be loaded into Synapse SQL and the filtering is happening within the SQL process. The Latin1_General_100_BIN2_UTF8 collation has additional performance optimization that works only for parquet and CosmosDB. The downside is that you lose fine-grained comparison rules like case insensitivity.NO.63 You have the Power BI workspaces shown in the following exhibit.Use the drop-down menus to select the answer choice that completes each statement based on the informationpresented in the graphic.NOTE: Each correct selection is worth one point. NO.64 You have a file named File1.txt that has the following characteristics:* A header row* Tab delimited values* UNIX-style line endingsYou need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.Which query should you execute?  Option A  Option B  Option C  Option D Use FIELDTERMINATOR =’t’ for tab.Use ROWTERMINATOR =’x0A ‘ for UNIX-style line endingsUse FIRSTROW= 2 for a header rowNote: Using Row TerminatorsThe row terminator can be the same character as the terminator for the last field. Generally, however, a distinct row terminator is useful. For example, to produce tabular output, terminate the last field in each row with the newline character (n) and all other fields with the tab character (t).If you want to output a line feed character only (LF) as the row terminator – as is typical on Unix and Linux computers – use hexadecimal notation to specify the LF row terminator. For example:bcp -r ‘0x0A’FIRSTROWFIRSTROW =first_row Specifies the number of the first row to load. The default is 1. This indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.Reference:https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sqlNO.65 You are planning a Power Bl solution for a customer.The customer will have 200 Power Bl users. The customer identifies the following requirements:* Ensure that all the users can create paginated reports.* Ensure that the users can create reports containing Al visuals.* Provide autoscaling of the CPU resources during heavy usage spikes.You need to recommend a Power Bl solution for the customer. The solution must minimize costs. What shouldyou recommend?  Power Bl Premium per user  a Power Bl Premium per capacity  Power Bl Pro per user  Power Bl Report Server NO.66 You 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. NO.67 You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.* New reports can be embedded only in locations that require authentication.* Live connections are permitted only for workspaces that use Premium capacity datasets.Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.  From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.  From the Premium per user settings, set XMLA Endpoint to Off.  From Embed Codes, delete all the codes.  From Capacity settings, set XMLA Endpoint to Read Write.  From Tenant settings, set Publish to web to Disable. Reference:https://powerbi.microsoft.com/en-us/blog/power-bi-february-service-updateNO.68 You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake Storage Gen2 account and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?  STRIMO_SPLIT  OPENOUERY  OPCNROWSET  OPEMDATASOURCE NO.69 You 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 of actions to the answer area and arrange them in the correct order. 1 – Create a web data source.2 – Expand the attributes.3 – Publish the model.NO.70 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. 1 – Create row-level security (RLS) roles.2 – Create a DAX expression3 – Add members to row-level security (RLS) roles.NO.71 Note: 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 NO.72 You have a Power Bl dataset that contains the following measure.You need to improve the performance of the measure without affecting the logic or the results. What should you do?  Replace both calculate functions by using a variable that contains the calculate function.  Remove the alternative result of blank( ) from the divide function.  Create a variable and replace the values for [sales Amount].  Remove “calendar'[Flag] = “YTD” from the code. NO.73 You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storagemode. You need to ensure that the report page updates all the visuals every 30 minutes. Which two actionsshould you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worthone point.  Enable Power Bl embedded.  Configure the data sources to use DirectQuery.  Configure the data sources to use a streaming dataset  Select Auto page refresh.  Enable the XMIA endpoint.  Add a Microsoft Power Automate visual to the report page. NO.74 You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.What are two possible causes of the issue? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.  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-contentNO.75 You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type 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. Reference:https://www.royalcyber.com/blog/data-services/dedicated-sql-pool-vs-serverless-sql/NO.76 You have a Power Bl report that contains the visual shown in the following exhibit.You need to make the visual more accessible to users who have color vision deficiency. What should you do?  Change the font color of values in the Sales column to white.  Change the red background color to orange.  Add icons to represent the sales status of each product.  Add additional measures to the table values. Themes, contrast and colorblind-friendly colorsYou should ensure that your reports have enough contrast between text and any background colors.Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish. These include the following combinations:**—> green and blackgreen and redgreen and brownblue and purplegreen and bluelight green and yellowblue and greygreen and greyAvoid using these colors together in a chart, or on the same report page.NO.77 Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)Users indicate that when they build reports from the data model, the reports take a long time to load.You need to recommend a solution to reduce the load times of the reports.Solution: You recommend normalizing the data model.Does this meet the goal?  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.NO.78 You have an Azure Synapse workspace named Workspace1.You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five How should you complete the code? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. NO.79 You need to create the customized Power Bl 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. 1 – From powerbi.com, create a new report..2 – Add a report measure3 – Add visuals to the report4 – Publish the report to the Sales Analytics workspaceNO.80 You 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. NO.81 You 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 NO.82 You have a Power Bl report that contains the visual shown in the following exhibit.You need to make the visual more accessible to users who have color vision deficiency. What should you do?  Change the font color of values in the Sales column to white.  Change the red background color to orange.  Add icons to represent the sales status of each product.  Add additional measures to the table values. Themes, contrast and colorblind-friendly colorsYou should ensure that your reports have enough contrast between text and any background colors.Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish. These include the following combinations:**—> green and blackgreen and redgreen and brownblue and purplegreen and bluelight green and yellowblue and greygreen and greyAvoid using these colors together in a chart, or on the same report page. Loading … Give push to your success with DP-500 exam questions: https://www.examcollectionpass.com/Microsoft/DP-500-practice-exam-dumps.html --------------------------------------------------- Images: https://free.examcollectionpass.com/wp-content/plugins/watu/loading.gif https://free.examcollectionpass.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-06-13 16:43:22 Post date GMT: 2023-06-13 16:43:22 Post modified date: 2023-06-13 16:43:22 Post modified date GMT: 2023-06-13 16:43:22