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

 

Question 381

Which Azure service is best suited for storing large amounts of unstructured data such as videos and documents?

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

Correct Answer: 3

Explanation

Azure Blob Storage is designed to store large amounts of unstructured object data. Common examples include videos, images, documents, backups, log files, and other binary content. Data is organized into containers and blobs, allowing applications to store and retrieve objects at scale. Azure Queue Storage is intended for messages, Table Storage provides a NoSQL key-attribute model, and Azure SQL Database is a relational database service. Therefore, Blob Storage is the appropriate Azure service when the primary requirement is scalable storage for unstructured objects and files.

Question 382

Which Azure service provides a managed relational database based on the PostgreSQL database 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 the PostgreSQL engine. It allows organizations to run PostgreSQL applications in Azure while reducing the need to manage underlying infrastructure. The service supports relational tables, SQL queries, indexes, constraints, and transactions. Azure Cosmos DB is a NoSQL database service, Blob Storage is used for object storage, and Event Hubs is designed for event ingestion. Therefore, Azure Database for PostgreSQL is the correct choice when an application requires managed PostgreSQL database functionality in Azure.

Question 383

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

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

Correct Answer: 2

Explanation

The SELECT statement is used to retrieve data from relational database tables. It can return selected columns and rows and can be combined with clauses such as WHERE, ORDER BY, GROUP BY, and JOIN. For example, SELECT can retrieve customer details, filter orders, or calculate totals using aggregate functions. INSERT adds new records, UPDATE changes existing records, and DELETE removes records. Therefore, SELECT is the appropriate SQL statement when the requirement is to read information from a relational database without changing the stored data.

Question 384

Which Azure service provides a globally distributed NoSQL database platform?

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

Correct Answer: 4

Explanation

Azure Cosmos DB is a managed NoSQL database service designed for globally distributed applications. It supports flexible data models and can distribute data across multiple geographic regions. This makes it suitable for applications that require scalable performance and low-latency access for users in different locations. Azure SQL Database provides relational database capabilities, Azure Files provides shared file storage, and Data Factory is used for data integration. Therefore, Azure Cosmos DB is the appropriate choice for globally distributed NoSQL database workloads.

Question 385

Which ACID property ensures that all operations in a transaction are completed together or none are applied?

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

Correct Answer: 1

Explanation

Atomicity means that a database transaction is treated as one indivisible unit of work. If every operation succeeds, 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 controls interactions between concurrent transactions, and durability ensures committed changes survive failures. Atomicity is particularly important for transactions involving multiple related operations, such as transferring money between accounts, where incomplete execution could produce incorrect results.

Question 386

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

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

Correct Answer: 3

Explanation

Azure Data Factory is a cloud-based data integration service used to create and manage data pipelines. These pipelines can move information between different data sources and destinations and coordinate transformation activities. Data Factory is commonly used in ETL and ELT architectures and can integrate with many Azure and external services. Azure Files provides shared file storage, Cosmos DB provides NoSQL database capabilities, and Table Storage provides NoSQL entities. Therefore, Azure Data Factory is the correct choice when an organization needs to orchestrate data movement and transformation workflows.

Question 387

Which database model stores information as documents, often using JSON-like structures?

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

Correct Answer: 2

Explanation

A document database stores information as individual documents, commonly using JSON or JSON-like structures. Documents can contain nested objects, arrays, and flexible fields, making this model useful for applications where data structures may change over time. A graph database focuses on relationships between nodes, a key-value database stores values associated with keys, and a relational database organizes data into tables. Document databases are commonly used for web applications, content systems, product catalogs, and other workloads requiring flexible semi-structured data. Therefore, the document model is correct.

Question 388

Which Azure storage service is designed to provide asynchronous messaging between application components?

1. Azure Blob Storage
2. Azure Files
3. Azure Queue Storage
4. Azure Table Storage

Correct Answer: 3

Explanation

Azure Queue Storage provides a simple cloud-based messaging mechanism for asynchronous communication. One application component can place a message into a queue, while another component retrieves and processes the message later. This helps separate application components and allows workloads to be processed at different speeds. Blob Storage is designed for object storage, Azure Files provides shared file storage, and Table Storage provides NoSQL entities. Therefore, Azure Queue Storage is the appropriate service when an application requires a queue for asynchronous communication and message processing.

Question 389

Which workload is primarily designed for day-to-day business transactions?

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

Correct Answer: 1

Explanation

OLTP stands for Online Transaction Processing and is designed for operational, day-to-day business transactions. Examples include processing customer orders, updating inventory, recording payments, and managing reservations. OLTP systems typically require fast transaction processing and support many concurrent users. OLAP is focused on analytical workloads and historical analysis, while data warehouses and data lakes are generally used for analytics. Therefore, OLTP is the correct workload type for applications that continuously perform operational transactions and require reliable, fast updates to business data.

Question 390

Which SQL clause is used to filter rows based on a condition?

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

Correct Answer: 2

Explanation

The WHERE clause filters rows based on one or more specified conditions. For example, a query can use WHERE to return customers from a particular city or products with a price greater than a specified amount. WHERE can also be used with UPDATE and DELETE statements to restrict which rows are modified or removed. ORDER BY sorts results, GROUP BY creates groups for aggregation, and JOIN combines related data from tables. Therefore, WHERE is the correct SQL clause when the goal is to filter records according to a condition.

Question 391

Which Azure service is designed for real-time processing of streaming data?

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

Correct Answer: 2

Explanation

Azure Stream Analytics is designed to process and analyze streaming data continuously. It can receive incoming events and perform operations such as filtering, grouping, aggregation, and calculations with low latency. Common scenarios include IoT telemetry, real-time monitoring, fraud detection, and streaming dashboards. Azure Data Factory is primarily used for data integration and pipeline orchestration, while SQL Database provides relational storage and Azure Files provides shared file storage. Therefore, Azure Stream Analytics is the appropriate service for real-time or near-real-time stream processing.

Question 392

Which key uniquely identifies a record in a relational database table?

1. Primary key
2. Foreign key
3. Index
4. View

Correct Answer: 1

Explanation

A primary key uniquely identifies each record in a relational database table. Values in the primary key must be unique, and a primary key normally cannot contain NULL values. For example, CustomerID can be the primary key in a Customers table. A foreign key establishes relationships between tables, an index improves query performance, and a view provides a virtual representation of query results. Therefore, the primary key is the correct choice when the requirement is to uniquely identify every row in a relational table.

Question 393

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

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

Correct Answer: 3

Explanation

Azure Event Hubs is a managed service designed to ingest large volumes of events and telemetry. Applications, IoT devices, monitoring systems, and other producers can send event data to Event Hubs for downstream processing. The events can then be processed by services such as Azure Stream Analytics or stored for later analysis. Azure SQL Database provides relational storage, Azure Files provides shared file storage, and Table Storage provides NoSQL entities. Therefore, Azure Event Hubs is the appropriate choice for high-throughput event ingestion scenarios.

Question 394

Which SQL command is used to modify values in existing records?

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

Correct Answer: 3

Explanation

The UPDATE statement is used to modify existing rows in a relational database table. It can change one or more column values for records that satisfy a specified condition. A WHERE clause is commonly used with UPDATE to ensure that only intended records are modified. INSERT adds new records, DELETE removes existing records, and SELECT retrieves data. For example, UPDATE can be used to change a customer’s address or modify the price of a product. Therefore, UPDATE is the correct SQL statement for changing existing database information.

Question 395

Which type of data commonly includes images, audio, and video files?

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

Correct Answer: 4

Explanation

Images, audio recordings, and video files are commonly considered unstructured data because they do not naturally conform to a predefined relational table structure. These files can contain significant amounts of information but are not typically organized into rows and columns. Structured data follows a defined schema, such as a relational database table, while semi-structured data includes formats such as JSON and XML. Understanding data types helps organizations select suitable storage technologies. Azure Blob Storage, for example, is commonly used to store unstructured files at scale.

Question 396

Which Azure service provides managed analytics and data warehousing capabilities?

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

Correct Answer: 1

Explanation

Azure Synapse Analytics is an Azure analytics service designed for large-scale analytical workloads and data warehousing. It allows organizations to analyze large datasets and combine information from multiple sources. Synapse can support reporting, business intelligence, historical analysis, and complex analytical queries. Azure Queue Storage is used for messaging, Azure Files provides shared file storage, and Azure Database for MySQL is a managed relational database service. Therefore, Azure Synapse Analytics is the appropriate service when an organization requires enterprise-scale analytics and data warehousing capabilities.

Question 397

Which approach transforms data after it has been loaded into the target data platform?

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

Correct Answer: 3

Explanation

ELT stands for Extract, Load, Transform. In an ELT process, data is first extracted from source systems and loaded into the target platform. Transformations are then performed within that target environment. This approach is common in modern cloud data platforms because they can provide substantial processing power for transforming large datasets after ingestion. ETL transforms data before loading it into the target. OLTP and OLAP describe transaction and analytical workloads rather than data integration sequences. Therefore, ELT is the correct approach when transformation occurs after loading.

Question 398

Which Azure service provides shared cloud-based file storage?

1. Azure Blob Storage
2. Azure Files
3. Azure Event Hubs
4. Azure Cosmos DB

Correct Answer: 2

Explanation

Azure Files provides managed file shares in Azure that can be accessed by applications and virtual machines. It is designed for scenarios where multiple clients need access to shared files through standard file-sharing mechanisms. Blob Storage is designed for object storage, Event Hubs is used for high-volume event ingestion, and Cosmos DB provides NoSQL database functionality. Azure Files is useful for application data, shared documents, configuration files, and migration scenarios involving traditional file servers. Therefore, Azure Files is the correct service for shared cloud file storage.

Question 399

Which SQL statement is used to add new rows to a table?

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

Correct Answer: 4

Explanation

The INSERT statement is used to add new rows to a relational database table. It can specify values for selected columns or for all required columns in the table. For example, an application can use INSERT to create a new customer or order record. UPDATE modifies existing records, DELETE removes records, and SELECT retrieves records. INSERT is therefore the correct SQL command when new information needs to be added to an existing table. Database constraints and data types are checked when the new record is inserted.

Question 400

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

1. Azure Table Storage
2. Azure SQL Database
3. Azure Blob Storage
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. Entities are identified using partition and row keys, which support efficient data access patterns. It is useful for applications that need scalable storage for relatively simple structured information without requiring a traditional relational database schema. Azure SQL Database provides relational functionality, Blob Storage stores objects, and Azure Files provides shared file storage. Therefore, Azure Table Storage is the appropriate choice for storing simple NoSQL entities using partition and row keys.