{"id":12184,"date":"2020-09-10T03:34:53","date_gmt":"2020-09-10T03:34:53","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=12184"},"modified":"2020-09-10T03:35:29","modified_gmt":"2020-09-10T03:35:29","slug":"updated-dp-200-dumps-questions-for-implementing-an-azure-data-solution-certification-exam","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/updated-dp-200-dumps-questions-for-implementing-an-azure-data-solution-certification-exam.html","title":{"rendered":"Updated DP-200 Dumps Questions For Implementing an Azure Data Solution Certification Exam"},"content":{"rendered":"\n<p>We have great way to pass Implementing an Azure Data Solution exam successfully. You will be strongly recommended to choose the most updated DP-200 dumps questions to test the skills and knowledge points. The professional team have collected 201 practice exam questions and answers, which are helpful for Implementing an Azure Data Solution exam. Come to get DumpsBase DP-200 pdf file and free software to test Microsoft DP-200 exam.<\/p>\n<h2>Great to read <span style=\"color: #800000;\">DP-200 free dumps<\/span> online to check DP-200 dumps questions.<\/h2>\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=\"submittingExam4630\" 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-4630\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-4630\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-146832'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly. <br \/>\r<br>You must implement a solution that meets the following requirements: <br \/>\r<br>- Provide data warehousing <br \/>\r<br>- Reduce ongoing management activities <br \/>\r<br>- Deliver SQL query responses in less than one second <br \/>\r<br>You need to create an HDInsight cluster to meet the requirements. <br \/>\r<br>Which type of cluster should you create?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='146832' \/><input type='hidden' id='answerType146832' 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-146832[]' id='answer-id-598539' class='answer   answerof-146832 ' value='598539'   \/><label for='answer-id-598539' id='answer-label-598539' class=' answer'><span>Interactive Query<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146832[]' id='answer-id-598540' class='answer   answerof-146832 ' value='598540'   \/><label for='answer-id-598540' id='answer-label-598540' class=' answer'><span>Apache Hadoop<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146832[]' id='answer-id-598541' class='answer   answerof-146832 ' value='598541'   \/><label for='answer-id-598541' id='answer-label-598541' class=' answer'><span>Apache HBase<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146832[]' id='answer-id-598542' class='answer   answerof-146832 ' value='598542'   \/><label for='answer-id-598542' id='answer-label-598542' class=' answer'><span>Apache Spark<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-146833'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>DRAG DROP <br \/>\r<br>You develop data engineering solutions for a company. You must migrate data from Microsoft Azure Blob storage to an Azure SQL Data Warehouse for further transformation. You need to implement the solution. <br \/>\r<br>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. <br \/>\r<br><br><img decoding=\"async\" width=650 height=431 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image004-12.jpg\" v:shapes=\"_x0000_i1026\"><br><\/div><input type='hidden' name='question_id[]' id='qID_2' value='146833' \/><input type='hidden' id='answerType146833' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146833[]' id='textarea_q_146833' 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-146834'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. <br \/>\r<br>The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency. <br \/>\r<br>You need to secure the transfer of data between on-premises databases and Microsoft Azure. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_3' value='146834' \/><input type='hidden' id='answerType146834' 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-146834[]' id='answer-id-598544' class='answer   answerof-146834 ' value='598544'   \/><label for='answer-id-598544' id='answer-label-598544' class=' answer'><span>Install a standalone on-premises Azure data gateway at each location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146834[]' id='answer-id-598545' class='answer   answerof-146834 ' value='598545'   \/><label for='answer-id-598545' id='answer-label-598545' class=' answer'><span>Install an on-premises data gateway in personal mode at each location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146834[]' id='answer-id-598546' class='answer   answerof-146834 ' value='598546'   \/><label for='answer-id-598546' id='answer-label-598546' class=' answer'><span>Install an Azure on-premises data gateway at the primary location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146834[]' id='answer-id-598547' class='answer   answerof-146834 ' value='598547'   \/><label for='answer-id-598547' id='answer-label-598547' class=' answer'><span>Install an Azure on-premises data gateway as a cluster at each location<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-146835'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>You are a data architect. The data engineering team needs to configure a synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database. <br \/>\r<br>Ad-hoc and reporting queries are being overutilized the on-premises production instance. <br \/>\r<br>The synchronization process must: <br \/>\r<br>- Perform an initial data synchronization to Azure SQL Database with minimal downtime <br \/>\r<br>- Perform bi-directional data synchronization after initial synchronization <br \/>\r<br>You need to implement this synchronization solution. <br \/>\r<br>Which synchronization method should you use?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='146835' \/><input type='hidden' id='answerType146835' 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-146835[]' id='answer-id-598548' class='answer   answerof-146835 ' value='598548'   \/><label for='answer-id-598548' id='answer-label-598548' class=' answer'><span>transactional replication<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146835[]' id='answer-id-598549' class='answer   answerof-146835 ' value='598549'   \/><label for='answer-id-598549' id='answer-label-598549' class=' answer'><span>Data Migration Assistant (DMA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146835[]' id='answer-id-598550' class='answer   answerof-146835 ' value='598550'   \/><label for='answer-id-598550' id='answer-label-598550' class=' answer'><span>backup and restore<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146835[]' id='answer-id-598551' class='answer   answerof-146835 ' value='598551'   \/><label for='answer-id-598551' id='answer-label-598551' class=' answer'><span>SQL Server Agent job<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146835[]' id='answer-id-598552' class='answer   answerof-146835 ' value='598552'   \/><label for='answer-id-598552' id='answer-label-598552' class=' answer'><span>Azure SQL Data Sync<\/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-146836'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items. <br \/>\r<br>You need to provision Azure Cosmos DB. <br \/>\r<br>Which container name and item name should you use? Each correct answer presents part of the solutions. NOTE: Each correct answer selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_5' value='146836' \/><input type='hidden' id='answerType146836' 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-146836[]' id='answer-id-598553' class='answer   answerof-146836 ' value='598553'   \/><label for='answer-id-598553' id='answer-label-598553' class=' answer'><span>collection<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146836[]' id='answer-id-598554' class='answer   answerof-146836 ' value='598554'   \/><label for='answer-id-598554' id='answer-label-598554' class=' answer'><span>rows<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146836[]' id='answer-id-598555' class='answer   answerof-146836 ' value='598555'   \/><label for='answer-id-598555' id='answer-label-598555' class=' answer'><span>graph<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146836[]' id='answer-id-598556' class='answer   answerof-146836 ' value='598556'   \/><label for='answer-id-598556' id='answer-label-598556' class=' answer'><span>entities<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146836[]' id='answer-id-598557' class='answer   answerof-146836 ' value='598557'   \/><label for='answer-id-598557' id='answer-label-598557' class=' answer'><span>table<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-146837'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. <br \/>\r<br>You need to implement the Azure SQL Database elastic pool to minimize cost. <br \/>\r<br>Which option or options should you configure?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='146837' \/><input type='hidden' id='answerType146837' 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-146837[]' id='answer-id-598558' class='answer   answerof-146837 ' value='598558'   \/><label for='answer-id-598558' id='answer-label-598558' class=' answer'><span>Number of transactions only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146837[]' id='answer-id-598559' class='answer   answerof-146837 ' value='598559'   \/><label for='answer-id-598559' id='answer-label-598559' class=' answer'><span>eDTUs per database only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146837[]' id='answer-id-598560' class='answer   answerof-146837 ' value='598560'   \/><label for='answer-id-598560' id='answer-label-598560' class=' answer'><span>Number of databases only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146837[]' id='answer-id-598561' class='answer   answerof-146837 ' value='598561'   \/><label for='answer-id-598561' id='answer-label-598561' class=' answer'><span>CPU usage only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146837[]' id='answer-id-598562' class='answer   answerof-146837 ' value='598562'   \/><label for='answer-id-598562' id='answer-label-598562' class=' answer'><span>eDTUs and max data size<\/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-146838'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>HOTSPOT <br \/>\r<br>You are a data engineer. You are designing a Hadoop Distributed File System (HDFS) architecture. You plan to use Microsoft Azure Data Lake as a data storage repository. <br \/>\r<br>You must provision the repository with a resilient data schema. You need to ensure the resiliency of the Azure Data Lake Storage. <br \/>\r<br>What should you use? 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=566 height=270 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image014-8.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_7' value='146838' \/><input type='hidden' id='answerType146838' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146838[]' id='textarea_q_146838' 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-146839'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>DRAG DROP <br \/>\r<br>You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections. Each region maintains its own private virtual network. <br \/>\r<br>Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data. Microsoft Azure SQL Databases must be provisioned. <br \/>\r<br>- Database provisioning must maximize performance and minimize cost <br \/>\r<br>- The daily sales for each region must be stored in an Azure SQL Database instance <br \/>\r<br>- Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance <br \/>\r<br>You need to provision Azure SQL database instances. <br \/>\r<br>How should you provision the database instances? To answer, drag the appropriate Azure SQL products <br \/>\r<br>to the correct databases. Each Azure SQL product 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. <br \/>\r<br><br><img decoding=\"async\" width=650 height=201 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image018-8.jpg\" v:shapes=\"_x0000_i1033\"><br><\/div><input type='hidden' name='question_id[]' id='qID_8' value='146839' \/><input type='hidden' id='answerType146839' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146839[]' id='textarea_q_146839' 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-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-146840'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>A company manages several on-premises Microsoft SQL Server databases. <br \/>\r<br>You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. <br \/>\r<br>Which data technology should you use?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='146840' \/><input type='hidden' id='answerType146840' 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-146840[]' id='answer-id-598565' class='answer   answerof-146840 ' value='598565'   \/><label for='answer-id-598565' id='answer-label-598565' class=' answer'><span>Azure SQL Database single database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146840[]' id='answer-id-598566' class='answer   answerof-146840 ' value='598566'   \/><label for='answer-id-598566' id='answer-label-598566' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146840[]' id='answer-id-598567' class='answer   answerof-146840 ' value='598567'   \/><label for='answer-id-598567' id='answer-label-598567' class=' answer'><span>Azure Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146840[]' id='answer-id-598568' class='answer   answerof-146840 ' value='598568'   \/><label for='answer-id-598568' id='answer-label-598568' class=' answer'><span>Azure SQL Database Managed Instance<\/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-146841'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes. <br \/>\r<br>You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. <br \/>\r<br>What should you implement?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='146841' \/><input type='hidden' id='answerType146841' 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-146841[]' id='answer-id-598569' class='answer   answerof-146841 ' value='598569'   \/><label for='answer-id-598569' id='answer-label-598569' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146841[]' id='answer-id-598570' class='answer   answerof-146841 ' value='598570'   \/><label for='answer-id-598570' id='answer-label-598570' class=' answer'><span>Azure Traffic Manager<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146841[]' id='answer-id-598571' class='answer   answerof-146841 ' value='598571'   \/><label for='answer-id-598571' id='answer-label-598571' class=' answer'><span>Azure Resource Manager templates<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146841[]' id='answer-id-598572' class='answer   answerof-146841 ' value='598572'   \/><label for='answer-id-598572' id='answer-label-598572' class=' answer'><span>Ambari web user interface<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-146842'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. <br \/>\r<br>Developers need to access data in the database using an API. <br \/>\r<br>You need to determine which API to use for the database model and type. <br \/>\r<br>Which two APIs should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_11' value='146842' \/><input type='hidden' id='answerType146842' 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-146842[]' id='answer-id-598573' class='answer   answerof-146842 ' value='598573'   \/><label for='answer-id-598573' id='answer-label-598573' class=' answer'><span>Table API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146842[]' id='answer-id-598574' class='answer   answerof-146842 ' value='598574'   \/><label for='answer-id-598574' id='answer-label-598574' class=' answer'><span>MongoDB API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146842[]' id='answer-id-598575' class='answer   answerof-146842 ' value='598575'   \/><label for='answer-id-598575' id='answer-label-598575' class=' answer'><span>Gremlin API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146842[]' id='answer-id-598576' class='answer   answerof-146842 ' value='598576'   \/><label for='answer-id-598576' id='answer-label-598576' class=' answer'><span>SQL API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146842[]' id='answer-id-598577' class='answer   answerof-146842 ' value='598577'   \/><label for='answer-id-598577' id='answer-label-598577' class=' answer'><span>Cassandra API<\/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-146843'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. <br \/>\r<br>You must perform an assessment of databases to determine whether data will move without compatibility issues. You need to perform the assessment. <br \/>\r<br>Which tool should you use?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='146843' \/><input type='hidden' id='answerType146843' 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-146843[]' id='answer-id-598578' class='answer   answerof-146843 ' value='598578'   \/><label for='answer-id-598578' id='answer-label-598578' class=' answer'><span>SQL Server Migration Assistant (SSMA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146843[]' id='answer-id-598579' class='answer   answerof-146843 ' value='598579'   \/><label for='answer-id-598579' id='answer-label-598579' class=' answer'><span>Microsoft Assessment and Planning Toolkit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146843[]' id='answer-id-598580' class='answer   answerof-146843 ' value='598580'   \/><label for='answer-id-598580' id='answer-label-598580' class=' answer'><span>SQL Vulnerability Assessment (VA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146843[]' id='answer-id-598581' class='answer   answerof-146843 ' value='598581'   \/><label for='answer-id-598581' id='answer-label-598581' class=' answer'><span>Azure SQL Data Sync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146843[]' id='answer-id-598582' class='answer   answerof-146843 ' value='598582'   \/><label for='answer-id-598582' id='answer-label-598582' class=' answer'><span>Data Migration Assistant (DMA)<\/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-146844'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>DRAG DROP <br \/>\r<br>You manage a financial computation data analysis process. Microsoft Azure virtual machines (VMs) run the process in daily jobs, and store the results in virtual hard drives (VHDs.) The VMs product results using data from the previous day and store the results in a snapshot of the VHD. When a new month begins, a process creates a new VHD. <br \/>\r<br>You must implement the following data retention requirements: <br \/>\r<br>- Daily results must be kept for 90 days <br \/>\r<br>- Data for the current year must be available for weekly reports <br \/>\r<br>- Data from the previous 10 years must be stored for auditing purposes <br \/>\r<br>- Data required for an audit must be produced within 10 days of a request. <br \/>\r<br>You need to enforce the data retention requirements while minimizing cost. <br \/>\r<br>How should you configure the lifecycle policy? To answer, drag the appropriate JSON segments to the correct locations. Each JSON segment may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view content. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=506 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image022-8.jpg\" v:shapes=\"_x0000_i1035\"><br><\/div><input type='hidden' name='question_id[]' id='qID_13' value='146844' \/><input type='hidden' id='answerType146844' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146844[]' id='textarea_q_146844' 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-146845'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>A company plans to use Azure SQL Database to support a mission-critical application. <br \/>\r<br>The application must be highly available without performance degradation during maintenance windows. <br \/>\r<br>You need to implement the solution. <br \/>\r<br>Which three technologies should you implement? 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='146845' \/><input type='hidden' id='answerType146845' 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-146845[]' id='answer-id-598584' class='answer   answerof-146845 ' value='598584'   \/><label for='answer-id-598584' id='answer-label-598584' class=' answer'><span>Premium service tier<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146845[]' id='answer-id-598585' class='answer   answerof-146845 ' value='598585'   \/><label for='answer-id-598585' id='answer-label-598585' class=' answer'><span>Virtual machine Scale Sets<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146845[]' id='answer-id-598586' class='answer   answerof-146845 ' value='598586'   \/><label for='answer-id-598586' id='answer-label-598586' class=' answer'><span>Basic service tier<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146845[]' id='answer-id-598587' class='answer   answerof-146845 ' value='598587'   \/><label for='answer-id-598587' id='answer-label-598587' class=' answer'><span>SQL Data Sync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146845[]' id='answer-id-598588' class='answer   answerof-146845 ' value='598588'   \/><label for='answer-id-598588' id='answer-label-598588' class=' answer'><span>Always On availability groups<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146845[]' id='answer-id-598589' class='answer   answerof-146845 ' value='598589'   \/><label for='answer-id-598589' id='answer-label-598589' class=' answer'><span>Zone-redundant configuration<\/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-146846'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>A company plans to use Azure Storage for file storage purposes. <br \/>\r<br>Compliance rules require: <br \/>\r<br>- A single storage account to store all operations including reads, writes and deletes <br \/>\r<br>- Retention of an on-premises copy of historical operations <br \/>\r<br>You need to configure the storage account. <br \/>\r<br>Which two actions should you perform? 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_15' value='146846' \/><input type='hidden' id='answerType146846' 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-146846[]' id='answer-id-598590' class='answer   answerof-146846 ' value='598590'   \/><label for='answer-id-598590' id='answer-label-598590' class=' answer'><span>Configure the storage account to log read, write and delete operations for service type Blob<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146846[]' id='answer-id-598591' class='answer   answerof-146846 ' value='598591'   \/><label for='answer-id-598591' id='answer-label-598591' class=' answer'><span>Use the AzCopy tool to download log data from $logs\/blob<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146846[]' id='answer-id-598592' class='answer   answerof-146846 ' value='598592'   \/><label for='answer-id-598592' id='answer-label-598592' class=' answer'><span>Configure the storage account to log read, write and delete operations for service-type table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146846[]' id='answer-id-598593' class='answer   answerof-146846 ' value='598593'   \/><label for='answer-id-598593' id='answer-label-598593' class=' answer'><span>Use the storage client to download log data from $logs\/table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146846[]' id='answer-id-598594' class='answer   answerof-146846 ' value='598594'   \/><label for='answer-id-598594' id='answer-label-598594' class=' answer'><span>Configure the storage account to log read, write and delete operations for service type queue<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-146847'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>DRAG DROP <br \/>\r<br>You are developing a solution to visualize multiple terabytes of geospatial data. <br \/>\r<br>The solution has the following requirements: <br \/>\r<br>- Data must be encrypted. <br \/>\r<br>- Data must be accessible by multiple resources on Microsoft Azure. <br \/>\r<br>You need to provision storage for the solution. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate action from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=650 height=393 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image030-6.jpg\" v:shapes=\"_x0000_i1039\"><br><\/div><input type='hidden' name='question_id[]' id='qID_16' value='146847' \/><input type='hidden' id='answerType146847' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146847[]' id='textarea_q_146847' 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-17' style=';'><div id='questionWrap-17'  class='   watupro-question-id-146848'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB. <br \/>\r<br>The solution has the following requirements: <br \/>\r<br>- Data must be partitioned into multiple containers. <br \/>\r<br>- Data containers must be configured separately. <br \/>\r<br>- Data must be accessible from applications hosted around the world. <br \/>\r<br>- The solution must minimize latency. <br \/>\r<br>You need to provision Azure Cosmos DB. <br \/>\r<br>Which three actions should you perform? 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_17' value='146848' \/><input type='hidden' id='answerType146848' 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-146848[]' id='answer-id-598596' class='answer   answerof-146848 ' value='598596'   \/><label for='answer-id-598596' id='answer-label-598596' class=' answer'><span>Configure account-level throughput.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598597' class='answer   answerof-146848 ' value='598597'   \/><label for='answer-id-598597' id='answer-label-598597' class=' answer'><span>Provision an Azure Cosmos DB account with the Azure Table AP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598598' class='answer   answerof-146848 ' value='598598'   \/><label for='answer-id-598598' id='answer-label-598598' class=' answer'><span>Enable geo-redundancy.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598599' class='answer   answerof-146848 ' value='598599'   \/><label for='answer-id-598599' id='answer-label-598599' class=' answer'><span>Configure table-level throughput.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598600' class='answer   answerof-146848 ' value='598600'   \/><label for='answer-id-598600' id='answer-label-598600' class=' answer'><span>Replicate the data globally by manually adding regions to the Azure Cosmos DB account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598601' class='answer   answerof-146848 ' value='598601'   \/><label for='answer-id-598601' id='answer-label-598601' class=' answer'><span>Provision an Azure Cosmos DB account with the Azure Table AP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146848[]' id='answer-id-598602' class='answer   answerof-146848 ' value='598602'   \/><label for='answer-id-598602' id='answer-label-598602' class=' answer'><span>Enable multi-region writes.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-146849'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. <br \/>\r<br>Which two factors affect your costs when sizing the Azure SQL Database elastic pools? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_18' value='146849' \/><input type='hidden' id='answerType146849' 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-146849[]' id='answer-id-598603' class='answer   answerof-146849 ' value='598603'   \/><label for='answer-id-598603' id='answer-label-598603' class=' answer'><span>maximum data size<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146849[]' id='answer-id-598604' class='answer   answerof-146849 ' value='598604'   \/><label for='answer-id-598604' id='answer-label-598604' class=' answer'><span>number of databases<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146849[]' id='answer-id-598605' class='answer   answerof-146849 ' value='598605'   \/><label for='answer-id-598605' id='answer-label-598605' class=' answer'><span>eDTUs consumption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146849[]' id='answer-id-598606' class='answer   answerof-146849 ' value='598606'   \/><label for='answer-id-598606' id='answer-label-598606' class=' answer'><span>number of read operations<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146849[]' id='answer-id-598607' class='answer   answerof-146849 ' value='598607'   \/><label for='answer-id-598607' id='answer-label-598607' class=' answer'><span>number of transactions<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-146850'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>HOTSPOT <br \/>\r<br>You are developing a solution using a Lambda architecture on Microsoft Azure. <br \/>\r<br>The data at rest layer must meet the following requirements: <br \/>\r<br>* Data storage: <br \/>\r<br>- Serve as a repository for high volumes of large files in various formats. <br \/>\r<br>- Implement optimized storage for big data analytics workloads. <br \/>\r<br>- Ensure that data can be organized using a hierarchical structure. <br \/>\r<br>* Batch processing: <br \/>\r<br>- Use a managed solution for in-memory computation processing. <br \/>\r<br>- Natively support Scala, Python, and R programming languages. <br \/>\r<br>- Provide the ability to resize and terminate the cluster automatically. <br \/>\r<br>* Analytical data store: <br \/>\r<br>- Support parallel processing. <br \/>\r<br>- Use columnar storage. <br \/>\r<br>- Support SQL-based languages. <br \/>\r<br>You need to identify the correct technologies to build the Lambda architecture. <br \/>\r<br>Which technologies should you use? 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=391 height=411 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image034-7.jpg\" v:shapes=\"_x0000_i1041\"><br><\/div><input type='hidden' name='question_id[]' id='qID_19' value='146850' \/><input type='hidden' id='answerType146850' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146850[]' id='textarea_q_146850' 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-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-146851'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>DRAG DROP <br \/>\r<br>Your company has on-premises Microsoft SQL Server instance. The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage. The process must orchestrate and manage the data lifecycle. You need to configure Azure Data Factory to connect to the SQL Server instance. <br \/>\r<br>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. <br \/>\r<br><br><img decoding=\"async\" width=649 height=290 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image038-7.jpg\" v:shapes=\"_x0000_i1043\"><br><\/div><input type='hidden' name='question_id[]' id='qID_20' value='146851' \/><input type='hidden' id='answerType146851' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146851[]' id='textarea_q_146851' 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-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-146852'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>A company runs Microsoft SQL Server in an on-premises virtual machine (VM). <br \/>\r<br>You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD). <br \/>\r<br>You need to configure Azure SQL Database to use an Azure AD user as administrator. <br \/>\r<br>What should you configure?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='146852' \/><input type='hidden' id='answerType146852' 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-146852[]' id='answer-id-598610' class='answer   answerof-146852 ' value='598610'   \/><label for='answer-id-598610' id='answer-label-598610' class=' answer'><span>For each Azure SQL Database, set the Access Control to administrator.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146852[]' id='answer-id-598611' class='answer   answerof-146852 ' value='598611'   \/><label for='answer-id-598611' id='answer-label-598611' class=' answer'><span>For each Azure SQL Database server, set the Active Directory to administrator.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146852[]' id='answer-id-598612' class='answer   answerof-146852 ' value='598612'   \/><label for='answer-id-598612' id='answer-label-598612' class=' answer'><span>For each Azure SQL Database, set the Active Directory administrator role.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146852[]' id='answer-id-598613' class='answer   answerof-146852 ' value='598613'   \/><label for='answer-id-598613' id='answer-label-598613' class=' answer'><span>For each Azure SQL Database server, set the Access Control to administrator.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-146853'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar (22). <br \/>\r<br>You need to implement masking for the Customer_ID field to meet the following requirements: <br \/>\r<br>- The first two prefix characters must be exposed. <br \/>\r<br>- The last four prefix characters must be exposed. <br \/>\r<br>- All other characters must be masked. <br \/>\r<br>Solution: You implement data masking and use a credit card function mask. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='146853' \/><input type='hidden' id='answerType146853' 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-146853[]' id='answer-id-598614' class='answer   answerof-146853 ' value='598614'   \/><label for='answer-id-598614' id='answer-label-598614' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146853[]' id='answer-id-598615' class='answer   answerof-146853 ' value='598615'   \/><label for='answer-id-598615' id='answer-label-598615' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-146854'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar (22). <br \/>\r<br>You need to implement masking for the Customer_ID field to meet the following requirements: <br \/>\r<br>- The first two prefix characters must be exposed. <br \/>\r<br>- The last four prefix characters must be exposed. <br \/>\r<br>- All other characters must be masked. <br \/>\r<br>Solution: You implement data masking and use an email function mask. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='146854' \/><input type='hidden' id='answerType146854' 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-146854[]' id='answer-id-598616' class='answer   answerof-146854 ' value='598616'   \/><label for='answer-id-598616' id='answer-label-598616' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146854[]' id='answer-id-598617' class='answer   answerof-146854 ' value='598617'   \/><label for='answer-id-598617' id='answer-label-598617' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-24' style=';'><div id='questionWrap-24'  class='   watupro-question-id-146855'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar (22). <br \/>\r<br>You need to implement masking for the Customer_ID field to meet the following requirements: <br \/>\r<br>- The first two prefix characters must be exposed. <br \/>\r<br>- The last four prefix characters must be exposed. <br \/>\r<br>- All other characters must be masked. <br \/>\r<br>Solution: You implement data masking and use a random number function mask. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='146855' \/><input type='hidden' id='answerType146855' 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-146855[]' id='answer-id-598618' class='answer   answerof-146855 ' value='598618'   \/><label for='answer-id-598618' id='answer-label-598618' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146855[]' id='answer-id-598619' class='answer   answerof-146855 ' value='598619'   \/><label for='answer-id-598619' id='answer-label-598619' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-25' style=';'><div id='questionWrap-25'  class='   watupro-question-id-146856'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>DRAG DROP <br \/>\r<br>You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your user account has contributor access to the storage account, and you have the application ID and access key. You plan to use PolyBase to load data into an enterprise data warehouse in Azure Synapse Analytics. You need to configure PolyBase to connect the data warehouse to the storage account. <br \/>\r<br>Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer are and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=646 height=386 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image042-5.jpg\" v:shapes=\"_x0000_i1045\"><br><\/div><input type='hidden' name='question_id[]' id='qID_25' value='146856' \/><input type='hidden' id='answerType146856' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146856[]' id='textarea_q_146856' 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-26' style=';'><div id='questionWrap-26'  class='   watupro-question-id-146857'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB. <br \/>\r<br>You need to create the table to meet the following requirements: <br \/>\r<br>- Provide the fastest query time. <br \/>\r<br>- Minimize data movement. <br \/>\r<br>Which type of table should you use?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='146857' \/><input type='hidden' id='answerType146857' 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-146857[]' id='answer-id-598621' class='answer   answerof-146857 ' value='598621'   \/><label for='answer-id-598621' id='answer-label-598621' class=' answer'><span>hash distributed<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146857[]' id='answer-id-598622' class='answer   answerof-146857 ' value='598622'   \/><label for='answer-id-598622' id='answer-label-598622' class=' answer'><span>heap<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146857[]' id='answer-id-598623' class='answer   answerof-146857 ' value='598623'   \/><label for='answer-id-598623' id='answer-label-598623' class=' answer'><span>replicated<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146857[]' id='answer-id-598624' class='answer   answerof-146857 ' value='598624'   \/><label for='answer-id-598624' id='answer-label-598624' class=' answer'><span>round-robin<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-146858'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>You have an enterprise data warehouse in Azure Synapse Analytics. <br \/>\r<br>Using PolyBase, you create table named [Ext].[Items] to query Parquet files stored in Azure Data Lake Storage Gen2 without importing the data to the data warehouse. <br \/>\r<br>The external table has three columns. <br \/>\r<br>You discover that the Parquet files have a fourth column named ItemID. <br \/>\r<br>Which command should you run to add the ItemID column to the external table? <br \/>\r<br><br><img decoding=\"async\" width=577 height=525 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image046-5.jpg\" v:shapes=\"_x0000_i1047\"><br><\/div><input type='hidden' name='question_id[]' id='qID_27' value='146858' \/><input type='hidden' id='answerType146858' 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-146858[]' id='answer-id-598625' class='answer   answerof-146858 ' value='598625'   \/><label for='answer-id-598625' id='answer-label-598625' class=' answer'><span>Option A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146858[]' id='answer-id-598626' class='answer   answerof-146858 ' value='598626'   \/><label for='answer-id-598626' id='answer-label-598626' class=' answer'><span>Option B<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146858[]' id='answer-id-598627' class='answer   answerof-146858 ' value='598627'   \/><label for='answer-id-598627' id='answer-label-598627' class=' answer'><span>Option C<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146858[]' id='answer-id-598628' class='answer   answerof-146858 ' value='598628'   \/><label for='answer-id-598628' id='answer-label-598628' class=' answer'><span>Option D<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-146859'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>DRAG DROP <br \/>\r<br>You have a table named SalesFact in Azure Synapse Analytics. <br \/>\r<br>SalesFact contains sales data from the past 36 months and has the following characteristics: <br \/>\r<br>- Is partitioned by month <br \/>\r<br>- Contains one billion rows <br \/>\r<br>- Has clustered columnstore indexes <br \/>\r<br>All the beginning of each month, you need to remove data SalesFact that is older than 36 months as quickly as possible. <br \/>\r<br>Which three actions should you perform in sequence in a stored procedure? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=649 height=335 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image048-5.jpg\" v:shapes=\"_x0000_i1048\"><br><\/div><input type='hidden' name='question_id[]' id='qID_28' value='146859' \/><input type='hidden' id='answerType146859' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146859[]' id='textarea_q_146859' 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-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-146860'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>You plan to implement an Azure Cosmos DB database that will write 100,000,000 JSON every 24 hours. The database will be replicated to three regions. Only one region will be writable. <br \/>\r<br>You need to select a consistency level for the database to meet the following requirements: <br \/>\r<br>- Guarantee monotonic reads and writes within a session. <br \/>\r<br>- Provide the fastest throughput. <br \/>\r<br>- Provide the lowest latency. <br \/>\r<br>Which consistency level should you select?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='146860' \/><input type='hidden' id='answerType146860' 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-146860[]' id='answer-id-598630' class='answer   answerof-146860 ' value='598630'   \/><label for='answer-id-598630' id='answer-label-598630' class=' answer'><span>Strong<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146860[]' id='answer-id-598631' class='answer   answerof-146860 ' value='598631'   \/><label for='answer-id-598631' id='answer-label-598631' class=' answer'><span>Bounded Staleness<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146860[]' id='answer-id-598632' class='answer   answerof-146860 ' value='598632'   \/><label for='answer-id-598632' id='answer-label-598632' class=' answer'><span>Eventual<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146860[]' id='answer-id-598633' class='answer   answerof-146860 ' value='598633'   \/><label for='answer-id-598633' id='answer-label-598633' class=' answer'><span>Session<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146860[]' id='answer-id-598634' class='answer   answerof-146860 ' value='598634'   \/><label for='answer-id-598634' id='answer-label-598634' class=' answer'><span>Consistent Prefix<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-30' style=';'><div id='questionWrap-30'  class='   watupro-question-id-146861'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22). <br \/>\r<br>You need to implement masking for the Customer_ID field to meet the following requirements: <br \/>\r<br>- The first two prefix characters must be exposed. <br \/>\r<br>- The last four prefix characters must be exposed. <br \/>\r<br>- All other characters must be masked. <br \/>\r<br>Solution: You implement data masking and use a credit card function mask. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_30' value='146861' \/><input type='hidden' id='answerType146861' 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-146861[]' id='answer-id-598635' class='answer   answerof-146861 ' value='598635'   \/><label for='answer-id-598635' id='answer-label-598635' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146861[]' id='answer-id-598636' class='answer   answerof-146861 ' value='598636'   \/><label for='answer-id-598636' id='answer-label-598636' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-31' style=';'><div id='questionWrap-31'  class='   watupro-question-id-146862'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB. <br \/>\r<br>You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics. <br \/>\r<br>You need to prepare the files to ensure that the data copies quickly. <br \/>\r<br>Solution: You modify the files to ensure that each row is less than 1 MB. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_31' value='146862' \/><input type='hidden' id='answerType146862' 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-146862[]' id='answer-id-598637' class='answer   answerof-146862 ' value='598637'   \/><label for='answer-id-598637' id='answer-label-598637' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146862[]' id='answer-id-598638' class='answer   answerof-146862 ' value='598638'   \/><label for='answer-id-598638' id='answer-label-598638' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-146863'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB. <br \/>\r<br>You plan to copy the data from the storage account to an Azure SQL data warehouse. <br \/>\r<br>You need to prepare the files to ensure that the data copies quickly. <br \/>\r<br>Solution: You modify the files to ensure that each row is more than 1 MB. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_32' value='146863' \/><input type='hidden' id='answerType146863' 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-146863[]' id='answer-id-598639' class='answer   answerof-146863 ' value='598639'   \/><label for='answer-id-598639' id='answer-label-598639' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146863[]' id='answer-id-598640' class='answer   answerof-146863 ' value='598640'   \/><label for='answer-id-598640' id='answer-label-598640' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-33' style=';'><div id='questionWrap-33'  class='   watupro-question-id-146864'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>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. <br \/>\r<br>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. <br \/>\r<br>You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical <br \/>\r<br>values. 75% of the rows contain description data that has an average length of 1.1 MB. You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics. You need to prepare the files to ensure that the data copies quickly. <br \/>\r<br>Solution: You copy the files to a table that has a columnstore index. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='146864' \/><input type='hidden' id='answerType146864' 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-146864[]' id='answer-id-598641' class='answer   answerof-146864 ' value='598641'   \/><label for='answer-id-598641' id='answer-label-598641' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146864[]' id='answer-id-598642' class='answer   answerof-146864 ' value='598642'   \/><label for='answer-id-598642' id='answer-label-598642' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-146865'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>You plan to deploy an Azure Cosmos DB database that supports multi-master replication. <br \/>\r<br>You need to select a consistency level for the database to meet the following requirements: <br \/>\r<br>- Provide a recovery point objective (RPO) of less than 15 minutes. <br \/>\r<br>- Provide a recovery time objective (RTO) of zero minutes. <br \/>\r<br>What are three possible consistency levels that you can select? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_34' value='146865' \/><input type='hidden' id='answerType146865' 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-146865[]' id='answer-id-598643' class='answer   answerof-146865 ' value='598643'   \/><label for='answer-id-598643' id='answer-label-598643' class=' answer'><span>Strong<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146865[]' id='answer-id-598644' class='answer   answerof-146865 ' value='598644'   \/><label for='answer-id-598644' id='answer-label-598644' class=' answer'><span>Bounded Staleness<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146865[]' id='answer-id-598645' class='answer   answerof-146865 ' value='598645'   \/><label for='answer-id-598645' id='answer-label-598645' class=' answer'><span>Eventual<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146865[]' id='answer-id-598646' class='answer   answerof-146865 ' value='598646'   \/><label for='answer-id-598646' id='answer-label-598646' class=' answer'><span>Session<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-146865[]' id='answer-id-598647' class='answer   answerof-146865 ' value='598647'   \/><label for='answer-id-598647' id='answer-label-598647' class=' answer'><span>Consistent Prefix<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-35' style=';'><div id='questionWrap-35'  class='   watupro-question-id-146866'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>SIMULATION <br \/>\r<br><br><img decoding=\"async\" width=403 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image053-2.jpg\" v:shapes=\"_x0000_i1051\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You need to ensure that you can recover any blob data from an Azure Storage account named storage 10277521 up to 30 days after the data is deleted. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_35' value='146866' \/><input type='hidden' id='answerType146866' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146866[]' id='textarea_q_146866' 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-36' style=';'><div id='questionWrap-36'  class='   watupro-question-id-146867'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>SIMULATION <br \/>\r<br><br><img decoding=\"async\" width=400 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image059-2.jpg\" v:shapes=\"_x0000_i1054\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region. <br \/>\r<br>To complete this task, sign in to the Azure portal. <br \/>\r<br>NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or ends this section of the exam. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_36' value='146867' \/><input type='hidden' id='answerType146867' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146867[]' id='textarea_q_146867' 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-37' style=';'><div id='questionWrap-37'  class='   watupro-question-id-146868'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br><br><img decoding=\"async\" width=400 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image067-2.jpg\" v:shapes=\"\u56fe\u7247_x0020_266\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You need to create an Azure SQL database named db3 on an Azure SQL server named SQL10277521. Db3 must use the Sample (AdventureWorksLT) source. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_37' value='146868' \/><input type='hidden' id='answerType146868' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146868[]' id='textarea_q_146868' 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-38' style=';'><div id='questionWrap-38'  class='   watupro-question-id-146869'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>SIMULATION <br \/>\r<br><br><img decoding=\"async\" width=400 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image070-2.jpg\" v:shapes=\"_x0000_i1061\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You plan to query db3 to retrieve a list of sales customers. The query will retrieve several columns that include the email address of each sales customer. <br \/>\r<br>You need to modify db3 to ensure that a portion of the email addresses is hidden in the query results. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_38' value='146869' \/><input type='hidden' id='answerType146869' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146869[]' id='textarea_q_146869' 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-39' style=';'><div id='questionWrap-39'  class='   watupro-question-id-146870'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br><br><img decoding=\"async\" width=400 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image067-3.jpg\" v:shapes=\"\u56fe\u7247_x0020_219\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You need to increase the size of db2 to store up to 250 GB of data. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_39' value='146870' \/><input type='hidden' id='answerType146870' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146870[]' id='textarea_q_146870' 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-40' style=';'><div id='questionWrap-40'  class='   watupro-question-id-146871'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>HOTSPOT <br \/>\r<br>You have an enterprise data warehouse in Azure Synapse Analytics that contains a table named FactOnlineSales. The table contains data from the start of 2009 to the end of 2012. <br \/>\r<br>You need to improve the performance of queries against FactOnlineSales by using table partitions. <br \/>\r<br>The solution must meet the following requirements: <br \/>\r<br>- Create four partitions based on the order date. <br \/>\r<br>- Ensure that each partition contains all the orders placed during a given calendar year. <br \/>\r<br>How should you complete the T-SQL command? 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=633 height=493 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image080-3.jpg\" v:shapes=\"_x0000_i1067\"><br><\/div><input type='hidden' name='question_id[]' id='qID_40' value='146871' \/><input type='hidden' id='answerType146871' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146871[]' id='textarea_q_146871' 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-41' style=';'><div id='questionWrap-41'  class='   watupro-question-id-146872'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>41. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image084-2.jpg\" v:shapes=\"_x0000_i1069\"><br><br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_41' value='146872' \/><input type='hidden' id='answerType146872' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146872[]' id='textarea_q_146872' 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-42' style=';'><div id='questionWrap-42'  class='   watupro-question-id-146873'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>42. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image093-1.jpg\" v:shapes=\"_x0000_i1074\"><br><br \/>\r<br>You need to create an Azure Storage account named account10543936. <br \/>\r<br>The solution must meet the following requirements: <br \/>\r<br>- Minimize storage costs. <br \/>\r<br>- Ensure that account10543936 can store many image files. <br \/>\r<br>- Ensure that account10543936 can quickly retrieve stored image files. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_42' value='146873' \/><input type='hidden' id='answerType146873' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146873[]' id='textarea_q_146873' 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-43' style=';'><div id='questionWrap-43'  class='   watupro-question-id-146874'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>43. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image093-2.jpg\" v:shapes=\"_x0000_i1076\"><br><br \/>\r<br>You need to ensure that users in the West US region can read data from a local copy of an Azure Cosmos DB database named cosmos10543936. <br \/>\r<br>To complete this task, sign in to the Azure portal. <br \/>\r<br>NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or end this section of the exam.<\/div><input type='hidden' name='question_id[]' id='qID_43' value='146874' \/><input type='hidden' id='answerType146874' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146874[]' id='textarea_q_146874' 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-44' style=';'><div id='questionWrap-44'  class='   watupro-question-id-146875'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>44. <\/span>SIMULATION <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2020\/09\/image093-3.jpg\" v:shapes=\"_x0000_i1079\"><br><br \/>\r<br>You plan to enable Azure Multi-Factor Authentication (MFA). <br \/>\r<br>You need to ensure that User1-10543936@ExamUsers.com can manage any databases hosted on an Azure SQL server named SQL10543936 by signing in using his Azure Active Directory (Azure AD) user account. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_44' value='146875' \/><input type='hidden' id='answerType146875' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-146875[]' id='textarea_q_146875' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-45'>\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=\"watuPROButtons4630\" >\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=\"4630\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 06:28:57\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777616937\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"146832:598539,598540,598541,598542 | 146833:598543 | 146834:598544,598545,598546,598547 | 146835:598548,598549,598550,598551,598552 | 146836:598553,598554,598555,598556,598557 | 146837:598558,598559,598560,598561,598562 | 146838:598563 | 146839:598564 | 146840:598565,598566,598567,598568 | 146841:598569,598570,598571,598572 | 146842:598573,598574,598575,598576,598577 | 146843:598578,598579,598580,598581,598582 | 146844:598583 | 146845:598584,598585,598586,598587,598588,598589 | 146846:598590,598591,598592,598593,598594 | 146847:598595 | 146848:598596,598597,598598,598599,598600,598601,598602 | 146849:598603,598604,598605,598606,598607 | 146850:598608 | 146851:598609 | 146852:598610,598611,598612,598613 | 146853:598614,598615 | 146854:598616,598617 | 146855:598618,598619 | 146856:598620 | 146857:598621,598622,598623,598624 | 146858:598625,598626,598627,598628 | 146859:598629 | 146860:598630,598631,598632,598633,598634 | 146861:598635,598636 | 146862:598637,598638 | 146863:598639,598640 | 146864:598641,598642 | 146865:598643,598644,598645,598646,598647 | 146866:598648 | 146867:598649 | 146868:598650 | 146869:598651 | 146870:598652 | 146871:598653 | 146872:598654 | 146873:598655 | 146874:598656 | 146875:598657\" \/>\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 = \"146832,146833,146834,146835,146836,146837,146838,146839,146840,146841,146842,146843,146844,146845,146846,146847,146848,146849,146850,146851,146852,146853,146854,146855,146856,146857,146858,146859,146860,146861,146862,146863,146864,146865,146866,146867,146868,146869,146870,146871,146872,146873,146874,146875\";\nWatuPROSettings[4630] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 4630;\t    \nWatuPRO.post_id = 12184;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.86024900 1777616937\";\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(4630);\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,6074],"tags":[6741,6742,6743,6746,6745,7719],"class_list":["post-12184","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-data-certification","tag-dp-200","tag-dp-200-dumps","tag-dp-200-dumps-questions","tag-dp-200-exam-dumps","tag-dp-200-exam-questions","tag-dp-200-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/12184","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=12184"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/12184\/revisions"}],"predecessor-version":[{"id":12185,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/12184\/revisions\/12185"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=12184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=12184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=12184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}