View Full Microsoft DP-900 Exam Dumps and Practice Test Dumps.

 

Question 261

Which Azure service provides managed relational database capabilities using the MySQL engine?

1. Azure Database for MySQL
2. Azure Cosmos DB
3. Azure Blob Storage
4. Azure Event Hubs

Correct Answer: 1

Explanation

Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It allows organizations to run MySQL databases in Azure while Microsoft manages much of the underlying infrastructure. Applications can use familiar relational concepts such as tables, relationships, SQL queries, indexes, and transactions. This service is useful for applications that already use MySQL or require MySQL compatibility. Azure Cosmos DB is a NoSQL service, Blob Storage provides object storage, and Event Hubs handles event ingestion. Therefore, Azure Database for MySQL is the appropriate choice for managed MySQL workloads.

Question 262

Which type of database is optimized for storing relationships between entities such as people and connections?

1. Key-value database
2. Graph database
3. Document database
4. Columnar database

Correct Answer: 2

Explanation

A graph database is specifically designed to represent entities and the relationships between them. Entities are commonly represented as nodes, while relationships are represented as edges. This makes graph databases useful for scenarios such as social networks, recommendation systems, fraud detection, network analysis, and relationship-based searches. Key-value databases focus on pairs of keys and values, while document databases store information as documents. Graph databases are particularly useful when applications need to efficiently traverse and analyze connections between entities rather than simply retrieve individual records.

Question 263

Which SQL clause is used to sort query results?

1. WHERE
2. GROUP BY
3. ORDER BY
4. HAVING

Correct Answer: 3

Explanation

The ORDER BY clause is used to sort the results returned by a SQL query. It can sort data in ascending or descending order based on one or more columns. For example, a query can use ORDER BY to display customers alphabetically or products from highest to lowest price. WHERE filters rows, GROUP BY groups rows for aggregation, and HAVING filters grouped results. ORDER BY is therefore the appropriate SQL clause when the requirement is to control the order in which query results are presented.

Question 264

Which Azure service is designed to store files that can be accessed through a shared file system?

1. Azure Files
2. Azure Blob Storage
3. Azure Queue Storage
4. Azure Cosmos DB

Correct Answer: 1

Explanation

Azure Files provides managed cloud file shares that can be accessed by multiple applications and machines. It is designed for scenarios where workloads require a traditional shared file-system experience. Organizations can use Azure Files for application files, configuration files, shared documents, and migration from on-premises file servers. Blob Storage is designed for object storage, Queue Storage is designed for asynchronous messaging, and Cosmos DB provides NoSQL database capabilities. Azure Files is therefore the appropriate service when applications need shared file storage in Azure.

Question 265

Which ACID property ensures that database transactions maintain valid rules and constraints?

1. Isolation
2. Consistency
3. Atomicity
4. Durability

Correct Answer: 2

Explanation

Consistency is the ACID property that ensures a transaction moves the database from one valid state to another valid state. Database rules, constraints, and relationships should remain valid after the transaction completes. For example, if a database requires a foreign key to reference an existing record, a transaction should not leave an invalid relationship. Atomicity ensures that a transaction is completed fully or not applied, isolation controls concurrent transactions, and durability preserves committed changes. Consistency is therefore essential for maintaining the correctness and integrity of relational database information.

Question 266

Which Azure service provides a managed NoSQL database with support for globally distributed applications?

1. Azure SQL Database
2. Azure Cosmos DB
3. Azure Data Factory
4. Azure Files

Correct Answer: 2

Explanation

Azure Cosmos DB is a managed NoSQL database service designed for scalable and globally distributed applications. It supports flexible data models and can distribute data across multiple Azure regions. This makes it suitable for applications that need low-latency access to data from different geographic locations. Cosmos DB can be used for web applications, IoT solutions, personalization systems, and many other modern workloads. Azure SQL Database is relational, Data Factory is a data integration service, and Azure Files provides shared file storage. Cosmos DB is therefore the appropriate choice for globally distributed NoSQL workloads.

Question 267

Which SQL command is used to create a new table?

1. INSERT TABLE
2. NEW TABLE
3. CREATE TABLE
4. ADD TABLE

Correct Answer: 3

Explanation

CREATE TABLE is the SQL statement used to create a new relational database table. The statement defines the table name and specifies columns, data types, and optional constraints such as primary keys. For example, a database administrator can use CREATE TABLE to define a Customers table with CustomerID, Name, and Email columns. INSERT is used to add records after the table exists, UPDATE modifies existing records, and SELECT retrieves data. CREATE TABLE is therefore part of SQL Data Definition Language and is used to define the structure of a new table.

Question 268

Which Azure service is used to orchestrate data movement and transformation workflows?

1. Azure Data Factory
2. Azure Queue Storage
3. Azure Cosmos DB
4. Azure Table Storage

Correct Answer: 1

Explanation

Azure Data Factory is a cloud-based data integration service used to create and manage data pipelines. It can orchestrate data movement between different sources and destinations and coordinate transformation activities. For example, an organization can create a pipeline that extracts information from a database, loads it into cloud storage, and triggers additional processing. Data Factory is useful for ETL and ELT workflows and supports many different data sources. Queue Storage provides messaging, Cosmos DB provides NoSQL database capabilities, and Table Storage provides NoSQL entity storage.

Question 269

Which type of data usually follows a predefined schema with rows and columns?

1. Unstructured data
2. Semi-structured data
3. Structured data
4. Binary data

Correct Answer: 3

Explanation

Structured data follows a predefined schema and is commonly organized into rows and columns. Relational databases are a major example because tables define columns, data types, and relationships. Structured data is generally easier to query using SQL because its organization is known in advance. Semi-structured data such as JSON contains organizational elements but does not require a rigid table structure. Unstructured data includes files such as videos, images, and many documents. Therefore, structured data is the category most closely associated with traditional relational database tables.

Question 270

Which Azure service provides object storage for unstructured data such as backups and media files?

1. Azure Queue Storage
2. Azure Blob Storage
3. Azure Files
4. Azure SQL Database

Correct Answer: 2

Explanation

Azure Blob Storage is Azure’s object storage service for large amounts of unstructured data. It can store objects such as videos, images, documents, backups, logs, and application files. Blob Storage is highly scalable and can be used by applications, analytics solutions, and backup systems. Azure Queue Storage is intended for asynchronous messages, Azure Files provides shared file storage, and Azure SQL Database provides relational database functionality. When an application needs durable and scalable object storage rather than a relational table or message queue, Azure Blob Storage is the appropriate service.

Question 271

Which workload is typically associated with point-of-sale transactions and order processing?

1. OLTP
2. OLAP
3. Data lake analytics
4. Batch analytics

Correct Answer: 1

Explanation

Point-of-sale systems and order-processing applications typically use OLTP, or Online Transaction Processing. These workloads involve frequent transactions such as creating orders, updating inventory, processing payments, and recording customer information. OLTP systems are designed to handle many concurrent operations efficiently while maintaining transaction integrity. OLAP is more focused on analytical queries and historical analysis. Data lakes and batch analytics are generally associated with data processing and analysis rather than immediate operational transactions. Therefore, OLTP is the workload type most closely associated with point-of-sale and order-processing systems.

Question 272

Which SQL operation combines rows from related tables based on a matching condition?

1. ORDER BY
2. JOIN
3. DELETE
4. INSERT

Correct Answer: 2

Explanation

A JOIN operation combines data from two or more relational tables based on a related condition. For example, a Customers table and an Orders table can be joined using CustomerID to retrieve customer information together with their orders. Common join types include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. ORDER BY sorts results, DELETE removes rows, and INSERT adds new rows. JOIN operations are fundamental to relational database queries because normalized data is often distributed across multiple related tables that need to be queried together.

Question 273

Which Azure service is designed to store messages for asynchronous communication?

1. Azure Blob Storage
2. Azure Queue Storage
3. Azure Files
4. Azure Database for PostgreSQL

Correct Answer: 2

Explanation

Azure Queue Storage provides a simple messaging mechanism for asynchronous communication between application components. A producer application can place messages into a queue, while a consumer application retrieves and processes them later. This approach helps decouple application components and can accommodate differences in processing speed. Blob Storage stores objects, Azure Files provides shared file storage, and Azure Database for PostgreSQL provides relational database capabilities. Queue Storage is therefore appropriate when applications need a simple queue-based communication mechanism without requiring direct synchronous communication between components.

Question 274

Which storage architecture is commonly used as a centralized repository for raw structured, semi-structured, and unstructured data?

1. Data lake
2. OLTP database
3. Relational index
4. Transaction log

Correct Answer: 1

Explanation

A data lake is designed to store large volumes of raw data in different formats. It can contain structured data from databases, semi-structured formats such as JSON and XML, and unstructured data such as images, videos, and documents. Data lakes are commonly used as centralized repositories for analytics, data science, machine learning, and large-scale processing. Unlike traditional data warehouses, data lakes can retain data before it is transformed into a highly structured format. Azure Data Lake Storage Gen2 is commonly used as the storage foundation for data lake solutions.

Question 275

Which Azure service provides a managed relational database compatible with PostgreSQL?

1. Azure Cosmos DB
2. Azure Database for PostgreSQL
3. Azure Blob Storage
4. Azure Event Hubs

Correct Answer: 2

Explanation

Azure Database for PostgreSQL provides managed PostgreSQL database capabilities in Azure. It supports relational database concepts such as tables, SQL queries, indexes, constraints, and transactions. Microsoft manages much of the underlying infrastructure, allowing organizations to focus more on applications and data rather than server maintenance. Cosmos DB is designed for NoSQL workloads, Blob Storage is object storage, and Event Hubs is an event ingestion service. Azure Database for PostgreSQL is therefore appropriate when an application requires PostgreSQL functionality in a managed Azure environment.

Question 276

Which SQL statement is used to retrieve selected columns from a database table?

1. SELECT
2. UPDATE
3. DELETE
4. INSERT

Correct Answer: 1

Explanation

The SELECT statement is used to retrieve data from one or more database tables. It can specify particular columns, filter records using WHERE, sort results using ORDER BY, group records using GROUP BY, and combine tables with JOIN operations. For example, SELECT Name, Email FROM Customers can retrieve only the Name and Email columns from a Customers table. INSERT adds new rows, UPDATE changes existing rows, and DELETE removes rows. SELECT is therefore the primary SQL statement used when applications or users need to read information from relational databases.

Question 277

Which Azure service is designed for large-scale analytics and data warehousing?

1. Azure Files
2. Azure Queue Storage
3. Azure Synapse Analytics
4. Azure Database for MySQL

Correct Answer: 3

Explanation

Azure Synapse Analytics is designed for large-scale analytical workloads and data warehousing. It provides capabilities for analyzing large datasets and supports scenarios involving business intelligence, reporting, historical analysis, and complex analytical queries. Synapse can work with data from multiple sources and can integrate with other Azure data services. Azure Files provides shared file storage, Queue Storage handles asynchronous messaging, and Azure Database for MySQL is a managed relational database. Synapse Analytics is therefore the Azure service most closely associated with enterprise-scale data warehousing and analytical workloads.

Question 278

Which database model stores records as flexible JSON-like documents?

1. Graph
2. Key-value
3. Document
4. Relational

Correct Answer: 3

Explanation

A document database stores information as documents, commonly using formats such as JSON. Documents can contain fields, nested objects, and arrays, and different documents may have different structures. This flexibility is useful for applications where data requirements change frequently or where hierarchical information needs to be stored naturally. Graph databases focus on relationships, key-value databases store values associated with keys, and relational databases organize information into tables. Document databases are widely used in modern web and application development because they can accommodate flexible schemas and complex nested data.

Question 279

Which process involves extracting data, transforming it, and then loading it into a destination?

1. ELT
2. ETL
3. OLAP
4. OLTP

Correct Answer: 2

Explanation

ETL stands for Extract, Transform, Load. During an ETL process, data is extracted from one or more source systems, transformed into the required format, and then loaded into the target destination. Transformations may include cleaning data, removing duplicates, changing data types, filtering records, or combining information from multiple sources. ELT follows a different sequence by loading data before transformation. OLTP and OLAP describe workload types rather than integration processes. ETL is commonly used when organizations want data to be prepared before it reaches a data warehouse or another analytical destination.

Question 280

Which Azure service can continuously analyze incoming event data using streaming queries?

1. Azure Stream Analytics
2. Azure Data Factory
3. Azure Files
4. Azure Table Storage

Correct Answer: 1

Explanation

Azure Stream Analytics is a managed service for processing and analyzing streaming data continuously. It can receive incoming events and execute queries that filter, aggregate, transform, or detect patterns in the data. Common scenarios include IoT telemetry, application monitoring, real-time analytics, and event-driven processing. Azure Data Factory is primarily focused on data integration and orchestration, Azure Files provides shared file storage, and Table Storage is a NoSQL storage service. Stream Analytics is therefore the appropriate choice when an organization needs continuous analysis of incoming event streams with low processing latency.