{"id":21939,"date":"2021-04-05T03:16:03","date_gmt":"2021-04-05T03:16:03","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=21939"},"modified":"2021-04-05T03:17:09","modified_gmt":"2021-04-05T03:17:09","slug":"data-engineering-on-microsoft-azure-dp-203-exam-dumps","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/data-engineering-on-microsoft-azure-dp-203-exam-dumps.html","title":{"rendered":"Data Engineering on Microsoft Azure DP-203 Exam Dumps"},"content":{"rendered":"\n<p>DP-203 exam is the new Microsoft Certified: Azure Data Engineer Associate certification test replacement of DP-200 and DP-201 exams. Candidates for Exam DP-203: Data Engineering on Microsoft Azure must have solid knowledge of data processing languages, such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns. DumpsBase new released new and valid DP-203 dumps online. You are highly recommended to read DP-203 dumps questions thoroughly.<\/p>\n<h1>You are recommended to read <span style=\"color: #800000;\">DP-203 free dumps<\/span> firstly<\/h1>\n<script>\n\t  window.fbAsyncInit = function() {\n\t    FB.init({\n\t      appId            : '622169541470367',\n\t      autoLogAppEvents : true,\n\t      xfbml            : true,\n\t      version          : 'v3.1'\n\t    });\n\t  };\n\t\n\t  (function(d, s, id){\n\t     var js, fjs = d.getElementsByTagName(s)[0];\n\t     if (d.getElementById(id)) {return;}\n\t     js = d.createElement(s); js.id = id;\n\t     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n\t     fjs.parentNode.insertBefore(js, fjs);\n\t   }(document, 'script', 'facebook-jssdk'));\n\t<\/script><script type=\"text\/javascript\" >\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \nif(!window.jQuery) alert(\"The important jQuery library is not properly loaded in your site. Your WordPress theme is probably missing the essential wp_head() call. You can switch to another theme and you will see that the plugin works fine and this notice disappears. If you are still not sure what to do you can contact us for help.\");\n});\n<\/script>  \n  \n<div  id=\"watupro_quiz\" class=\"quiz-area single-page-quiz\">\n<p id=\"submittingExam5273\" style=\"display:none;text-align:center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\"><\/p>\n\n<div class=\"watupro-exam-description\" id=\"description-quiz-5273\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-5273\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-173306'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>Topic 1, Contoso Case StudyTransactional Date <br \/>\r<br><br \/>\r<br>Contoso has three years of customer, transactional, operation, sourcing, and supplier data comprised of 10 billion records stored across multiple on-premises Microsoft SQL Server servers. The SQL server instances contain data from various operational systems. The data is loaded into the instances by using SQL server integration Services (SSIS) packages. <br \/>\r<br><br \/>\r<br>You estimate that combining all product sales transactions into a company-wide sales transactions dataset will result in a single table that contains 5 billion rows, with one row per transaction. <br \/>\r<br>Most queries targeting the sales transactions data will be used to identify which products were sold in retail stores and which products were sold online during different time period. Sales transaction data that is older than three years will be removed monthly. <br \/>\r<br><br \/>\r<br>You plan to create a retail store table that will contain the address of each retail store. The table will be approximately 2 MB. Queries for retail store sales will include the retail store addresses. <br \/>\r<br>You plan to create a promotional table that will contain a promotion ID. The promotion ID will be associated to a specific product. The product will be identified by a product ID. The table will be approximately 5 GB. <br \/>\r<br><br \/>\r<br>Streaming Twitter Data <br \/>\r<br>The ecommerce department at Contoso develops and Azure logic app that captures trending Twitter feeds referencing the company\u2019s products and pushes the products to Azure Event Hubs. <br \/>\r<br><br \/>\r<br>Planned Changes <br \/>\r<br>Contoso plans to implement the following changes: <br \/>\r<br>* Load the sales transaction dataset to Azure Synapse Analytics. <br \/>\r<br>* Integrate on-premises data stores with Azure Synapse Analytics by using SSIS packages. <br \/>\r<br>* Use Azure Synapse Analytics to analyze Twitter feeds to assess customer sentiments about products. <br \/>\r<br><br \/>\r<br>Sales Transaction Dataset Requirements <br \/>\r<br>Contoso identifies the following requirements for the sales transaction dataset: <br \/>\r<br>&#8226; Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Boundary values must belong: to the partition on the right. <br \/>\r<br>&#8226; Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible. <br \/>\r<br>&#8226; Implement a surrogate key to account for changes to the retail store addresses. <br \/>\r<br>&#8226; Ensure that data storage costs and performance are predictable. <br \/>\r<br>&#8226; Minimize how long it takes to remove old records. Customer Sentiment Analytics Requirement <br \/>\r<br><br \/>\r<br>Contoso identifies the following requirements for customer sentiment analytics: <br \/>\r<br>&#8226; Allow Contoso users to use PolyBase in an A\/ure Synapse Analytics dedicated SQL pool to query the content of the data records that host the Twitter feeds. Data must be protected by using row-level security (RLS). The users must be authenticated by using their own A\/ureAD credentials. <br \/>\r<br>&#8226; Maximize the throughput of ingesting Twitter feeds from Event Hubs to Azure Storage <br \/>\r<br>without purchasing additional throughput or capacity units. <br \/>\r<br>&#8226; Store Twitter feeds in Azure Storage by using Event Hubs Capture. The feeds will be converted into Parquet files. <br \/>\r<br>&#8226; Ensure that the data store supports Azure AD-based access control down to the object level. <br \/>\r<br>&#8226; Minimize administrative effort to maintain the Twitter feed data records. <br \/>\r<br>&#8226; Purge Twitter feed data records;itftaitJ are older than two years. <br \/>\r<br><br \/>\r<br>Data Integration Requirements <br \/>\r<br>Contoso identifies the following requirements for data integration: <br \/>\r<br>Use an Azure service that leverages the existing SSIS packages to ingest on-premises data into datasets stored in a dedicated SQL pool of Azure Synaps Analytics and transform the data. <br \/>\r<br>Identify a process to ensure that changes to the ingestion and transformation activities can be version controlled and developed independently by multiple data engineers. <br \/>\r<br><br \/>\r<br>HOTSPOT <br \/>\r<br>You need to design the partitions for the product sales transactions. The solution must mee the sales transaction dataset requirements. <br \/>\r<br>What should you include in the solution? To answer, select the appropriate options in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=649 height=119 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image002-6.jpg\" v:shapes=\"_x0000_i1025\"><br><\/div><input type='hidden' name='question_id[]' id='qID_1' value='173306' \/><input type='hidden' id='answerType173306' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173306[]' id='textarea_q_173306' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-173307'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>HOTSPOT <br \/>\r<br>You need to design a data storage structure for the product sales transactions. The solution must meet the sales transaction dataset requirements. <br \/>\r<br>What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=152 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image006-6.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_2' value='173307' \/><input type='hidden' id='answerType173307' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173307[]' id='textarea_q_173307' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-173308'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>DRAG DROP <br \/>\r<br>You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. <br \/>\r<br>The solution must meet the customer sentiment analytics requirements. <br \/>\r<br>Which three Transaction-SQL DDL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. <br \/>\r<br><br><img decoding=\"async\" width=646 height=174 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image010-6.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='173308' \/><input type='hidden' id='answerType173308' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173308[]' id='textarea_q_173308' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-173309'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>You need to integrate the on-premises data sources and Azure Synapse Analytics. The solution must meet the data integration requirements. <br \/>\r<br>Which type of integration runtime should you use?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='173309' \/><input type='hidden' id='answerType173309' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173309[]' id='answer-id-700018' class='answer   answerof-173309 ' value='700018'   \/><label for='answer-id-700018' id='answer-label-700018' class=' answer'><span>Azure-SSIS integration runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173309[]' id='answer-id-700019' class='answer   answerof-173309 ' value='700019'   \/><label for='answer-id-700019' id='answer-label-700019' class=' answer'><span>self-hosted integration runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173309[]' id='answer-id-700020' class='answer   answerof-173309 ' value='700020'   \/><label for='answer-id-700020' id='answer-label-700020' class=' answer'><span>Azure integration runtime<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-173310'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>HOTSPOT <br \/>\r<br>You need to implement an Azure Synapse Analytics database object for storing the sales transactions data. The solution must meet the sales transaction dataset requirements. <br \/>\r<br>What solution must meet the sales transaction dataset requirements. <br \/>\r<br>What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=163 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image014-5.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_5' value='173310' \/><input type='hidden' id='answerType173310' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173310[]' id='textarea_q_173310' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-173311'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>Topic 2, Mix Questions <br \/>\r<br><br \/>\r<br>You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse Analytics dedicated SQL pool. <br \/>\r<br>You plan to keep a record of changes to the available fields. <br \/>\r<br>The supplier data contains the following columns. <br \/>\r<br><br><img decoding=\"async\" width=650 height=353 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image018-4.jpg\" v:shapes=\"_x0000_i1033\"><br><br \/>\r<br>Which three additional columns should you add to the data to create a Type 2 SCD? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_6' value='173311' \/><input type='hidden' id='answerType173311' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700022' class='answer   answerof-173311 ' value='700022'   \/><label for='answer-id-700022' id='answer-label-700022' class=' answer'><span>surrogate primary key<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700023' class='answer   answerof-173311 ' value='700023'   \/><label for='answer-id-700023' id='answer-label-700023' class=' answer'><span>foreign key<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700024' class='answer   answerof-173311 ' value='700024'   \/><label for='answer-id-700024' id='answer-label-700024' class=' answer'><span>effective start date<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700025' class='answer   answerof-173311 ' value='700025'   \/><label for='answer-id-700025' id='answer-label-700025' class=' answer'><span>effective end date<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700026' class='answer   answerof-173311 ' value='700026'   \/><label for='answer-id-700026' id='answer-label-700026' class=' answer'><span>last modified date<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173311[]' id='answer-id-700027' class='answer   answerof-173311 ' value='700027'   \/><label for='answer-id-700027' id='answer-label-700027' class=' answer'><span>business key<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-173312'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>HOTSPOT <br \/>\r<br>You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=454 height=67 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image020-4.jpg\" v:shapes=\"_x0000_i1034\"><br><br \/>\r<br>User1 executes a query on the database, and the query returns the results shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" width=507 height=267 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image022-4.jpg\" v:shapes=\"_x0000_i1035\"><br><br \/>\r<br>User1 is the only user who has access to the unmasked data. <br \/>\r<br>Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. <br \/>\r<br><br><img decoding=\"async\" width=649 height=145 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image024-4.jpg\" v:shapes=\"_x0000_i1036\"><br><\/div><input type='hidden' name='question_id[]' id='qID_7' value='173312' \/><input type='hidden' id='answerType173312' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173312[]' id='textarea_q_173312' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-173313'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>You plan to implement an Azure Data Lake Gen2 storage account. <br \/>\r<br>You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. <br \/>\r<br>The solution must minimize costs. <br \/>\r<br>Which type of replication should you use for the storage account?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='173313' \/><input type='hidden' id='answerType173313' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173313[]' id='answer-id-700029' class='answer   answerof-173313 ' value='700029'   \/><label for='answer-id-700029' id='answer-label-700029' class=' answer'><span>geo-redundant storage (GRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173313[]' id='answer-id-700030' class='answer   answerof-173313 ' value='700030'   \/><label for='answer-id-700030' id='answer-label-700030' class=' answer'><span>zone-redundant storage (ZRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173313[]' id='answer-id-700031' class='answer   answerof-173313 ' value='700031'   \/><label for='answer-id-700031' id='answer-label-700031' class=' answer'><span>locally-redundant storage (LRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173313[]' id='answer-id-700032' class='answer   answerof-173313 ' value='700032'   \/><label for='answer-id-700032' id='answer-label-700032' class=' answer'><span>geo-zone-redundant storage (GZRS)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-173314'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>You are planning a streaming data solution that will use Azure Databricks. The solution will stream sales transaction data from an online store. <br \/>\r<br>The solution has the following specifications: <br \/>\r<br>* The output data will contain items purchased, quantity, line total sales amount, and line total tax amount. <br \/>\r<br>* Line total sales amount and line total tax amount will be aggregated in Databricks. <br \/>\r<br>* Sales transactions will never be updated. Instead, new rows will be added to adjust a sale. <br \/>\r<br>You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='173314' \/><input type='hidden' id='answerType173314' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173314[]' id='answer-id-700033' class='answer   answerof-173314 ' value='700033'   \/><label for='answer-id-700033' id='answer-label-700033' class=' answer'><span>Append<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173314[]' id='answer-id-700034' class='answer   answerof-173314 ' value='700034'   \/><label for='answer-id-700034' id='answer-label-700034' class=' answer'><span>Update<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173314[]' id='answer-id-700035' class='answer   answerof-173314 ' value='700035'   \/><label for='answer-id-700035' id='answer-label-700035' class=' answer'><span>Complete<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-173315'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>HOTSPOT <br \/>\r<br>You are designing an Azure Stream Analytics solution that receives instant messaging data from an Azure event hub. <br \/>\r<br>You need to ensure that the output from the Stream Analytics job counts the number of messages per time zone every 15 seconds. <br \/>\r<br>How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=494 height=209 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image028-4.jpg\" v:shapes=\"_x0000_i1038\"><br><\/div><input type='hidden' name='question_id[]' id='qID_10' value='173315' \/><input type='hidden' id='answerType173315' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173315[]' id='textarea_q_173315' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-173316'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. <br \/>\r<br>The company must be able to monitor the devices in real-time. <br \/>\r<br>You need to design the solution. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='173316' \/><input type='hidden' id='answerType173316' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173316[]' id='answer-id-700037' class='answer   answerof-173316 ' value='700037'   \/><label for='answer-id-700037' id='answer-label-700037' class=' answer'><span>Azure Stream Analytics cloud job using Azure PowerShell<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173316[]' id='answer-id-700038' class='answer   answerof-173316 ' value='700038'   \/><label for='answer-id-700038' id='answer-label-700038' class=' answer'><span>Azure Analysis Services using Azure Portal<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173316[]' id='answer-id-700039' class='answer   answerof-173316 ' value='700039'   \/><label for='answer-id-700039' id='answer-label-700039' class=' answer'><span>Azure Data Factory instance using Azure Portal<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173316[]' id='answer-id-700040' class='answer   answerof-173316 ' value='700040'   \/><label for='answer-id-700040' id='answer-label-700040' class=' answer'><span>Azure Analysis Services using Azure PowerShell<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-173317'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>You have an Azure Synapse Analytics serverless SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named storage1. The AllowedBlobpublicAccess porperty is disabled for storage1. <br \/>\r<br>You need to create an external data source that can be used by Azure Active Directory (Azure AD) users to access storage1 from Pool1. <br \/>\r<br>What should you create first?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='173317' \/><input type='hidden' id='answerType173317' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173317[]' id='answer-id-700041' class='answer   answerof-173317 ' value='700041'   \/><label for='answer-id-700041' id='answer-label-700041' class=' answer'><span>an external resource pool<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173317[]' id='answer-id-700042' class='answer   answerof-173317 ' value='700042'   \/><label for='answer-id-700042' id='answer-label-700042' class=' answer'><span>a remote service binding<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173317[]' id='answer-id-700043' class='answer   answerof-173317 ' value='700043'   \/><label for='answer-id-700043' id='answer-label-700043' class=' answer'><span>database scoped credentials<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-173317[]' id='answer-id-700044' class='answer   answerof-173317 ' value='700044'   \/><label for='answer-id-700044' id='answer-label-700044' class=' answer'><span>an external library<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-173318'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>DRAG DROP <br \/>\r<br>You have an Apache Spark DataFrame named temperatures. <br \/>\r<br>A sample of the data is shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=307 height=177 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image032-2.jpg\" v:shapes=\"_x0000_i1040\"><br><br \/>\r<br>You need to produce the following table by using a Spark SQL query. <br \/>\r<br><br><img decoding=\"async\" width=650 height=74 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image034-2.jpg\" v:shapes=\"_x0000_i1041\"><br><br \/>\r<br>How should you complete the query? To answer, drag the appropriate values to the correct 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. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=642 height=363 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/04\/image036-2.jpg\" v:shapes=\"_x0000_i1042\"><br><\/div><input type='hidden' name='question_id[]' id='qID_13' value='173318' \/><input type='hidden' id='answerType173318' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-173318[]' id='textarea_q_173318' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-173319'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>You have a SQL pool in Azure Synapse. <br \/>\r<br>A user reports that queries against the pool take longer than expected to complete. <br \/>\r<br>You need to add monitoring to the underlying storage to help diagnose the issue. <br \/>\r<br>Which two metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_14' value='173319' \/><input type='hidden' id='answerType173319' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173319[]' id='answer-id-700046' class='answer   answerof-173319 ' value='700046'   \/><label for='answer-id-700046' id='answer-label-700046' class=' answer'><span>Cache used percentage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173319[]' id='answer-id-700047' class='answer   answerof-173319 ' value='700047'   \/><label for='answer-id-700047' id='answer-label-700047' class=' answer'><span>DWU Limit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173319[]' id='answer-id-700048' class='answer   answerof-173319 ' value='700048'   \/><label for='answer-id-700048' id='answer-label-700048' class=' answer'><span>Snapshot Storage Size<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173319[]' id='answer-id-700049' class='answer   answerof-173319 ' value='700049'   \/><label for='answer-id-700049' id='answer-label-700049' class=' answer'><span>Active queries<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173319[]' id='answer-id-700050' class='answer   answerof-173319 ' value='700050'   \/><label for='answer-id-700050' id='answer-label-700050' class=' answer'><span>Cache hit percentage<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-173320'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination. <br \/>\r<br>You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='173320' \/><input type='hidden' id='answerType173320' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173320[]' id='answer-id-700051' class='answer   answerof-173320 ' value='700051'   \/><label for='answer-id-700051' id='answer-label-700051' class=' answer'><span>Clone the cluster after it is terminated.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173320[]' id='answer-id-700052' class='answer   answerof-173320 ' value='700052'   \/><label for='answer-id-700052' id='answer-label-700052' class=' answer'><span>Terminate the cluster manually when processing completes.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173320[]' id='answer-id-700053' class='answer   answerof-173320 ' value='700053'   \/><label for='answer-id-700053' id='answer-label-700053' class=' answer'><span>Create an Azure runbook that starts the cluster every 90 days.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-173320[]' id='answer-id-700054' class='answer   answerof-173320 ' value='700054'   \/><label for='answer-id-700054' id='answer-label-700054' class=' answer'><span>Pin the cluster.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-16'>\n\t<div class='question-content'>\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading...\" title=\"Loading...\" \/>&nbsp;Loading...\t<\/div>\n<\/div>\n\n<br \/>\n\t\n\t\t\t<div class=\"watupro_buttons flex \" id=\"watuPROButtons5273\" >\n\t\t  <div id=\"prev-question\" style=\"display:none;\"><input type=\"button\" value=\"&lt; Previous\" onclick=\"WatuPRO.nextQuestion(event, 'previous');\"\/><\/div>\t\t  \t\t  \t\t   \n\t\t   \t  \t\t<div><input type=\"button\" name=\"action\" class=\"watupro-submit-button\" onclick=\"WatuPRO.submitResult(event)\" id=\"action-button\" value=\"View Results\"  \/>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<input type=\"hidden\" name=\"quiz_id\" value=\"5273\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 06:28:53\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777616933\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"173306:700015 | 173307:700016 | 173308:700017 | 173309:700018,700019,700020 | 173310:700021 | 173311:700022,700023,700024,700025,700026,700027 | 173312:700028 | 173313:700029,700030,700031,700032 | 173314:700033,700034,700035 | 173315:700036 | 173316:700037,700038,700039,700040 | 173317:700041,700042,700043,700044 | 173318:700045 | 173319:700046,700047,700048,700049,700050 | 173320:700051,700052,700053,700054\" \/>\n\t<input type=\"hidden\" name=\"no_ajax\" value=\"0\">\t\t\t<\/form>\n\t<p>&nbsp;<\/p>\n<\/div>\n\n<script type=\"text\/javascript\">\n\/\/jQuery(document).ready(function(){\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \t\nvar question_ids = \"173306,173307,173308,173309,173310,173311,173312,173313,173314,173315,173316,173317,173318,173319,173320\";\nWatuPROSettings[5273] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 5273;\t    \nWatuPRO.post_id = 21939;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.32616500 1777616933\";\nvar url = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/show_exam.php\";\nWatuPRO.examMode = 1;\nWatuPRO.siteURL=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatuPRO.emailIsNotRequired = 0;\nWatuPROIntel.init(5273);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,12161],"tags":[12155,12156,12157,12159,12160,12158],"class_list":["post-21939","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-certified-azure-data-engineer-associate","tag-dp-203","tag-dp-203-dumps","tag-dp-203-dumps-questions","tag-dp-203-exam-dumps","tag-dp-203-exam-questions","tag-dp-203-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/21939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/comments?post=21939"}],"version-history":[{"count":2,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/21939\/revisions"}],"predecessor-version":[{"id":21942,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/21939\/revisions\/21942"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=21939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=21939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=21939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}