{"id":442,"date":"2022-09-29T13:46:19","date_gmt":"2022-09-29T13:46:19","guid":{"rendered":"https:\/\/exam.real4prep.com\/2022\/09\/29\/practice-test-for-dp-500-certification-real-2022-mock-exam-q16-q31\/"},"modified":"2022-09-29T13:46:19","modified_gmt":"2022-09-29T13:46:19","slug":"practice-test-for-dp-500-certification-real-2022-mock-exam-q16-q31","status":"publish","type":"post","link":"https:\/\/exam.real4prep.com\/ko\/2022\/09\/29\/practice-test-for-dp-500-certification-real-2022-mock-exam-q16-q31\/","title":{"rendered":"Practice Test for DP-500 Certification Real 2022 Mock Exam [Q16-Q31]"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;442&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Practice Test for DP-500 Certification Real 2022 Mock Exam [Q16-Q31]&quot;,&quot;width&quot;:&quot;113.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 113.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4\/5 - (2 votes)    <\/div>\n    <\/div>\n<p><span style=\"color: red;font-size: 18px\"><strong>Practice Test for DP-500 Certification Real 2022 Mock Exam<\/strong><\/span><\/p>\n<p><span style=\"color: red\"><strong>Prepare For Realistic DP-500 Dumps PDF &#8211; 100% Passing Guarantee<\/strong><\/span><\/p>\n<p><\/p>\n<h3>Schedule exam<\/h3>\n<p> <strong>Languages:<\/strong> English <\/p>\n<p> <strong>Retirement date:<\/strong> none <\/p>\n<p> This exam measures your ability to accomplish the following technical tasks: implement and manage a data analytics environment; query and transform data; implement and manage data models; and explore and visualize data. <\/p>\n<p><\/p>\n<h3>Skills measured<\/h3>\n<ul>\n<li>Implement and manage data models (25\u201330%)<\/li>\n<li>Implement and manage a data analytics environment (25\u201330%)<\/li>\n<li>Query and transform data (20\u201325%)<\/li>\n<li>Explore and visualize data (20\u201325%)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-167\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><strong>Q16.<\/strong> You need to integrate the external data source to support the planned changes.<br \/>Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of<br \/>actions to the answer area and arrange them in the correct order.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-0b7a4ee10893296b70304c3838b7ae95.jpg\"\/><\/p>\n<\/div><input type='hidden' name='question_id[]' value='3238' \/><textarea name='answer-3238[]' rows='5' cols='40' id='textarea_q_3238' class='watu-textarea watu-textarea-1'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-b08b37a686148a36d85f35b0cd27fc27.jpg\"\/><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(1,this)' id='btn-1' value='See Answer'  \/><input type='hidden' id='questionType1' value='textarea' class=''><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><strong>Q17.<\/strong> You are optimizing a Power Bl data model by using DAX Studio.<br \/>You need to capture the query events generated by a Power Bl Desktop report.<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3239' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12586' \/><div class='watu-question-choice'><input type='radio' name='answer-3239[]' id='answer-id-12586' class='answer answer-2 js-answer-label answerof-3239' value='12586' \/>&nbsp;<label for='answer-id-12586' id='answer-label-12586' class='js-answer-label answer label-2'><span class='answer'>the DMV list<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12587' \/><div class='watu-question-choice'><input type='radio' name='answer-3239[]' id='answer-id-12587' class='answer answer-2 js-answer-label answerof-3239' value='12587' \/>&nbsp;<label for='answer-id-12587' id='answer-label-12587' class='js-answer-label answer label-2'><span class='answer'>a Query Plan trace<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12588' \/><div class='watu-question-choice'><input type='radio' name='answer-3239[]' id='answer-id-12588' class='answer answer-2 js-answer-label answerof-3239' value='12588' \/>&nbsp;<label for='answer-id-12588' id='answer-label-12588' class='js-answer-label answer label-2'><span class='answer'>an All Queries trace<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12589' \/><div class='watu-question-choice'><input type='radio' name='answer-3239[]' id='answer-id-12589' class='answer answer-2 php-answer-label answerof-3239' value='12589' \/>&nbsp;<label for='answer-id-12589' id='answer-label-12589' class='php-answer-label answer label-2'><span class='answer'>a Server Timings trace<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(2,this)' id='btn-2' value='See Answer'  \/><input type='hidden' id='questionType2' value='radio' class=''><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><strong>Q18.<\/strong> You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to<br \/>score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3240' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12590' \/><div class='watu-question-choice'><input type='radio' name='answer-3240[]' id='answer-id-12590' class='answer answer-3 php-answer-label answerof-3240' value='12590' \/>&nbsp;<label for='answer-id-12590' id='answer-label-12590' class='php-answer-label answer label-3'><span class='answer'>PIVOT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12591' \/><div class='watu-question-choice'><input type='radio' name='answer-3240[]' id='answer-id-12591' class='answer answer-3 js-answer-label answerof-3240' value='12591' \/>&nbsp;<label for='answer-id-12591' id='answer-label-12591' class='js-answer-label answer label-3'><span class='answer'>GROUPING<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12592' \/><div class='watu-question-choice'><input type='radio' name='answer-3240[]' id='answer-id-12592' class='answer answer-3 js-answer-label answerof-3240' value='12592' \/>&nbsp;<label for='answer-id-12592' id='answer-label-12592' class='js-answer-label answer label-3'><span class='answer'>PREDICT<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12593' \/><div class='watu-question-choice'><input type='radio' name='answer-3240[]' id='answer-id-12593' class='answer answer-3 js-answer-label answerof-3240' value='12593' \/>&nbsp;<label for='answer-id-12593' id='answer-label-12593' class='js-answer-label answer label-3'><span class='answer'>CAST<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(3,this)' id='btn-3' value='See Answer'  \/><input type='hidden' id='questionType3' value='radio' class=''><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><strong>Q19.<\/strong> You have an Azure Synapse Analytics dedicated SQL pool.<br \/>You need to ensure that the SQL pool is scanned by Azure Purview.<br \/>What should you do first?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3241' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12594' \/><div class='watu-question-choice'><input type='radio' name='answer-3241[]' id='answer-id-12594' class='answer answer-4 js-answer-label answerof-3241' value='12594' \/>&nbsp;<label for='answer-id-12594' id='answer-label-12594' class='js-answer-label answer label-4'><span class='answer'>Register a data source.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12595' \/><div class='watu-question-choice'><input type='radio' name='answer-3241[]' id='answer-id-12595' class='answer answer-4 php-answer-label answerof-3241' value='12595' \/>&nbsp;<label for='answer-id-12595' id='answer-label-12595' class='php-answer-label answer label-4'><span class='answer'>Search the data catalog.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12596' \/><div class='watu-question-choice'><input type='radio' name='answer-3241[]' id='answer-id-12596' class='answer answer-4 js-answer-label answerof-3241' value='12596' \/>&nbsp;<label for='answer-id-12596' id='answer-label-12596' class='js-answer-label answer label-4'><span class='answer'>Create a data share connection.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12597' \/><div class='watu-question-choice'><input type='radio' name='answer-3241[]' id='answer-id-12597' class='answer answer-4 js-answer-label answerof-3241' value='12597' \/>&nbsp;<label for='answer-id-12597' id='answer-label-12597' class='js-answer-label answer label-4'><span class='answer'>Create a data policy.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(4,this)' id='btn-4' value='See Answer'  \/><input type='hidden' id='questionType4' value='radio' class=''><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><strong>Q20.<\/strong> You plan to modify a Power Bl dataset.<br \/>You open the Impact analysis panel for the dataset and select Notify contacts.<br \/>Which contacts will be notified when you use the Notify contacts feature?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3242' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12598' \/><div class='watu-question-choice'><input type='radio' name='answer-3242[]' id='answer-id-12598' class='answer answer-5 js-answer-label answerof-3242' value='12598' \/>&nbsp;<label for='answer-id-12598' id='answer-label-12598' class='js-answer-label answer label-5'><span class='answer'>any users that accessed a report that uses the dataset within the last 30 days<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12599' \/><div class='watu-question-choice'><input type='radio' name='answer-3242[]' id='answer-id-12599' class='answer answer-5 js-answer-label answerof-3242' value='12599' \/>&nbsp;<label for='answer-id-12599' id='answer-label-12599' class='js-answer-label answer label-5'><span class='answer'>the workspace admins of any workspace that uses the dataset<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12600' \/><div class='watu-question-choice'><input type='radio' name='answer-3242[]' id='answer-id-12600' class='answer answer-5 php-answer-label answerof-3242' value='12600' \/>&nbsp;<label for='answer-id-12600' id='answer-label-12600' class='php-answer-label answer label-5'><span class='answer'>the Power Bl admins<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12601' \/><div class='watu-question-choice'><input type='radio' name='answer-3242[]' id='answer-id-12601' class='answer answer-5 js-answer-label answerof-3242' value='12601' \/>&nbsp;<label for='answer-id-12601' id='answer-label-12601' class='js-answer-label answer label-5'><span class='answer'>all the workspace members of any workspace that uses the dataset<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(5,this)' id='btn-5' value='See Answer'  \/><input type='hidden' id='questionType5' value='radio' class=''><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><strong>Q21.<\/strong> You are building a Power Bl dataset that will use two data sources.<br \/>The dataset has a query that uses a web data source. The web data source uses anonymous authentication.<br \/>You need to ensure that the query can be used by all the other queries in the dataset.<br \/>Which privacy level should you select for the data source?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3243' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12602' \/><div class='watu-question-choice'><input type='radio' name='answer-3243[]' id='answer-id-12602' class='answer answer-6 js-answer-label answerof-3243' value='12602' \/>&nbsp;<label for='answer-id-12602' id='answer-label-12602' class='js-answer-label answer label-6'><span class='answer'>Public<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12603' \/><div class='watu-question-choice'><input type='radio' name='answer-3243[]' id='answer-id-12603' class='answer answer-6 js-answer-label answerof-3243' value='12603' \/>&nbsp;<label for='answer-id-12603' id='answer-label-12603' class='js-answer-label answer label-6'><span class='answer'>Organizational<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12604' \/><div class='watu-question-choice'><input type='radio' name='answer-3243[]' id='answer-id-12604' class='answer answer-6 php-answer-label answerof-3243' value='12604' \/>&nbsp;<label for='answer-id-12604' id='answer-label-12604' class='php-answer-label answer label-6'><span class='answer'>Private<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12605' \/><div class='watu-question-choice'><input type='radio' name='answer-3243[]' id='answer-id-12605' class='answer answer-6 js-answer-label answerof-3243' value='12605' \/>&nbsp;<label for='answer-id-12605' id='answer-label-12605' class='js-answer-label answer label-6'><span class='answer'>None<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(6,this)' id='btn-6' value='See Answer'  \/><input type='hidden' id='questionType6' value='radio' class=''><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><strong>Q22.<\/strong> You have the following Python code in an Apache Spark notebook.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-ad530433ff15a7d5242e707693192dd0.jpg\"\/><br \/>Which type of chart will the code produce?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3244' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12606' \/><div class='watu-question-choice'><input type='radio' name='answer-3244[]' id='answer-id-12606' class='answer answer-7 js-answer-label answerof-3244' value='12606' \/>&nbsp;<label for='answer-id-12606' id='answer-label-12606' class='js-answer-label answer label-7'><span class='answer'>a stacked bar chart<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12607' \/><div class='watu-question-choice'><input type='radio' name='answer-3244[]' id='answer-id-12607' class='answer answer-7 js-answer-label answerof-3244' value='12607' \/>&nbsp;<label for='answer-id-12607' id='answer-label-12607' class='js-answer-label answer label-7'><span class='answer'>a pie chart<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12608' \/><div class='watu-question-choice'><input type='radio' name='answer-3244[]' id='answer-id-12608' class='answer answer-7 php-answer-label answerof-3244' value='12608' \/>&nbsp;<label for='answer-id-12608' id='answer-label-12608' class='php-answer-label answer label-7'><span class='answer'>a bar chart<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12609' \/><div class='watu-question-choice'><input type='radio' name='answer-3244[]' id='answer-id-12609' class='answer answer-7 js-answer-label answerof-3244' value='12609' \/>&nbsp;<label for='answer-id-12609' id='answer-label-12609' class='js-answer-label answer label-7'><span class='answer'>an area chart<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(7,this)' id='btn-7' value='See Answer'  \/><input type='hidden' id='questionType7' value='radio' class=''><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><strong>Q23.<\/strong> You have a Power Bl dataset that has the query dependencies shown in the following exhibit.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-3ddbf1ab64631c18bd543530522d3350.jpg\"\/><br \/>Use the drop-down menus to select the answer choice that completes each statement based on the information<br \/>presented in the graphic.<br \/>NOTE: Each correct selection is worth one point.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-2390f185646a17182841cb7cb50b3534.jpg\"\/><\/p>\n<\/div><input type='hidden' name='question_id[]' value='3245' \/><textarea name='answer-3245[]' rows='5' cols='40' id='textarea_q_3245' class='watu-textarea watu-textarea-8'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-e9c9f22cfa28f064474e7b25c4b831e3.jpg\"\/><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(8,this)' id='btn-8' value='See Answer'  \/><input type='hidden' id='questionType8' value='textarea' class=''><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><strong>Q24.<\/strong> After you answer a question in this section, you will NOT be able to return to it. As a result, these questions<br \/>will not appear in the review screen.<br \/>You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files<br \/>by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business<br \/>names, survey names, and participant counts. The database is configured to use the default collation.<br \/>The queries use open row set and infer the schema shown in the following table.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-aa4d3c23e752288e3173b5be599728cf.jpg\"\/><br \/>You need to recommend changes to the queries to reduce I\/O reads and tempdb usage.<br \/>Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the<br \/>query to use the view.<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3246' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12610' \/><div class='watu-question-choice'><input type='radio' name='answer-3246[]' id='answer-id-12610' class='answer answer-9 php-answer-label answerof-3246' value='12610' \/>&nbsp;<label for='answer-id-12610' id='answer-label-12610' class='php-answer-label answer label-9'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12611' \/><div class='watu-question-choice'><input type='radio' name='answer-3246[]' id='answer-id-12611' class='answer answer-9 js-answer-label answerof-3246' value='12611' \/>&nbsp;<label for='answer-id-12611' id='answer-label-12611' class='js-answer-label answer label-9'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(9,this)' id='btn-9' value='See Answer'  \/><input type='hidden' id='questionType9' value='radio' class=''><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><strong>Q25.<\/strong> You have an Azure Synapse Analytics serverless SQL pool.<br \/>You need to catalog the serverless SQL pool by using Azure Purview.<br \/>Which three actions should you perform? Each correct answer presents part of the solution.<br \/>NOTE: Each correct selection is worth one point.<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3247' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12612' \/><div class='watu-question-choice'><input type='checkbox' name='answer-3247[]' id='answer-id-12612' class='answer answer-10 php-answer-label answerof-3247' value='12612' \/>&nbsp;<label for='answer-id-12612' id='answer-label-12612' class='php-answer-label answer label-10'><span class='answer'>Create a managed identity in Azure Active Directory (Azure AD).<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12613' \/><div class='watu-question-choice'><input type='checkbox' name='answer-3247[]' id='answer-id-12613' class='answer answer-10 js-answer-label answerof-3247' value='12613' \/>&nbsp;<label for='answer-id-12613' id='answer-label-12613' class='js-answer-label answer label-10'><span class='answer'>Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12614' \/><div class='watu-question-choice'><input type='checkbox' name='answer-3247[]' id='answer-id-12614' class='answer answer-10 php-answer-label answerof-3247' value='12614' \/>&nbsp;<label for='answer-id-12614' id='answer-label-12614' class='php-answer-label answer label-10'><span class='answer'>Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12615' \/><div class='watu-question-choice'><input type='checkbox' name='answer-3247[]' id='answer-id-12615' class='answer answer-10 php-answer-label answerof-3247' value='12615' \/>&nbsp;<label for='answer-id-12615' id='answer-label-12615' class='php-answer-label answer label-10'><span class='answer'>Register a data source.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12616' \/><div class='watu-question-choice'><input type='checkbox' name='answer-3247[]' id='answer-id-12616' class='answer answer-10 js-answer-label answerof-3247' value='12616' \/>&nbsp;<label for='answer-id-12616' id='answer-label-12616' class='js-answer-label answer label-10'><span class='answer'>Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(10,this)' id='btn-10' value='See Answer'  \/><input type='hidden' id='questionType10' value='checkbox' class=''><\/div><div class='watu-question' id='question-11'><div class='question-content'><p><strong>Q26.<\/strong> You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named<br \/>DB1. DB1 is a transactional database in the third normal form.<br \/>You need to recommend a solution to minimize how long it takes to execute the query. The solution must<br \/>maintain the current functionality. What should you include in the recommendation?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3248' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12617' \/><div class='watu-question-choice'><input type='radio' name='answer-3248[]' id='answer-id-12617' class='answer answer-11 js-answer-label answerof-3248' value='12617' \/>&nbsp;<label for='answer-id-12617' id='answer-label-12617' class='js-answer-label answer label-11'><span class='answer'>Create calculated columns in Dataset1.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12618' \/><div class='watu-question-choice'><input type='radio' name='answer-3248[]' id='answer-id-12618' class='answer answer-11 js-answer-label answerof-3248' value='12618' \/>&nbsp;<label for='answer-id-12618' id='answer-label-12618' class='js-answer-label answer label-11'><span class='answer'>Remove the relationships from Dataset1.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12619' \/><div class='watu-question-choice'><input type='radio' name='answer-3248[]' id='answer-id-12619' class='answer answer-11 php-answer-label answerof-3248' value='12619' \/>&nbsp;<label for='answer-id-12619' id='answer-label-12619' class='php-answer-label answer label-11'><span class='answer'>Normalize the tables in DB1.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12620' \/><div class='watu-question-choice'><input type='radio' name='answer-3248[]' id='answer-id-12620' class='answer answer-11 js-answer-label answerof-3248' value='12620' \/>&nbsp;<label for='answer-id-12620' id='answer-label-12620' class='js-answer-label answer label-11'><span class='answer'>Denormalize the tables in DB1.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(11,this)' id='btn-11' value='See Answer'  \/><input type='hidden' id='questionType11' value='radio' class=''><\/div><div class='watu-question' id='question-12'><div class='question-content'><p><strong>Q27.<\/strong> You have a Power Bl workspace named Workspacel that contains five dataflows.<br \/>You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account<br \/>What should you do first?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3249' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12621' \/><div class='watu-question-choice'><input type='radio' name='answer-3249[]' id='answer-id-12621' class='answer answer-12 js-answer-label answerof-3249' value='12621' \/>&nbsp;<label for='answer-id-12621' id='answer-label-12621' class='js-answer-label answer label-12'><span class='answer'>Delete the dataflow queries.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12622' \/><div class='watu-question-choice'><input type='radio' name='answer-3249[]' id='answer-id-12622' class='answer answer-12 js-answer-label answerof-3249' value='12622' \/>&nbsp;<label for='answer-id-12622' id='answer-label-12622' class='js-answer-label answer label-12'><span class='answer'>From the Power Bl Admin portal, enable tenant-level storage.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12623' \/><div class='watu-question-choice'><input type='radio' name='answer-3249[]' id='answer-id-12623' class='answer answer-12 js-answer-label answerof-3249' value='12623' \/>&nbsp;<label for='answer-id-12623' id='answer-label-12623' class='js-answer-label answer label-12'><span class='answer'>Disable load for all dataflow queries.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12624' \/><div class='watu-question-choice'><input type='radio' name='answer-3249[]' id='answer-id-12624' class='answer answer-12 php-answer-label answerof-3249' value='12624' \/>&nbsp;<label for='answer-id-12624' id='answer-label-12624' class='php-answer-label answer label-12'><span class='answer'>Change the Data source settings in the dataflow queries.<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(12,this)' id='btn-12' value='See Answer'  \/><input type='hidden' id='questionType12' value='radio' class=''><\/div><div class='watu-question' id='question-13'><div class='question-content'><p><strong>Q28.<\/strong> After you answer a question in this section, you will NOT be able to return to it. As a result, these questions<br \/>will not appear in the review screen.<br \/>You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files<br \/>by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business<br \/>names, survey names, and participant counts. The database is configured to use the default collation.<br \/>The queries use open row set and infer the schema shown in the following table.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-aa4d3c23e752288e3173b5be599728cf.jpg\"\/><br \/>You need to recommend changes to the queries to reduce I\/O reads and tempdb usage.<br \/>Solution: You recommend using openrowset with to explicitly define the collation for businessName and<br \/>surveyName as Latim_Generai_100_BiN2_UTF8.<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3250' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12625' \/><div class='watu-question-choice'><input type='radio' name='answer-3250[]' id='answer-id-12625' class='answer answer-13 php-answer-label answerof-3250' value='12625' \/>&nbsp;<label for='answer-id-12625' id='answer-label-12625' class='php-answer-label answer label-13'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12626' \/><div class='watu-question-choice'><input type='radio' name='answer-3250[]' id='answer-id-12626' class='answer answer-13 js-answer-label answerof-3250' value='12626' \/>&nbsp;<label for='answer-id-12626' id='answer-label-12626' class='js-answer-label answer label-13'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(13,this)' id='btn-13' value='See Answer'  \/><input type='hidden' id='questionType13' value='radio' class=''><\/div><div class='watu-question' id='question-14'><div class='question-content'><p><strong>Q29.<\/strong> You are configuring an aggregation table as shown in the following exhibit.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-bc56085b35484a3b8a964c53a4f60e42.jpg\"\/><br \/>The detail table is named FactSales and the aggregation table is named FactSales(Agg).<br \/>You need to aggregate SalesAmount for each store.<br \/>Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the<br \/>appropriate options in the answer area,<br \/>NOTE: Each correct selection is worth one point.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-196fadcf6f9ef4da2692ff82779f82f8.jpg\"\/><\/p>\n<\/div><input type='hidden' name='question_id[]' value='3251' \/><textarea name='answer-3251[]' rows='5' cols='40' id='textarea_q_3251' class='watu-textarea watu-textarea-14'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-1647e5ed74ad9692e926fed9333e86fe.jpg\"\/><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(14,this)' id='btn-14' value='See Answer'  \/><input type='hidden' id='questionType14' value='textarea' class=''><\/div><div class='watu-question' id='question-15'><div class='question-content'><p><strong>Q30.<\/strong> You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will<br \/>contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.<br \/>You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.<br \/>In which file format should you recommend storing the table data?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='3252' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12627' \/><div class='watu-question-choice'><input type='radio' name='answer-3252[]' id='answer-id-12627' class='answer answer-15 js-answer-label answerof-3252' value='12627' \/>&nbsp;<label for='answer-id-12627' id='answer-label-12627' class='js-answer-label answer label-15'><span class='answer'>JSON<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12628' \/><div class='watu-question-choice'><input type='radio' name='answer-3252[]' id='answer-id-12628' class='answer answer-15 js-answer-label answerof-3252' value='12628' \/>&nbsp;<label for='answer-id-12628' id='answer-label-12628' class='js-answer-label answer label-15'><span class='answer'>Apache Parquet<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12629' \/><div class='watu-question-choice'><input type='radio' name='answer-3252[]' id='answer-id-12629' class='answer answer-15 php-answer-label answerof-3252' value='12629' \/>&nbsp;<label for='answer-id-12629' id='answer-label-12629' class='php-answer-label answer label-15'><span class='answer'>CSV<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='12630' \/><div class='watu-question-choice'><input type='radio' name='answer-3252[]' id='answer-id-12630' class='answer answer-15 js-answer-label answerof-3252' value='12630' \/>&nbsp;<label for='answer-id-12630' id='answer-label-12630' class='js-answer-label answer label-15'><span class='answer'>Delta<\/span><\/label><\/div>\n<\/div><div class='show-question-feedback' style='display:none;'><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(15,this)' id='btn-15' value='See Answer'  \/><input type='hidden' id='questionType15' value='radio' class=''><\/div><div class='watu-question' id='question-16'><div class='question-content'><p><strong>Q31.<\/strong> You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in<br \/>the following table.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-70e462abdb10377fe349685fa2f4214a.jpg\"\/><br \/>Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each<br \/>pool type may be used once, more than once, or not at all. You may need to drag the split bar between panes or<br \/>scroll to view content.<br \/>NOTE: Each correct selection is worth one point.<br \/><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-4e108eeffea8071b82698d762b2bcb49.jpg\"\/><\/p>\n<\/div><input type='hidden' name='question_id[]' value='3253' \/><textarea name='answer-3253[]' rows='5' cols='40' id='textarea_q_3253' class='watu-textarea watu-textarea-16'><\/textarea><div class='watu-questions-wrap '><\/div><div class='show-question-feedback' style='display:none;'><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/uploads\/2022\/09\/DP-500-27783c899f1de15503ec57d02b65e408.jpg\"\/><\/div><input type='button' class='showchecked' style='margin: 10px 0;' onclick='showanswer1(16,this)' id='btn-16' value='See Answer'  \/><input type='hidden' id='questionType16' value='textarea' class=''><\/div><div style='display:none' id='question-17'><br \/><div class='question-content'><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\n<input type=\"button\" name=\"action\" onclick=\"Watu.submitResult()\" id=\"action-button\" style=\"margin:0 auto 20px auto;\" value=\"View Results\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"167\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-09-22 17:52:24\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img decoding=\"async\" src=\"https:\/\/exam.real4prep.com\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading\" title=\"Loading\" \/><\/p>\n<\/div>\t\n<script type=\"text\/javascript\">\nvar exam_id=0;\nvar question_ids='';\nvar watuURL='';\njQuery(function($){\nquestion_ids = \"3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253\";\nexam_id = 167;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 442;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.81232100 1790099544\";\nwatuURL = \"https:\/\/exam.real4prep.com\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n\nfunction showanswer1(e,q) {\n\tvar check = new Array();\n\tjQuery('.answer-' + e).each(function (i) {\n\t\tcheck.push(this.checked)\n\t})\n\tlet textval = jQuery('.watu-textarea-' + e).val()\n\tif (jQuery.inArray(true, check) >= 0 || textval !== '' && textval !== undefined) {\n\t\tjQuery(q).stop().fadeOut(300)\n\t\tjQuery('.php-answer-label.label-' + e).addClass(\n\t\t\t'correct-answer'\n\t\t)\n\t\tjQuery('.answer-' + e).each(function (i) {\n\t\t\tif (this.checked && this.className.match(\/js\\-answer\/)) {\n\t\t\t\tvar number = this.id.toString().replace(\/\\D\/g, '')\n\t\t\t\tif (number) {\n\t\t\t\t\tjQuery('#answer-label-' + number).addClass('user-answer')\n\t\t\t\t}\n\t\t\t}\n\t\t})\n\t\tjQuery(q).siblings('.show-question-feedback').stop().fadeIn(300)\n\t\ttextval = ''\n\t} else if (textval == '' || textval == undefined){\n\t\t\/\/jQuery(\".hint\").stop().fadeIn(300)\n\t\talert('Please first answer the question');\n\t}\n}\nvar btnisshow = jQuery(\".php-answer-label\").length\nif (btnisshow > 0) {\n\tjQuery('.showchecked').show()\n} else {\n\tjQuery('.showchecked').hide()\n}\n<\/script>\n<p><strong>Download DP-500 Exam Dumps Questions to get 100% Success: <a href=\"https:\/\/www.real4prep.com\/DP-500-exam.html\" target=\"_blank\" rel=\"noopener\">https:\/\/www.real4prep.com\/DP-500-exam.html<\/a><\/strong><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Practice Test for DP-500 Certification Real 2022 Mock Exam Prepare For Realistic DP-500 Dumps PDF &#8211; 100% Passing Guarantee Schedule exam Languages: English Retirement date: none This&#8230; <\/p>","protected":false},"author":1,"featured_media":443,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[1207,191],"tags":[1206,1203,1200,1201,1202,1205,1204],"class_list":["post-442","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dp-500","category-microsoft","tag-dp-500-answers-real-questions","tag-dp-500-authorized-pdf","tag-dp-500-examcollection-dumps-torrent","tag-dp-500-latest-exam-simulator","tag-dp-500-preparation-store","tag-dp-500-real-question-on-the-exam","tag-dp-500-valid-test-simulator-online"],"_links":{"self":[{"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/posts\/442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/comments?post=442"}],"version-history":[{"count":0,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/posts\/442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/media\/443"}],"wp:attachment":[{"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/media?parent=442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/categories?post=442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.real4prep.com\/ko\/wp-json\/wp\/v2\/tags?post=442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}