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

 

Question 301

Which Azure service is designed to store large amounts of unstructured object data?

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

Correct Answer: 1

Explanation

Azure Blob Storage is an object storage service designed for large amounts of unstructured data. It can store images, videos, documents, backups, logs, and other files. Data is organized into containers and blobs, making the service suitable for applications that need scalable cloud storage. Blob Storage can also be used as part of data lake solutions and backup architectures. Azure Table Storage is designed for NoSQL entities, Queue Storage handles messages, and Azure SQL Database provides relational database functionality. Therefore, Blob Storage is the appropriate service for storing unstructured objects.

Question 302

Which Azure service provides a managed relational database based on the MySQL engine?

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

Correct Answer: 2

Explanation

Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It allows organizations to run MySQL workloads in Azure without managing much of the underlying infrastructure. Applications can use standard SQL, relational tables, indexes, constraints, and transactions. This service is suitable for web applications and business applications that depend on MySQL. Azure Cosmos DB provides NoSQL database capabilities, Blob Storage provides object storage, and Event Hubs handles event ingestion. Therefore, Azure Database for MySQL is the correct choice for managed MySQL workloads.

Question 303

Which SQL statement is used to retrieve data from a relational database?

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

Correct Answer: 3

Explanation

The SELECT statement is used to retrieve information from one or more relational database tables. It can return specific columns, filter rows with WHERE, sort results with ORDER BY, group data with GROUP BY, and combine tables using JOIN operations. SELECT is commonly used by applications, administrators, analysts, and reporting systems to read stored information. INSERT adds new rows, UPDATE changes existing rows, and DELETE removes rows. Therefore, when the requirement is to read data from a relational database, SELECT is the appropriate SQL statement.

Question 304

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

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

Correct Answer: 3

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 geographic regions. This makes it useful for applications requiring low-latency access and global availability. Common scenarios include web applications, IoT systems, personalization platforms, and other modern application workloads. Azure SQL Database provides relational database capabilities, Data Factory is used for data integration, and Azure Files provides shared file storage. Cosmos DB is therefore the appropriate choice for globally distributed NoSQL requirements.

Question 305

Which ACID property ensures that a transaction is completed completely or not performed at all?

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

Correct Answer: 2

Explanation

Atomicity means that a database transaction is treated as one indivisible unit of work. If all operations in the transaction succeed, the transaction can be committed. If an operation fails, the transaction can be rolled back so that partial changes are not left behind. Consistency ensures that database rules remain valid, isolation manages interactions between concurrent transactions, and durability preserves committed changes after failures. Atomicity is especially important for multi-step operations, such as transferring money between accounts, where both sides of the transaction must succeed together.

Question 306

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

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

Correct Answer: 2

Explanation

Azure Data Factory is a cloud-based data integration service used to create pipelines that move and process data. It can connect to different sources and destinations and coordinate activities such as copying data, transformations, and other processing tasks. Data Factory can support ETL and ELT workflows and is useful when organizations need to integrate information from multiple systems. Queue Storage provides messaging, Table Storage provides NoSQL entities, and Cosmos DB provides NoSQL database capabilities. Data Factory is therefore the appropriate service for orchestrating data integration workflows.

Question 307

Which database model stores data in documents that can contain nested fields and arrays?

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

Correct Answer: 3

Explanation

A document database stores information as documents, commonly using JSON-like structures. Documents can contain nested objects, arrays, and different fields, allowing flexible schemas. This makes document databases useful for modern applications where data structures may evolve or vary between records. Relational databases organize data into predefined tables, key-value databases focus on pairs of keys and values, and graph databases focus on relationships between entities. Document databases are especially useful when applications need to store hierarchical or semi-structured information without requiring every record to have exactly the same structure.

Question 308

Which Azure service provides shared cloud file storage?

1. Azure Files
2. Azure Blob Storage
3. Azure Queue Storage
4. Azure Event Hubs

Correct Answer: 1

Explanation

Azure Files provides managed cloud file shares that can be accessed by applications and multiple machines. It is designed for scenarios that require a shared file-system experience, including application files, configuration files, and migration from traditional file servers. Blob Storage is intended for object storage, Queue Storage provides asynchronous messaging, and Event Hubs is designed for high-volume event ingestion. Azure Files can therefore be selected when an application needs shared files rather than individual objects, database records, or event messages.

Question 309

Which workload type is optimized for frequent transactional operations such as inserting and updating records?

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

Correct Answer: 2

Explanation

OLTP stands for Online Transaction Processing and is designed for workloads involving frequent transactions. Examples include order processing, payment systems, inventory management, and customer account updates. OLTP systems generally need fast response times and reliable transaction processing because many users may perform operations concurrently. OLAP is designed for analytical queries and historical analysis. Data lakes provide storage for different types of data, while batch analytics focuses on processing data in groups. Therefore, OLTP is the appropriate workload type for applications that frequently insert, update, and delete operational records.

Question 310

Which SQL clause is used to group rows that have the same values?

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

Correct Answer: 3

Explanation

The GROUP BY clause is used to group rows that share the same values in one or more columns. It is commonly used with aggregate functions such as COUNT, SUM, AVG, MIN, and MAX. For example, a sales query can group orders by customer or by product category and calculate the total sales for each group. WHERE filters individual rows, ORDER BY sorts the result, and JOIN combines data from related tables. GROUP BY is therefore an important SQL feature for analytical queries and summary calculations.

Question 311

Which Azure service is designed to store simple NoSQL entities using partition and row keys?

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

Correct Answer: 1

Explanation

Azure Table Storage is a NoSQL key-attribute data store that organizes information into tables containing entities and properties. Each entity can be identified using partition and row keys, supporting efficient access patterns. Table Storage is useful when an application requires scalable storage for relatively simple structured data without the complexity of a relational database. Blob Storage is designed for objects, SQL Database provides relational functionality, and Azure Files provides shared file storage. Therefore, Azure Table Storage is the appropriate choice for NoSQL entities organized with partition and row keys.

Question 312

Which Azure service is designed to process incoming event streams with low latency?

1. Azure Data Factory
2. Azure Stream Analytics
3. Azure Files
4. Azure Database for PostgreSQL

Correct Answer: 2

Explanation

Azure Stream Analytics is designed for real-time or near-real-time processing of streaming data. It can continuously analyze incoming events and perform operations such as filtering, grouping, aggregation, and pattern detection. Typical scenarios include IoT telemetry, application monitoring, fraud detection, and real-time dashboards. Data Factory focuses on data integration and pipeline orchestration, Azure Files provides shared file storage, and PostgreSQL is a relational database service. Stream Analytics is therefore the appropriate choice when incoming event data needs to be analyzed continuously with low latency.

Question 313

Which database key is used to establish a relationship between two relational tables?

1. Primary key
2. Foreign key
3. Unique index
4. Composite view

Correct Answer: 2

Explanation

A foreign key establishes a relationship between two relational database tables. It typically contains values that reference a primary key or another unique key in a related table. For example, an Orders table can contain a CustomerID foreign key that references CustomerID in a Customers table. This helps maintain referential integrity and connects related records. A primary key uniquely identifies rows within its own table, while indexes primarily improve query performance. Foreign keys are therefore fundamental when designing relationships between related relational tables.

Question 314

Which Azure service is commonly used to ingest high volumes of telemetry and event data?

1. Azure Files
2. Azure SQL Database
3. Azure Event Hubs
4. Azure Table Storage

Correct Answer: 3

Explanation

Azure Event Hubs is a managed event ingestion service designed to receive large volumes of events and telemetry. It is commonly used with applications, IoT devices, monitoring systems, and streaming architectures. Event Hubs can collect incoming events and make them available to downstream services for processing or storage. Azure Stream Analytics can analyze the incoming data in real time. Azure Files provides file shares, SQL Database provides relational storage, and Table Storage provides NoSQL entities. Event Hubs is therefore the appropriate service for high-volume event ingestion scenarios.

Question 315

Which approach stores raw data in different formats before it is transformed for analysis?

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

Correct Answer: 1

Explanation

A data lake is a centralized repository designed to store large volumes of raw data in different formats. It can contain structured, semi-structured, and unstructured data, including relational records, JSON files, logs, documents, images, and videos. Data can be transformed later when it is needed for analytics, reporting, or machine learning. This differs from many traditional data warehouse approaches where data is generally structured and prepared before loading. Azure Data Lake Storage Gen2 is commonly used as the storage foundation for cloud data lake architectures.

Question 316

Which SQL statement modifies values in existing rows?

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

Correct Answer: 2

Explanation

The UPDATE statement modifies values in existing rows of a relational database table. It can change one or more columns for records that satisfy a specified condition. A WHERE clause is commonly used to identify which rows should be updated. For example, an application can use UPDATE to change a customer’s address or update the price of a product. DELETE removes records, INSERT adds new records, and SELECT retrieves data. UPDATE is therefore the correct SQL operation when existing database information needs to be changed.

Question 317

Which Azure service provides managed analytics and data warehousing capabilities?

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

Correct Answer: 2

Explanation

Azure Synapse Analytics is an Azure analytics service designed to support large-scale data warehousing and analytical workloads. It provides capabilities for querying and analyzing large datasets and can integrate data from multiple sources. Organizations can use Synapse for business intelligence, reporting, historical analysis, and complex analytical workloads. Queue Storage provides messaging, Azure Files provides shared file storage, and Azure Database for MySQL provides relational database functionality. Synapse Analytics is therefore the appropriate service when the primary requirement is enterprise-scale analytics and data warehousing.

Question 318

Which data category includes images, audio recordings, and videos?

1. Structured data
2. Relational data
3. Unstructured data
4. Tabular data

Correct Answer: 3

Explanation

Images, audio recordings, and videos are commonly classified as unstructured data because they do not naturally follow a fixed relational table structure. These files can contain large amounts of information but generally do not consist of predefined rows and columns. Azure Blob Storage is commonly used to store this type of data because it provides scalable object storage. Structured data, by contrast, follows a defined schema such as a relational table. Understanding whether data is structured, semi-structured, or unstructured helps determine which storage and processing technologies are appropriate.

Question 319

Which Azure service provides a managed relational database using the PostgreSQL engine?

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

Correct Answer: 1

Explanation

Azure Database for PostgreSQL is a managed relational database service based on PostgreSQL. It allows organizations to run PostgreSQL workloads in Azure while Microsoft manages much of the infrastructure. Applications can use standard PostgreSQL functionality, including SQL queries, tables, indexes, constraints, and transactions. Cosmos DB is a NoSQL database, Blob Storage provides object storage, and Event Hubs provides event ingestion. Azure Database for PostgreSQL is therefore the appropriate service when an application requires PostgreSQL-compatible relational database functionality in a managed Azure environment.

Question 320

Which SQL statement is used to remove rows from a table?

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

Correct Answer: 4

Explanation

The DELETE statement is used to remove rows from a relational database table. A WHERE clause is typically used to identify the records that should be deleted. For example, an application can delete a customer record that meets a specified condition. Without a WHERE clause, DELETE can remove all rows from the table, although the table structure itself remains. INSERT adds records, UPDATE modifies existing records, and SELECT retrieves information. Therefore, DELETE is the SQL command used when existing rows need to be removed from a table.