{"id":17124,"date":"2026-09-21T06:36:09","date_gmt":"2026-09-21T06:36:09","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=17124"},"modified":"2026-09-21T06:36:09","modified_gmt":"2026-09-21T06:36:09","slug":"microsoft-dp-900-practice-test-questions-and-exam-dumps-part9-q161-180","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/microsoft-dp-900-practice-test-questions-and-exam-dumps-part9-q161-180\/","title":{"rendered":"Microsoft DP-900 Practice Test Questions and Exam Dumps Part9 Q161-180"},"content":{"rendered":"

View Full <\/b>Microsoft DP-900 Exam Dumps<\/b><\/a> and Practice Test Dumps.<\/b><\/h2>\n

 <\/p>\n

Question 161<\/b><\/h3>\n

Which Azure service is designed to store large amounts of unstructured object data?<\/b><\/p>\n

    \n
  1. Azure SQL Database<\/span><\/li>\n
  2. Azure Blob Storage<\/span><\/li>\n
  3. Azure Table Storage<\/span><\/li>\n
  4. Azure Queue Storage<\/span><\/li>\n<\/ol>\n

    Correct Answer: 2<\/b><\/p>\n

    Explanation<\/b><\/p>\n

    Azure Blob Storage is an object storage service designed for large amounts of unstructured data. Common examples include images, videos, documents, backups, log files, and other media. Data is stored as blobs within containers, allowing applications to access individual objects as needed. Blob Storage can scale to support very large quantities of data and provides different access tiers for different usage patterns. Azure SQL Database is designed for relational data, Table Storage provides NoSQL entities, and Queue Storage is intended for messages. Blob Storage is therefore appropriate for object-based unstructured data.<\/span><\/p>\n

    Question 162<\/b><\/h3>\n

    Which SQL statement is used to retrieve data from a relational database?<\/b><\/p>\n

      \n
    1. INSERT<\/span><\/li>\n
    2. DELETE<\/span><\/li>\n
    3. SELECT<\/span><\/li>\n
    4. UPDATE<\/span><\/li>\n<\/ol>\n

      Correct Answer: 3<\/b><\/p>\n

      Explanation<\/b><\/p>\n

      The SELECT statement is used to retrieve data from relational database tables. It can return selected columns, filter records using conditions, sort results, group data, and combine information from multiple tables through joins. For example, a SELECT query can retrieve customers who placed orders during a particular month. INSERT adds new records, UPDATE modifies existing records, and DELETE removes records. SELECT is fundamental to both application development and analytical querying because applications and users frequently need to read information from relational databases.<\/span><\/p>\n

      Question 163<\/b><\/h3>\n

      Which database model stores information using documents that can contain nested fields and arrays?<\/b><\/p>\n

        \n
      1. Document<\/span><\/li>\n
      2. Graph<\/span><\/li>\n
      3. Key-value<\/span><\/li>\n
      4. Relational<\/span><\/li>\n<\/ol>\n

        Correct Answer: 1<\/b><\/p>\n

        Explanation<\/b><\/p>\n

        A document database stores data as individual documents, commonly using JSON-like structures. A document can contain fields, nested objects, arrays, and other values. This model provides flexibility because different documents can contain different attributes when the application requires it. Document databases are commonly used for web applications, content systems, product catalogs, and other workloads where data structures may evolve over time. Relational databases use tables, graph databases focus on relationships, and key-value databases store pairs of keys and values. The document model is especially useful for flexible application data.<\/span><\/p>\n

        Question 164<\/b><\/h3>\n

        Which Azure service is primarily designed for data integration and pipeline orchestration?<\/b><\/p>\n

          \n
        1. Azure Cosmos DB<\/span><\/li>\n
        2. Azure Data Factory<\/span><\/li>\n
        3. Azure Files<\/span><\/li>\n
        4. Azure Queue Storage<\/span><\/li>\n<\/ol>\n

          Correct Answer: 2<\/b><\/p>\n

          Explanation<\/b><\/p>\n

          Azure Data Factory is a cloud-based data integration service that allows organizations to create and manage data pipelines. These pipelines can copy data between different sources and destinations and coordinate transformation or processing activities. Data Factory can connect to databases, files, cloud services, and analytical platforms. It is commonly used in ETL and ELT solutions. Azure Cosmos DB is a NoSQL database, Azure Files provides file shares, and Queue Storage is designed for asynchronous messaging. Data Factory is therefore the appropriate choice when the main requirement is data movement and workflow orchestration.<\/span><\/p>\n

          Question 165<\/b><\/h3>\n

          Which ACID property ensures that committed changes remain saved even after a system failure?<\/b><\/p>\n

            \n
          1. Isolation<\/span><\/li>\n
          2. Consistency<\/span><\/li>\n
          3. Atomicity<\/span><\/li>\n
          4. Durability<\/span><\/li>\n<\/ol>\n

            Correct Answer: 4<\/b><\/p>\n

            Explanation<\/b><\/p>\n

            Durability is the ACID property that ensures committed transaction changes persist even if a system failure occurs afterward. Once a transaction has successfully committed, the database system is responsible for preserving those changes. Atomicity means a transaction succeeds or fails as a complete unit. Consistency ensures the database remains valid according to its rules, while isolation controls how concurrent transactions interact. Durability is particularly important for business systems such as banking, order processing, and inventory management because users expect completed transactions to remain recorded after successful confirmation.<\/span><\/p>\n

            Question 166<\/b><\/h3>\n

            Which Azure service provides a managed relational database based on the PostgreSQL engine?<\/b><\/p>\n

              \n
            1. Azure Database for PostgreSQL<\/span><\/li>\n
            2. Azure Blob Storage<\/span><\/li>\n
            3. Azure Cosmos DB<\/span><\/li>\n
            4. Azure Queue Storage<\/span><\/li>\n<\/ol>\n

              Correct Answer: 1<\/b><\/p>\n

              Explanation<\/b><\/p>\n

              Azure Database for PostgreSQL is a managed relational database service based on PostgreSQL. It allows organizations to deploy PostgreSQL databases in Azure while Microsoft manages much of the underlying infrastructure. Applications can use familiar PostgreSQL functionality, including relational tables, SQL queries, indexes, relationships, and transactions. This service is useful for applications already developed with PostgreSQL or workloads requiring its database engine. Azure Cosmos DB is a NoSQL service, Blob Storage is object storage, and Queue Storage is designed for messaging. PostgreSQL workloads can therefore be hosted using this managed Azure database service.<\/span><\/p>\n

              Question 167<\/b><\/h3>\n

              Which database structure is used to uniquely identify each record in a relational table?<\/b><\/p>\n

                \n
              1. View<\/span><\/li>\n
              2. Index<\/span><\/li>\n
              3. Primary key<\/span><\/li>\n
              4. Foreign key<\/span><\/li>\n<\/ol>\n

                Correct Answer: 3<\/b><\/p>\n

                Explanation<\/b><\/p>\n

                A primary key uniquely identifies each record in a relational table. Each row should have a unique primary key value so applications and database systems can distinguish one record from another. For example, an EmployeeID column can serve as the primary key in an Employees table. Foreign keys establish relationships between tables, indexes improve data retrieval performance, and views provide virtual representations of data. Primary keys are fundamental to relational database design because they help maintain data integrity and provide a reliable identifier that can also be referenced by related tables.<\/span><\/p>\n

                Question 168<\/b><\/h3>\n

                Which type of processing handles data continuously as events arrive?<\/b><\/p>\n

                  \n
                1. Batch processing<\/span><\/li>\n
                2. Stream processing<\/span><\/li>\n
                3. Scheduled reporting<\/span><\/li>\n
                4. Offline processing<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 2<\/b><\/p>\n

                  Explanation<\/b><\/p>\n

                  Stream processing handles data continuously as events or records arrive. It is useful when applications need to analyze or react to information with low latency. Examples include processing IoT telemetry, monitoring application events, detecting suspicious transactions, and generating real-time dashboards. Batch processing is different because it collects data and processes it together at scheduled intervals. Stream processing can provide faster responses but may require architectures designed specifically for continuous event handling. The appropriate approach depends on business requirements, including how quickly results need to be available.<\/span><\/p>\n

                  Question 169<\/b><\/h3>\n

                  Which Azure service provides a NoSQL database designed for globally distributed applications?<\/b><\/p>\n

                    \n
                  1. Azure SQL Database<\/span><\/li>\n
                  2. Azure Data Factory<\/span><\/li>\n
                  3. Azure Cosmos DB<\/span><\/li>\n
                  4. Azure Synapse Analytics<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 3<\/b><\/p>\n

                    Explanation<\/b><\/p>\n

                    Azure Cosmos DB is a fully managed NoSQL database service designed for scalable and globally distributed applications. It can distribute data across Azure regions and provide low-latency access to users in different geographic locations. Cosmos DB supports multiple APIs and flexible data models, making it suitable for a variety of modern application scenarios. Examples include IoT applications, recommendation systems, web applications, and globally available services. Azure SQL Database is relational, Data Factory is used for integration, and Synapse is focused primarily on analytics. Cosmos DB is specifically designed for distributed NoSQL workloads.<\/span><\/p>\n

                    Question 170<\/b><\/h3>\n

                    Which SQL statement is used to add a new row to a table?<\/b><\/p>\n

                      \n
                    1. INSERT<\/span><\/li>\n
                    2. UPDATE<\/span><\/li>\n
                    3. SELECT<\/span><\/li>\n
                    4. DELETE<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 1<\/b><\/p>\n

                      Explanation<\/b><\/p>\n

                      The INSERT statement adds new rows to a relational database table. An INSERT operation specifies the target table and the values that should be stored in its columns. For example, an application can use INSERT to create a new customer record after a user registers. SELECT retrieves existing information, UPDATE modifies existing rows, and DELETE removes rows. INSERT is frequently used in transactional applications because new business events often require new records to be stored. Understanding the basic SQL data manipulation statements is important for working with relational databases.<\/span><\/p>\n

                      Question 171<\/b><\/h3>\n

                      Which Azure service provides shared file storage accessible through standard file-sharing protocols?<\/b><\/p>\n

                        \n
                      1. Azure Table Storage<\/span><\/li>\n
                      2. Azure Files<\/span><\/li>\n
                      3. Azure Blob Storage<\/span><\/li>\n
                      4. Azure Queue Storage<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 2<\/b><\/p>\n

                        Explanation<\/b><\/p>\n

                        Azure Files provides fully managed cloud file shares that can be accessed using standard file-sharing protocols. It is useful for applications that require shared files or organizations that want to migrate traditional file-server workloads to Azure. Multiple systems can access the same file share according to configured permissions. Blob Storage is optimized for objects, Table Storage is a NoSQL entity store, and Queue Storage provides message storage. Azure Files is therefore appropriate when an application needs a shared file system rather than object storage, relational data, or asynchronous messaging.<\/span><\/p>\n

                        Question 172<\/b><\/h3>\n

                        Which Azure service is designed for enterprise-scale analytical workloads and data warehousing?<\/b><\/p>\n

                          \n
                        1. Azure Queue Storage<\/span><\/li>\n
                        2. Azure Files<\/span><\/li>\n
                        3. Azure Cosmos DB<\/span><\/li>\n
                        4. Azure Synapse Analytics<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 4<\/b><\/p>\n

                          Explanation<\/b><\/p>\n

                          Azure Synapse Analytics is designed to support large-scale analytics and data warehousing workloads. Organizations can use it to analyze large datasets, perform complex queries, and support reporting and business intelligence scenarios. Synapse can integrate with data from multiple sources and participate in broader analytical architectures. Analytical workloads commonly involve aggregations, historical analysis, and complex queries rather than frequent small operational transactions. Azure Files provides file storage, Queue Storage handles messages, and Cosmos DB provides NoSQL database capabilities. Synapse is therefore suited to large-scale analytical and data warehousing requirements.<\/span><\/p>\n

                          Question 173<\/b><\/h3>\n

                          Which type of data is typically represented by images, audio recordings, and video files?<\/b><\/p>\n

                            \n
                          1. Structured data<\/span><\/li>\n
                          2. Semi-structured data<\/span><\/li>\n
                          3. Relational data<\/span><\/li>\n
                          4. Unstructured data<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 4<\/b><\/p>\n

                            Explanation<\/b><\/p>\n

                            Images, audio recordings, and video files are generally classified as unstructured data because they do not naturally follow a predefined table-based schema. Unstructured data can still contain metadata, but its primary content is not organized into fixed rows and columns. Other examples include documents and certain types of free-form text. Structured data follows a predefined schema, such as relational database tables, while semi-structured data includes formats such as JSON and XML. Understanding these categories helps organizations select appropriate storage and processing solutions, such as Blob Storage for large collections of media files.<\/span><\/p>\n

                            Question 174<\/b><\/h3>\n

                            Which database constraint is used to maintain a relationship between related tables?<\/b><\/p>\n

                              \n
                            1. Foreign key<\/span><\/li>\n
                            2. UNIQUE constraint<\/span><\/li>\n
                            3. CHECK constraint<\/span><\/li>\n
                            4. DEFAULT constraint<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 1<\/b><\/p>\n

                              Explanation<\/b><\/p>\n

                              A foreign key is used to establish a relationship between related tables in a relational database. It typically references a primary key in another table. For example, an Orders table can have a CustomerID foreign key that references the CustomerID primary key in a Customers table. This allows related data to be separated into multiple tables while maintaining a logical connection. Foreign keys can also help enforce referential integrity. UNIQUE constraints prevent duplicate values, CHECK constraints enforce conditions, and DEFAULT constraints provide values when none are specified.<\/span><\/p>\n

                              Question 175<\/b><\/h3>\n

                              Which Azure service is designed to store messages for asynchronous processing?<\/b><\/p>\n

                                \n
                              1. Azure SQL Database<\/span><\/li>\n
                              2. Azure Queue Storage<\/span><\/li>\n
                              3. Azure Blob Storage<\/span><\/li>\n
                              4. Azure Database for MySQL<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 2<\/b><\/p>\n

                                Explanation<\/b><\/p>\n

                                Azure Queue Storage provides cloud-based message storage for asynchronous application processing. A producer can add messages to a queue, and a consumer can retrieve them later. This helps decouple application components and allows background tasks to be processed independently. For example, an application can place document-processing requests into a queue while a worker processes them separately. Azure SQL Database and MySQL provide relational database capabilities, while Blob Storage is designed for object storage. Queue Storage is specifically suited to workloads where applications need to exchange messages asynchronously.<\/span><\/p>\n

                                Question 176<\/b><\/h3>\n

                                Which approach transforms data before loading it into the destination system?<\/b><\/p>\n

                                  \n
                                1. ELT<\/span><\/li>\n
                                2. ETL<\/span><\/li>\n
                                3. OLAP<\/span><\/li>\n
                                4. OLTP<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 2<\/b><\/p>\n

                                  Explanation<\/b><\/p>\n

                                  ETL stands for Extract, Transform, Load. Data is extracted from one or more sources, transformed into the required format, and then loaded into the destination system. Transformations can include cleaning data, removing duplicates, converting data types, standardizing values, and calculating new fields. ETL is commonly used when the target system expects data to be prepared before loading. ELT follows a different sequence in which data is loaded before transformations are performed. OLTP and OLAP describe workload types rather than data integration sequences. Understanding ETL is important for building data pipelines.<\/span><\/p>\n

                                  Question 177<\/b><\/h3>\n

                                  Which Azure service provides a managed MySQL relational database?<\/b><\/p>\n

                                    \n
                                  1. Azure Database for MySQL<\/span><\/li>\n
                                  2. Azure Cosmos DB<\/span><\/li>\n
                                  3. Azure Data Factory<\/span><\/li>\n
                                  4. Azure Blob Storage<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 1<\/b><\/p>\n

                                    Explanation<\/b><\/p>\n

                                    Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It enables applications to use MySQL in Azure while Microsoft manages much of the infrastructure and platform maintenance. The service supports standard relational concepts such as tables, SQL queries, indexes, relationships, and transactions. It is useful for applications that require MySQL compatibility without the need to manage physical database infrastructure. Cosmos DB provides NoSQL capabilities, Data Factory handles data integration, and Blob Storage provides object storage. MySQL workloads can therefore be hosted using this managed service.<\/span><\/p>\n

                                    Question 178<\/b><\/h3>\n

                                    Which database model is best suited for data where relationships between entities are central to the application?<\/b><\/p>\n

                                      \n
                                    1. Key-value<\/span><\/li>\n
                                    2. Document<\/span><\/li>\n
                                    3. Graph<\/span><\/li>\n
                                    4. Object storage<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 3<\/b><\/p>\n

                                      Explanation<\/b><\/p>\n

                                      A graph database is designed to represent entities and the relationships between them. It typically models entities as nodes and relationships as edges, making it efficient for traversing connected information. Common applications include social networking, recommendation engines, fraud detection, network management, and dependency analysis. A key-value model focuses on direct retrieval by keys, while document databases store flexible documents. Object storage is not a database model at all and is intended for storing files and objects. Graph databases are particularly useful when the relationships between entities are as important as the entities themselves.<\/span><\/p>\n

                                      Question 179<\/b><\/h3>\n

                                      Which ACID property helps ensure that simultaneous transactions do not improperly interfere with each other?<\/b><\/p>\n

                                        \n
                                      1. Durability<\/span><\/li>\n
                                      2. Consistency<\/span><\/li>\n
                                      3. Isolation<\/span><\/li>\n
                                      4. Atomicity<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 3<\/b><\/p>\n

                                        Explanation<\/b><\/p>\n

                                        Isolation controls how concurrent transactions interact with one another. It helps prevent one transaction from seeing inappropriate intermediate changes made by another transaction. Database systems can provide different isolation levels depending on the required balance between consistency and performance. Atomicity ensures that a transaction succeeds or fails as a unit, consistency ensures valid database states, and durability ensures committed changes survive failures. Isolation is particularly important in multi-user systems where many transactions may access and modify the same data at the same time.<\/span><\/p>\n

                                        Question 180<\/b><\/h3>\n

                                        Which statement best describes a data lake?<\/b><\/p>\n

                                          \n
                                        1. It stores only normalized relational tables<\/span><\/li>\n
                                        2. It is primarily used for sending application messages<\/span><\/li>\n
                                        3. It stores large amounts of data in various formats, often in raw form<\/span><\/li>\n
                                        4. It is exclusively a business reporting dashboard<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 3<\/b><\/p>\n

                                          Explanation<\/b><\/p>\n

                                          A data lake is designed to store large amounts of data in its original or raw form. It can contain structured, semi-structured, and unstructured information, including relational records, JSON files, logs, documents, images, and videos. This flexibility makes data lakes useful for analytics, data science, machine learning, and large-scale data processing. Unlike a traditional data warehouse, a data lake does not require all data to be transformed into a rigid schema before storage. Organizations can process and transform the data later according to specific analytical or business requirements.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                          View Full Microsoft DP-900 Exam Dumps and Practice Test Dumps.   Question 161 Which Azure service is designed to store large amounts of unstructured object data? Azure SQL Database Azure Blob Storage Azure Table Storage Azure Queue Storage Correct Answer: 2 Explanation Azure Blob Storage is an object storage service designed for large amounts of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/17124"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=17124"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/17124\/revisions"}],"predecessor-version":[{"id":17125,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/17124\/revisions\/17125"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=17124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=17124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=17124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}