{"id":81710,"date":"2022-03-25T01:38:01","date_gmt":"2022-03-25T07:08:01","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=81710"},"modified":"2023-05-19T08:29:43","modified_gmt":"2023-05-19T13:59:43","slug":"dp-900-exam-questions-and-answers","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/","title":{"rendered":"Free Questions on Microsoft Azure Data Fundamentals (DP-900) Certification Exam"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">The DP-900: Microsoft Azure Data Fundamentals certification is for you, if you are new to Cloud and just getting started with it. You must also be aware of the relational and non-relational data concepts, and various kinds of data workloads such as analytical and transactional.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">These free <a href=\"https:\/\/www.whizlabs.com\/microsoft-azure-certification-dp-900\/\">DP-900 Exam Questions<\/a> and Answers provide you with an overview of the Microsoft Azure Data Fundamentals certification, and introduce you to the various objectives and concepts of the DP-900 exam.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ea7e02;color:#ea7e02\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ea7e02;color:#ea7e02\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure-2\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts-2\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure-3\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-2\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure-2\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure-4\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-3\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts-3\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure-3\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure-4\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure-5\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_relational_data_on_Azure-6\" >Domain : Describe how to work with relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure-5\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-4\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-5\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-6\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_an_analytics_workload_on_Azure-7\" >Domain : Describe an analytics workload on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts-4\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts-5\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_core_data_concepts-6\" >Domain : Describe core data concepts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Domain_Describe_how_to_work_with_non-relational_data_on_Azure-6\" >Domain : Describe how to work with non-relational data on Azure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.whizlabs.com\/blog\/dp-900-exam-questions-and-answers\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q1 : What is the role of a pipeline in a data factory in the management of activities?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>A pipeline allows the management of activities as a set<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>A pipeline allows the management of activities individually<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>A pipeline allows the management of activities individually and as a set both<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>There is no role of pipeline in the management of activities<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A pipeline itself is a group of activities that performs a task altogether in an Azure data factory. It means pipeline allows the management of activities as a set, not individually. One can not deploy and schedule activities independently, but as a pipeline only.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. A pipeline is a group of activities, grouped as per logic and performs a task altogether in a data factory. The pipeline allows the management of activities as a set.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. A pipeline is a group of activities and does not allow the management of activities individually.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. A pipeline allows the management of activities as a set only, not individually.<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. A pipeline allows the management of activities as a set.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about the Pipeline and Activities in Azure Data Factory, refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/concepts-pipelines-activities\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/concepts-pipelines-activities<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q2 : Read the statement &#8211; \u201cIn relational databases, all the values in a column will have the same data type.\u201d<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Yes<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>No<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A relational database stores data and provides access to data points that are related to each other. A relational database follows the basic relational model that is a simple and straightforward method of storing data in tables. Each row of the table in a relational database represents a record with a unique id i.e. key. Each column of the table holds an attribute of the data, and each record represents the value for each attribute.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For example, a table STUDENT_RECORD represents the record of students in a class and the attributes of columns are &#8211; Student_Id, Student_Name, Student_Branch, and Student_Marks. We need to define the data type of each attribute in the beginning at the time of the creation of the table. Here, if we set Student_Id as a number, all the values in the column Student_Id will contain numbers only. And if we set it as alphanumeric, all the values in the column Student_Id will contain both alphabets and numbers.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Student_Id<\/b><\/td>\n<td><b>Student_Name<\/b><\/td>\n<td><b>Student_Class<\/b><\/td>\n<td><b>Student_Marks<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1001<\/span><\/td>\n<td><span style=\"font-weight: 400;\">John<\/span><\/td>\n<td><span style=\"font-weight: 400;\">CS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">903<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1002<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Koe<\/span><\/td>\n<td><span style=\"font-weight: 400;\">EC<\/span><\/td>\n<td><span style=\"font-weight: 400;\">678<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1003<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Faiz<\/span><\/td>\n<td><span style=\"font-weight: 400;\">IT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">782<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1004<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Kally<\/span><\/td>\n<td><span style=\"font-weight: 400;\">ME<\/span><\/td>\n<td><span style=\"font-weight: 400;\">876<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">So, <\/span><b>Option A is correct.<\/b><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about the characteristics of Relational Databases, click the Link below: <\/span><a href=\"https:\/\/docs.rackspace.com\/support\/how-to\/properties-of-rdbmss-and-nosql-databases\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.rackspace.com\/support\/how-to\/properties-of-rdbmss-and-nosql-databases\/<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q3 : Which of the following is not a feature of the Azure Database for MariaDB?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>High availability and predictable performance<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Provides read and write mysql system database<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Autoscaling, auto backups, and point-in-time-restore<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Secure protection of data with enterprise-grade security and compliance<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure Database for MariaDB is a relational database service with the following features:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Build-in high availability without any extra cost<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Autoscaling whenever required, within seconds<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enterprise-level security and compliance<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Predictable performance with the pay-as-you-go model<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Auto backups and point-in-time-restore for up to 35 days<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Protection and security of confidential data in motion as well as at rest<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Azure Database for MariaDB has a limitation that the mysql system database in Azure Database for MariaDB is a read-only as it supports a number of PaaS functionality. You can\u2019t make any changes to the mysql system database.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure Database for MariaDB delivers build-in high availability without any additional cost and predictable performance with a pay-as-you-go pricing model.<\/span><br \/>\n<b>Option B is correct<\/b><span style=\"font-weight: 400;\">. The mysql system database in Azure Database for MariaDB is read-only as it supports a number of PaaS functionality. You can\u2019t make any changes to the mysql system database.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Azure Database for MariaDB delivers autoscaling in seconds when required, auto backups, and power-in-time-restore.<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Azure Database for MariaDB delivers secured protection of sensitive data in motion as well as at rest, and also offer enterprise-level compliance and security.<\/span><\/p>\n<p><b>References<\/b><span style=\"font-weight: 400;\">: To know more about the Azure Database for MariaDB, refer to the links below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mariadb\/overview\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/mariadb\/overview<\/span><\/a>,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mariadb\/concepts-limits\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/mariadb\/concepts-limits<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q4 : Which of the following is a unique identifier for the document, often hashed for the even distribution of data, and helps in the retrieval of data from the document in the document data store?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Primary Key<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Hash Key<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Secondary Key<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Document Key<\/span><\/p>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A document data store manages the object data values and named string fields in documents. The document key is a unique identifier for the document, often hashed for the even distribution of data. It helps in the retrieval of data from the document. In some document databases, the document key is created automatically while in others, you have to set an attribute of the document and use it as the document key.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. There is no primary key in the document of a document data store. The data is retrieved with the help of a unique identifier, document key.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. There is no hash key in the document of a document data store. The data is retrieved with the help of a unique identifier, document key.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. There is no secondary key in the document of a document data store. The data is retrieved with the help of a unique identifier, document key.<\/span><br \/>\n<b>Option D is correct<\/b><span style=\"font-weight: 400;\">. The document key is a unique identifier for the document, often hashed for the even distribution of data. It helps in the retrieval of data from the document.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about the Document Data Store, refer to the link below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/data-guide\/big-data\/non-relational-data\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/data-guide\/big-data\/non-relational-data<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure-2\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q5 : You are working as a Data Associate in an organization. Your client has accomplished the tasks with his Azure CosmoDB account and wants to delete it.<\/strong><br \/>\n<strong>He does not know about the steps to be followed for it. You need to help him to follow the right sequence of steps to clean up his Azure Cosmos DB account. How will you arrange the following steps in the right sequence?<\/strong><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Select the created resource group for the quickstart.<\/strong><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Search and Select Resource Groups in the Azure Portal Search Bar.<\/strong><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Enter the name of the resource group you want to delete and select Delete.<\/strong><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Select Delete Resource Group on the Resource Group Overview Page.<\/strong><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>2143<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>1342<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>4231<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>1234<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">You can delete the Azure resources when you are done with them. In the same manner, when you are done with the Azure Cosmo DB, you can delete your Azure Cosmo DB account. The steps to delete an Azure Cosmo DB account are as below:<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Search and Select Resource Groups in the Azure Portal Search Bar.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Select the created resource group.<img decoding=\"async\" class=\"aligncenter wp-image-81713 size-full\" title=\"non relational data on Azure resource group\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1.png\" alt=\"non relational data on Azure resource group\" width=\"823\" height=\"215\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1.png 823w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1-300x78.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1-768x201.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1-640x167.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.1-681x178.png 681w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Select Delete Resource Group on the Resource Group Overview Page.<img decoding=\"async\" class=\"aligncenter wp-image-81714 size-full\" title=\"Azure resource group overview\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2.png\" alt=\"Azure resource group overview\" width=\"826\" height=\"265\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2.png 826w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2-300x96.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2-768x246.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2-640x205.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp5.2-681x218.png 681w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/span><\/li>\n<li><span style=\"font-weight: 400;\"> Enter the name of the resource group you want to delete and select Delete.<\/span><\/li>\n<\/ol>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. Search and Select Resource Groups in the Azure Portal Search Bar, Select the created resource group, Select Delete Resource Group on the Resource Group Overview Page, Enter the name of the resource group you want to delete, and select Delete is the correct sequence of steps to delete an Azure Cosmo DB account.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. 1342 doesn\u2019t form the correct sequence of steps for the deletion of an Azure Cosmo DB account.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. 4321 doesn\u2019t form the correct sequence of steps for the deletion of an Azure Cosmo DB account.<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. 1234 doesn\u2019t form the correct sequence of steps for the deletion of an Azure Cosmo DB account.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about Cosmo DB Resources, refer to the link below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/create-cosmosdb-resources-portal\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/create-cosmosdb-resources-portal<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts-2\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q6 : The common tasks and responsibilities of a data analyst include,<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Finding hidden patterns using data<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Focuses only on the available data<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Restricts access to data in the company<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Arrives at conclusions with one-step analysis<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A data analyst uses various techniques and tools for collating data from different sources to visualize the data in an understandable and relevant format. Data analysts use the visualization tools for the transformation of data into graphical formats that can help in finding useful patterns in the data.<\/span><\/p>\n<p><b>Option A is CORRECT.<\/b><span style=\"font-weight: 400;\"> Data analysts are primarily responsible for using visualization tools, and their skills in using data can help them in the transformation of data into understandable formats according to business requirements.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Data analysts combine the resultant sets of data from different sources, and in some cases; they rely on live operational data.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Data analysts have to share their data visualization reports with employees in other departments while also addressing the responsibility of integrating data from many sources for better insights.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Data analysts don\u2019t just observe the data from different sources arranged in a specific format to deliver insights. They have to refine the data by removing redundancies and errors in raw data from different sources and transform it, followed by improvements before visualizing them into desired formats.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the tasks and responsibilities of data analysts refer to the following Azure documentation: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/5-review-tasks-tools-for-data-visualization-reporting\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/5-review-tasks-tools-for-data-visualization-reporting<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure-3\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q7 : Which of the following use case scenarios aptly relates to the use of non-relational data offerings on Azure?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Inventory management systems<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Database migration systems<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Accounting systems<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Transaction management systems<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Non-relational data offerings or NoSQL databases are ideally suited for managing large, unrelated, and rapidly fluctuating data, thereby serving as the fitting option for database migration use cases.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Inventory management systems require a specific schema alongside the need for continuous synchronization between the database and the system.<\/span><br \/>\n<b>Option B is CORRECT.<\/b><span style=\"font-weight: 400;\"> Database migration systems can leverage non-relational data offerings on Azure for coping with the massive volumes of unrelated, rapidly fluctuating, and indeterminate data.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Accounting systems are generally associated with legacy systems that are fit for relational structures, thereby downplaying the significance of non-relational data offerings.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Transaction management systems often deal with complex querying requirements and the needs for multi-row transactions. Therefore, non-relational data offerings on Azure might not be a fitting option.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the suitable use cases for non-relational data offerings on Azure, explore the following Azure documentation: <\/span><a href=\"https:\/\/azure.microsoft.com\/en-in\/overview\/nosql-database\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/azure.microsoft.com\/en-in\/overview\/nosql-database\/<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-2\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q8 : Which of the following benefits don\u2019t relate closely to interactive reports in Power BI?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>AI-powered augmented analytics<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Advanced analytics with the knowledge of MS Office<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Easier preparation and modeling of data<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Ideal for enterprise and medium companies that have human capital for supporting data analytics<\/span><\/p>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The tool that relates closely to the benefit of being the ideal tool for enterprise and medium companies with the human capital for supporting data analytics operations in Tableau. It provides easier creation of dashboards in comparison to Power BI. Therefore, the answer does not relate closely to the benefits of interactive reports with Power BI.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. AI-powered augmented analytics is an evident advantage with the interactive reports in Power BI with a focus on new AI capabilities evident with Azure and now in Power BI.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Advanced analytics with fluency in MS Office is critical functionality evident with interactive reports in Power BI. It can enable diving deeper into data for discovering patterns that can foster actionable insights. Users can get full control over their data analytics model with Power BI through the comprehensive DAX formula language.<\/span><br \/>\n<b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">Power BI allows easier and faster preparation and modeling of data through the facility of productive data modeling tools. The self-service Power Query experience with Power BI directly benefits interactive reports, unlike other tools.<\/span><br \/>\n<b>Option D is CORRECT. <\/b><span style=\"font-weight: 400;\">The support of human capital is superfluous in the case of Power BI with the facility of sophisticated functionalities to leverage interactive reports for ensuring desired data analytics activities.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">If you want to know more about the functionalities of data visualization in Microsoft Power BI, then go through the following resource: <\/span><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/desktop\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/powerbi.microsoft.com\/en-us\/desktop\/<\/span><\/a><span style=\"font-weight: 400;\">\u00a0\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure-2\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q9 : How many virtual machine images are maintained by Azure for each supported operating system (OS), version, and edition combination?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>One<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Two<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Three<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Unlimited<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure maintains 1 virtual machine (VM) image for each supported operating system (OS), version, and edition combination. The images are refreshed over time, and the older ones are removed.<\/span><\/p>\n<p><b>Option A is CORRECT.<\/b><span style=\"font-weight: 400;\"> Azure maintains 1 virtual machine (VM) image for each supported operating system (OS), version, and edition combination. The images are refreshed over time, and the older ones are removed.<\/span><br \/>\n<b>Option B is incorrect <\/b><span style=\"font-weight: 400;\">as only 1 virtual machine image is maintained by Azure for each supported operating system (OS), version, and edition combination.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\"> as only 1 virtual machine image is maintained by Azure for each supported operating system (OS), version, and edition combination.<\/span><br \/>\n<b>Option D is incorrect <\/b><span style=\"font-weight: 400;\">as only 1 virtual machine image is maintained by Azure for each supported operating system (OS), version, and edition combination.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more, refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/sql-server-on-azure-vm-iaas-what-is-overview\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/virtual-machines\/windows\/sql-server-on-azure-vm-iaas-what-is-overview<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure-4\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q10 : You need to store semi-structured data in the database as key-value pairs where the key is unique and columns can vary and each row holds the whole data for a logical entity. Which storage option should you choose?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Azure Table Storage<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Azure File Storage<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Azure Blob Storage<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>None<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure Table storage stores a large amount of structured NoSQL data in the cloud, providing a key-value store with a schemaless design. A table can be created using an Azure storage account. In the table, rows indicate the items, and columns represent the various fields and values. The following diagram depicts the components of table storage.<img decoding=\"async\" class=\"aligncenter wp-image-81715 size-full\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp10.png\" alt=\"Microsoft Azure Table Storage DP-900\" width=\"431\" height=\"266\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp10.png 431w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp10-300x185.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/span><\/p>\n<p><b>Option A is CORRECT<\/b><span style=\"font-weight: 400;\"> as Azure table storage follows the key\/value model to store the data.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure Blob storage is an object storage solution that allows storing huge amounts of unstructured data in the cloud. It does not store the data as key-value pairs.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure File Storage is a shared storage service that supports creating files shares in the cloud, and accessing these file shares from anywhere and at any time with an internet connection.<\/span><\/p>\n<p><b>References: <\/b><span style=\"font-weight: 400;\">To know more about the different type of storage options, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/tables\/table-storage-overview\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/tables\/table-storage-overview<\/span><\/a>,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/blobs\/storage-blobs-overview\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/blobs\/storage-blobs-overview<\/span><\/a>,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/files\/storage-files-introduction\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/files\/storage-files-introduction<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-3\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q11 : Which of the following components of an Azure Data Factory is triggered to run data ingestion tasks?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Pipeline<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Datasets<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Linked Services<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>CSV file<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure Data Factory consists of various key components like Pipelines, Activities, Datasets, Linked services, Data Flows, and Integration Runtimes. All these components collectively provide a platform that allows you to compose data-driven workflows with steps to move and transform data. Out of these components, Pipeline is the component that is triggered to run data ingestion tasks.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0A data factory may consist of one or more pipelines. A pipeline represents a logical grouping of tasks\/activities and these activities collectively perform a task. For example, a pipeline may consist of a group of activities that ingest data from an Azure blob and then run a Hive query on an HDInsight cluster for data partitioning.<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> A pipeline is the component of the Azure data factory that is triggered to run activities for ingesting data.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Datasets in the Azure data factory is not any task that can be run. Instead, a dataset represents the data structures within the data stores, which is a reference to the data that is to be used as inputs or outputs in the activities.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Linked services in the Azure data factory specify the connection parameters to connect to the Azure service. It is not any task that could be run.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Although a CSV file can be exported or imported, an orchestration framework is necessary to run it.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Azure Data Factory, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/introduction\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/introduction<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts-3\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q12 : Which of the following is\/are the example(s) of unstructured data?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>A student table with columns studentname, student_id, and Registration<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Audio and video files and binary data files<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>A table within SQL Server database<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>A student table with rows studentname, student_id, and Registration<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>E. <\/strong>JSON Document<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The data or dataset having a predefined structure is the structured data.\u00a0 Structured data is typically tabular data that is represented by rows and columns in a database. Databases that store the data in this form are known as Relational Databases.\u00a0 On the other hand, data not having any specific structure is known as unstructured data.\u00a0 Among the given options, Audio and Video files and binary files are the ones having no specific structure and therefore is an example of unstructured data. Besides structured and unstructured data, there is also <\/span><i><span style=\"font-weight: 400;\">Semi-structured<\/span><\/i><span style=\"font-weight: 400;\"> data that doesn&#8217;t exist in a relational database but still has some structure associated with it. Documents in <\/span><i><span style=\"font-weight: 400;\">JavaScript Object Notation<\/span><\/i><span style=\"font-weight: 400;\"> (JSON) format are examples of semi-structured data.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> A student table with a defined set of columns is an example of structured data.<\/span><br \/>\n<b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> As audio and video files and binary data files might not have a specific structure, they are unstructured data.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> A table within SQL Server database is an example of structured data as it has predefined columns and structure.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> A student table with a defined set of rows is an example of structured data.<\/span><br \/>\n<b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> Documents in <\/span><i><span style=\"font-weight: 400;\">JavaScript Object Notation<\/span><\/i><span style=\"font-weight: 400;\"> (JSON) format are examples of semi-structured data.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-core-data-concepts\/2-identify-need-data-solutions\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-core-data-concepts\/2-identify-need-data-solutions<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure-3\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q13 : Complete the statement.<\/strong><br \/>\n<strong>In Azure SQL databases, transparent data encryption encrypts the \u2026\u2026\u2026\u2026\u2026..\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Database to protect the data in the motion<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Server to protect the data in the motion<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Database to protect the data at rest<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Server to protect the data at rest<\/span><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Transparent Data Encryption (TDE) protects Azure SQL Database, Azure Synapse Analytics, and Azure SQL Managed Instance against malicious offline activities by encrypting the data at rest. Here, the database, associated backups, and transaction log files at rest can be encrypted and decrypted in real-time without the need for any change in the application.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">.\u00a0 Transparent Data Encryption (TDE) protects the data at rest; not in the motion. To protect the data in the motion, transport layer security is used.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Transparent Data Encryption (TDE) protects the data at rest; not in the motion. To protect the data in the motion, transport layer security is used.<\/span><br \/>\n<b>Option C is CORRECT.<\/b><span style=\"font-weight: 400;\"> Transparent Data Encryption (TDE)\u00a0 encrypts the database to protects the data at rest.<\/span><br \/>\n<b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">Transparent Data Encryption (TDE)\u00a0 encrypts the database, not the server,\u00a0 to protects the data at rest.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about theTransparent Data Encryption (TDE), refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/transparent-data-encryption-tde-overview?tabs=azure-portal\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/transparent-data-encryption-tde-overview?tabs=azure-portal<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure-4\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q14 : In the following SQL query:<\/strong><br \/>\n<strong>INSERT INTO Students ( StudentName , StudentID , Marks , Address) VALUES (\u2018Ram\u2019 , 1501,\u00a0 87, \u2018Delhi\u2019) ;<\/strong><br \/>\n<strong>What are the Students and Marks respectively?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Column and table<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Index and Column<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Table and Primary key<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Table and Column<\/span><\/p>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">INSERT is a command in SQL with syntax<\/span><\/p>\n<p><span style=\"font-weight: 400;\">INSERT INTO <\/span><i><span style=\"font-weight: 400;\">table name<\/span><\/i><span style=\"font-weight: 400;\"> ( column 1, column 2, column 3, \u2026\u2026..) VALUES (Value 1, Value 2 , Value 3, \u2026\u2026\u2026..). Therefore, in the above-given query, Students is a table and Marks is a column of the Students table.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as according to the syntax for INSERT, Students is the table and Marks is the column.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as Students is a table, not an index. INSERT command is never applied on the indexes.<\/span><br \/>\n<b>Option C is incorrect <\/b><span style=\"font-weight: 400;\">as in the given SQL query, Marks is a simple column as it is not explicitly defined as the primary key.<\/span><br \/>\n<b>Option D is CORRECT <\/b><span style=\"font-weight: 400;\">as according to the syntax of INSERT command, Students is the table and Marks is the column.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more, refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-relational-data\/2-introduction-to-sql\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-relational-data\/2-introduction-to-sql<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure-5\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q15 : There is a Student Management System with the following \u201cStudent\u201d table:<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Student_Name<\/strong><\/td>\n<td><strong>Registration_No<\/strong><\/td>\n<td><strong>Address<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Rahul<\/strong><\/td>\n<td><strong>10301<\/strong><\/td>\n<td><strong>Delhi<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Ram<\/strong><\/td>\n<td><strong>10302<\/strong><\/td>\n<td><strong>Agra<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Shyam<\/strong><\/td>\n<td><strong>10303<\/strong><\/td>\n<td><strong>Noida<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Now, there is a need to change the name of column \u201cRegistration_No\u201d to \u201cRoll_No\u201d. Which statement you would use?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>UPDATE<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>ALTER<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>CREATE<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>INSERT<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">For functions like changing the column name, size or datatype, the Alter command is used.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Syntax for ALTER:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">ALTER TABLE <\/span><i><span style=\"font-weight: 400;\">Tablename<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Rename Column <\/span><i><span style=\"font-weight: 400;\">OldColumnName<\/span><\/i><span style=\"font-weight: 400;\"> TO <\/span><i><span style=\"font-weight: 400;\">NewColumnName<\/span><\/i><\/p>\n<p><b>Option A is incorrect <\/b><span style=\"font-weight: 400;\">as UPDATE statement is used to modify the data; not the name of the column.<\/span><br \/>\n<b>Option B is CORRECT<\/b><span style=\"font-weight: 400;\"> as ALTER statement is used to change the structure of the table. As here we need to rename the column, the following statement can be used;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">ALTER TABLE Student<\/span><\/p>\n<p><span style=\"font-weight: 400;\">RENAME COLUMN Registration_No TO Roll_no ;<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\"> as the CREATE statement is used to create the table, not to rename the column.<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\"> as INSERT is used to insert the data into the table.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more, refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-relational-data\/2-introduction-to-sql\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/query-relational-data\/2-introduction-to-sql<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_relational_data_on_Azure-6\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q16 : Which of the following Azure tools describes the service(s) to be deployed in JSON (JavaScript Object Notation) format?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Azure Portal<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Azure command-line interface (CLI)<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Azure Powershell<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Azure Resource Manager templates<\/span><\/p>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">An Azure Resource Manager template describes the service(s) to be deployed in a text file, in\u00a0 JSON\u00a0 format. The below is an example template that can be utilized to provision an instance of Azure SQL Database.<img decoding=\"async\" class=\"aligncenter wp-image-81716 size-full\" title=\"Azure Resource Manager template\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp16.png\" alt=\"Azure Resource Manager template\" width=\"453\" height=\"354\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp16.png 453w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp16-300x234.png 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">\u00a0The Azure portal shows the sequence of service-specific pages that prompt you for the settings needed and confirms these settings before the service is actually provisioned.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> CLI offers a set of commands that can be run from the operating system (OS) command prompt or the Cloud Shell in the Azure portal. These commands can be used for creating and managing the Azure resources.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure PowerShell provides a set of commands that can be used for scripting and automating the administrative tasks. Azure offers a series of commandlets, that are Azure-specific commands,\u00a0 that can be utilized in PowerShell for creating and managing the Azure resources.<\/span><br \/>\n<b>Option D is CORRECT.<\/b><span style=\"font-weight: 400;\"> An Azure Resource Manager template describes the service(s) to be deployed in a text file, in\u00a0 JSON\u00a0 format.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the relation data services, refer to the documentation below from Azure: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-provision-deploy-relational-database-offerings-azure\/2-describe-provision-relational-data-services\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-provision-deploy-relational-database-offerings-azure\/2-describe-provision-relational-data-services<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure-5\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q17 : Which of the following API of Azure Cosmo Database provides a graph-based view on database?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>MongoDB API<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Cassandra AP<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Gremlin<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Table API<\/span><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Cosmo DB supports 5 APIs: Core (SQL) API, MongoDB API, Cassandra API, Table API, and Gremlin API.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Core (SQL) API is the default API that provides a view of that data that resembles a traditional NoSQL document store. SQL like language is used to query the hierarchical JSON documents with a SQL-like language.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">MongoDB is a document database that has its own programmatic interface. Therefore, the data structure associated with MangoDB is JSON documents. Cassandra is a column family database management system that supports querying data through Cassandra Query Language (CQL).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Gremlin provides a graph-based view of the database. It means that the data is either a vertex (an individual item in the database), or an edge (a relationship between the database items).<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> MongoDB is a document database that has its own programmatic interface. Therefore, data structures associated with MangoDB are JSON documents.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Cassandra is a column family database management system that supports querying data through Cassandra Query Language (CQL).<\/span><br \/>\n<b>Option C is CORRECT. <\/b><span style=\"font-weight: 400;\">Gremlin provides a graph-based view of the database. It means that the data is either a vertex (an individual item in the database), or an edge (a relationship between the database items ).<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Table API allows using the Azure Table Storage API to store and retrieve the documents. The associated data structure with Table API is key-value.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the API for Azure Cosmos Database, please refer to the Azure documentation: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/choose-api-for-cosmos-db\/2-identify-the-technology-options\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/choose-api-for-cosmos-db\/2-identify-the-technology-options<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-4\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q18 : Consider the statements below:<\/strong><br \/>\n<strong>S1: Bring data into Power BI Desktop, and create a report<\/strong><br \/>\n<strong>S2: Publish to the Power BI service, where you can create new visualizations or build dashboards<\/strong><br \/>\n<strong>S3: Share dashboards with others, especially people who are on the go<\/strong><br \/>\n<strong>S4: View and interact with shared dashboards and reports in Power BI Mobile apps.<\/strong><br \/>\n<strong>Which of the following sequences of the above statements represents the common flow of activities in Power BI?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>S1-S2-S4-S3<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>S2-S1-S3-S4<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>S1-S2-S3-S4<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>S2-S3-S1-S4<\/span><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The activities and analyses in Power BI generally follow a common flow as given below:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Bring data into Power BI Desktop, and create a report.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Publish to the Power BI service, where you can create new visualizations or build dashboards.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Share dashboards with others, especially people who are on the go.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">View and interact with shared dashboards and reports in Power BI Mobile apps.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">So, the sequence S1-S2-S3-S4 is the right sequence.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as in normal flow, Share dashboards with others, especially people who are on the go comes before View and interact with shared dashboards and reports in Power BI Mobile apps.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as it is Bring data into Power BI Desktop, and create a report, not Publish to the Power BI service, where you can create new visualizations or build dashboards, that is the first activity in the normal flow.<\/span><br \/>\n<b>Option C is correct<\/b><span style=\"font-weight: 400;\">. Bring data into Power BI Desktop, and create a report, Publish to the Power BI service, where you can create new visualizations or build dashboards, Share dashboards with others, especially people who are on the go, and finally\u00a0 View and interact with shared dashboards and reports in Power BI Mobile apps is the common flow in Power BI.<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\"> as Bring data into Power BI Desktop, and create a report is the first activity in the normal flow. The right sequence of common flow is &#8211; Bring data into Power BI Desktop, and create a report, Publish to the Power BI service, where you can create new visualizations or build dashboards, Share dashboards with others, especially people who are on the go and finally\u00a0 View and interact with shared dashboards and reports in Power BI Mobile apps is the common flow in Power BI.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about Power BI, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-started-with-power-bi\/2-using-power-bi\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-started-with-power-bi\/2-using-power-bi<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-5\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q19 : You have retrieved data formatted in a different format from multiple sources. Now, you need to transform the data into a single uniform format. Which of the following data services would you use?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Azure Data Factory<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Azure Data Lake Storage<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Azure Databricks<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>None of These<\/span><\/p>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure Data Factory is a <\/span><i><span style=\"font-weight: 400;\">data integration service<\/span><\/i><span style=\"font-weight: 400;\"> that allows users to retrieve data from one or multiple data sources, and convert it into the desired format. The various data sources might have different data representation and have <\/span><i><span style=\"font-weight: 400;\">a noise<\/span><\/i><span style=\"font-weight: 400;\"> that needs to be filtered out. Azure Data Factory allows to extract only the interesting\/required data, and discard the rest.\u00a0 Even if the interesting data is not presented in the required format for processing by other services, it can be transformed into the desired format.<img decoding=\"async\" class=\"aligncenter wp-image-81717 size-full\" title=\"Microsoft Azure Data Factory\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19.png\" alt=\"Microsoft Azure Data Factory\" width=\"1600\" height=\"978\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19.png 1600w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-300x183.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-1024x626.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-768x469.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-1536x939.png 1536w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-687x420.png 687w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-640x391.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp19-681x416.png 681w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> Azure Data Factory allows transforming the data from multiple sources in the desired uniform format.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure Data Lake Storage is a secure cloud platform that offers cost-effective and scalable storage for big data analytics. In an Azure Data Services data warehouse solution, data is generally loaded into Azure Data Lake Storage before it is processed into a structure that supports efficient analysis in Azure Synapse Analytics.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure Databricks is an Apache Spark environment that runs on Azure to offer big data processing, streaming, and machine learning.\u00a0<\/span><br \/>\n<b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Azure Data Factory allows users to transform the data from multiple sources in the desired uniform format.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: To know more about Azure Data Factory, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/examine-components-of-modern-data-warehouse\/3-explore-azure-data-services-warehousing\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/examine-components-of-modern-data-warehouse\/3-explore-azure-data-services-warehousing<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-6\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q20 : Select the right sequence for implementing the Extract, Load, and Transform (ELT) process.<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Extract the source data into text files, Prepare the data for loading, Load the data into staging tables with PolyBase or the COPY command, Land the data into Azure Blob storage or Azure Data Lake Store, Transform the data, Insert the data into production tables<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Extract the source data into text files, Land the data into Azure Data Lake Store or Azure Blob storage, Prepare the data for loading, Load the data into staging tables with PolyBase or the COPY command, Transform the data, Insert the data into production tables<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Extract the source data into text files, Land the data into Azure Blob storage or Azure Data Lake Store, Prepare the data for loading, Load the data into staging tables with PolyBase or the COPY command, Insert the data into production tables, Transform the data<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Extract the source data into text files, Prepare the data for loading, Load the data into staging tables with PolyBase or the COPY command, Land the data into Azure Blob storage or Azure Data Lake Store, Insert the data into production tables, Transform the data<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">ELT is a process that extracts the data from a source system, loads it into a SQL pool, and then transforms it.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The basic steps for implementing the Extract, Load, and Transform (ELT) process are:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Extract the source data into text files.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Land the data into Azure Data Lake Store or Azure Blob storage.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Prepare the data for loading.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Load the data into staging tables through PolyBase or the COPY command.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Transform the data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Insert the data into the production tables.<\/span><\/li>\n<\/ol>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the implementation of the Extract, Load, and Transform (ELT) process, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/design-elt-data-loading\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/design-elt-data-loading<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_an_analytics_workload_on_Azure-7\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe an analytics workload on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q21 : In Data Lake Analytics, which of the following languages is used to define a job that contains queries to transform data and extract insights?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>SQL<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>C#<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>U-SQL<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>PL\/SQL<\/span><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Data Lake Analytics provides a framework and collection of tools that is used to analyze data stored in Microsoft Azure Data Lake Store and other repositories. You write the jobs consisting of queries to transform the data and get insights. The language that is used to write these jobs is known as \u201cU-SQL\u201d. U-SQL is a hybrid language that has the features of both languages SQL and C#, and offers the procedural and declarative capabilities that can be used for data processing.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> It is U-SQL, not SQL, that is used to define the mentioned jobs in data lake analytics.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. It is U-SQL, not #C, that is used to define the mentioned jobs in data lake analytics.<\/span><br \/>\n<b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> U-SQL is the language that is used to define a job that contains queries to transform data and extract insights into data lake analytics.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> It is U-SQL, not PL\/SQL, that is used to define the mentioned jobs in data lake analytics.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-data-storage-processing-azure\/2-describe-azure\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-data-storage-processing-azure\/2-describe-azure<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts-4\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q22 : Which of the following are the characteristics of a relational database?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>All data needs to be stored as integers<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>The rows in a table consist of one or more columns that represent the properties of the entity<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>The different rows in the same table might have different columns<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>A tuple in a relation represents a single entity<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>A relational database has a flexible schema<\/span><\/p>\n<p><b>Correct Answers: B and D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">In a relational database, the entities are modeled as the tables. Entities are the things for which the information needs to be stored or known. For example, in an organization, you might be interested in storing the information regarding employees, department and project, etc. All these employees, departments and projects are known as entity types, and tables are created for those. Each row in a table represents one instance of that entity type. For example, in the EMPLOYEE table, each row represents the details of one employee.\u00a0 Below is a snapshot of the database with table EMPLOYEE, DEPARTMENT, and PROJECT.<img decoding=\"async\" class=\"aligncenter wp-image-81718 size-full\" title=\"Relational Database Azure (Employee)\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.1.png\" alt=\"Relational Database Azure\" width=\"639\" height=\"136\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.1.png 639w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.1-300x64.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/> <img decoding=\"async\" class=\"aligncenter wp-image-81719 size-full\" title=\"Relational Database Azure (Employee)\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.2.png\" alt=\"Relational Database Azure\" width=\"338\" height=\"139\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.2.png 338w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.2-300x123.png 300w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/> <img decoding=\"async\" class=\"aligncenter wp-image-81720 size-full\" title=\"Relational Database Azure (Employee)\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.3.png\" alt=\"Relational Database Azure\" width=\"318\" height=\"125\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.3.png 318w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/dp22.3-300x118.png 300w\" sizes=\"(max-width: 318px) 100vw, 318px\" \/><\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> All the data don&#8217;t need to be stored as integers. Data can be stored as any data type integer, real number, string, Date, etc.<\/span><br \/>\n<b>Option B is correct. <\/b><span style=\"font-weight: 400;\">In a relational database, the rows in a table consist of one or more columns that represent the properties of the entity.<\/span><br \/>\n<b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">\u00a0In a table, all the rows need to have the same columns although the values for different rows might be the same or different depending upon the attribute.<\/span><br \/>\n<b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> A Row or Tuple in a table represents the one instance or entity of a particular entity type.<\/span><br \/>\n<b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> Schemaless design in the property of the non-relational database, not the relational database.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the characteristics of a Relational Database, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/describe-concepts-of-relational-data\/2-explore-characteristics\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/describe-concepts-of-relational-data\/2-explore-characteristics<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts-5\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q23 : \u2026\u2026\u2026\u2026\u2026..\u00a0 is the process of transforming and mapping the raw data into a more useful format for analysis?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Data Cleaning<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Data Ingestion<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Wrangling<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Data Analysis<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>E. <\/strong>Data Modeling<\/span><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Wrangling is the process of transforming and mapping raw data into a more useful format for analysis. It might include writing code for capturing, filtering, cleaning, combining, and aggregating data from multiple sources.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Data cleaning is a generalized term that comprises a wide range of actions like removing or deleting anomalies and applying filters and transformations that would be too time-taking to run during the ingestion phase.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Data ingestion is the process that obtains and imports the data for immediate use or storage in a database.<\/span><br \/>\n<b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Wrangling is the process of transforming and mapping raw data into a more useful format for analysis.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Data analysis is the process of inspecting, cleansing, transforming, and modeling data to get useful information, supporting decision-making, and informing conclusions.<\/span><br \/>\n<b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> Data modeling is a process of creating a conceptual representation of the data objects, in association with other data objects, and the rules between them.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about wrangling, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-concepts-of-data-analytics\/2-describe-data-ingestion-process\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-concepts-of-data-analytics\/2-describe-data-ingestion-process<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_core_data_concepts-6\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe core data concepts<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q24 : Which of the following are the roles and responsibilities of a database administrator?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>To install and upgrade the database server and application tools<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>To enroll the users and maintain system security<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>To develop, construct, test, and maintain the databases and data structures<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>To monitor and optimize the performance of the database<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>E. <\/strong>To Prepare the data for prescriptive and predictive modeling<\/span><\/p>\n<p><b>Correct Answers: A, B and D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Database Administrator is tasked to manage and organize the databases. The main job of a database administrator is to ensure that data is available and protected from loss, theft, and corruption and is easily accessible whenever needed. The following figure shows the common roles and responsibilities of a database administrator:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To install and upgrade the database server and application tools.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To allocate system storage and plan storage needs for the database system.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To modify the database structure, as necessary, from information provided by application developers.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To enroll the users and maintain system security.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To ensure compliance with the database vendor license agreement.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To control and monitor user access to the database.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To monitor and optimize the performance of the database.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To do Planning for backup and recovery of database information.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To maintain archived data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To ensure Backing up and restoring databases.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To contact database vendors for technical support.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To generate various reports from the database using appropriate queries as per needs.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To manage and monitor data replication.<\/span><\/li>\n<\/ul>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. To install and upgrade the database server and application tools is one of the common roles and responsibilities of a database administrator.<\/span><br \/>\n<b>Option B is correct<\/b><span style=\"font-weight: 400;\">. To enroll the users and maintain system security is one of the common roles and responsibilities of a database administrator.<\/span><br \/>\n<b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> To develop, construct, test, and maintain the databases and data structures is the responsibility of the data engineer, not the data administrator.<\/span><br \/>\n<b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> To monitor and optimize the performance of the database is one of the common roles and responsibilities of a database administrator.<\/span><br \/>\n<b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> To Prepare the data for prescriptive and predictive modeling is the responsibility of the data engineer, not the data administrator<\/span><\/p>\n<p><b>References: <\/b><span style=\"font-weight: 400;\">To know more about the roles and responsibilities of a Data Administrator, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/3-review-tasks-tools-for-database-administration\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/3-review-tasks-tools-for-database-administration<\/span><\/a>,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/4-review-tasks-tools-for-data-engineering\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/4-review-tasks-tools-for-data-engineering<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Describe_how_to_work_with_non-relational_data_on_Azure-6\"><\/span><span style=\"font-weight: 400;\">Domain : <\/span><span style=\"font-weight: 400;\">Describe how to work with non-relational data on Azure<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Q25 : Which of the following statements is false about Azure Cosmos DB?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>It supports providing or restricting access to the Cosmos account, database, container, and offers (throughput) using Access control (IAM) in the Azure portal<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B<\/strong>. It supports monitoring the account for normal and abnormal activities<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>All connections to Azure Cosmos DB support HTTPS<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>The data once deleted can\u2019t be recovered in any way<\/span><\/p>\n<p><b>Correct Answer: D<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Azure Cosmos DB secures the database through<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Network security and firewall settings<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">User authentication and fine-grained user controls<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Replicating data globally for regional failures<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ability to failover from one data center to another<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Local data replication within a data center<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Automatic data backups<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">restoring the deleted data from backups<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">isolating and protecting the sensitive data<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Responding to attacks<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Monitoring for attacks<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Geo-fencing data to adhere to data governance restrictions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Physical protection of servers in protected data centers<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Certifications<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> In Azure Cosmos DB, you can provide or restrict access to the Cosmos account, container, database, and offers (throughput) through Access control (IAM) in the Azure portal. IAM offers role-based access control and integrates with Active Directory. You can utilize built-in or even the custom roles for groups as well as individuals.<\/span><br \/>\n<b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Azure Cosmos DB allows monitoring the account for normal and abnormal activities using <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/monitor-cosmos-db\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">audit logging and activity logs<\/span><\/a><span style=\"font-weight: 400;\">. You can see what operations have been carried out on your resources, who started the operation, when the operation happened and the status of the operation, etc.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. In Azure Cosmos DB, all connections to Azure Cosmos DB support HTTPS.<\/span><br \/>\n<b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> It is false that the data once deleted can\u2019t be recovered in Azure Cosmos DB. It supports recovering data you might have accidentally deleted up to ~30 days after the event through automated online backups.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about Azure Cosmos DB, please refer to the Azure documentation below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/database-security\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/database-security<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Hope you found these exam questions on the DP-900 certification useful and were quick to answer. If you spend more time on your learning, then you can face the exam with full confidence. For more such practice test questions, refer to our <a href=\"http:\/\/www.whizlabs.com\">Whizlabs official webpage<\/a><\/span><span style=\"font-weight: 400;\">, and move closer towards passing the DP-900 certification in the first attempt.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The DP-900: Microsoft Azure Data Fundamentals certification is for you, if you are new to Cloud and just getting started with it. You must also be aware of the relational and non-relational data concepts, and various kinds of data workloads such as analytical and transactional. These free DP-900 Exam Questions and Answers provide you with an overview of the Microsoft Azure Data Fundamentals certification, and introduce you to the various objectives and concepts of the DP-900 exam. Domain : Describe an analytics workload on Azure Q1 : What is the role of a pipeline in a data factory in the [&hellip;]<\/p>\n","protected":false},"author":359,"featured_media":81837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[4851],"class_list":["post-81710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-azure","tag-dp-900-certification"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam-150x150.png",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam-300x158.png",300,158,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",24,13,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",48,25,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",96,50,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",150,79,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",300,158,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam-250x250.png",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",600,315,false],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",96,50,false],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/03\/Free-Questions-on-DP-900-Microsoft-Azure-Data-Fundamentals-Certification-Exam.png",150,79,false]},"uagb_author_info":{"display_name":"Abilesh Premkumar","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/abilesh\/"},"uagb_comment_info":56,"uagb_excerpt":"The DP-900: Microsoft Azure Data Fundamentals certification is for you, if you are new to Cloud and just getting started with it. You must also be aware of the relational and non-relational data concepts, and various kinds of data workloads such as analytical and transactional. These free DP-900 Exam Questions and Answers provide you with&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/359"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=81710"}],"version-history":[{"count":22,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81710\/revisions"}],"predecessor-version":[{"id":88940,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81710\/revisions\/88940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/81837"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=81710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=81710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=81710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}