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

 

Question 341

Which Azure service is primarily used for storing objects such as images, videos, and documents?

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

Correct Answer: 3

Explanation

Azure Blob Storage is designed for storing large amounts of unstructured object data. Objects can include images, videos, documents, backups, logs, and other files. Blob Storage organizes data into containers and provides highly scalable storage for cloud applications. Azure Files is designed for shared file storage, while Queue Storage is used for asynchronous messaging. Azure SQL Database is a relational database service rather than an object storage service. Blob Storage can also be used as part of data lake architectures and is suitable when applications need to store and retrieve large quantities of files or other unstructured objects.

Question 342

Which database model stores information as key-value pairs?

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

Correct Answer: 1

Explanation

A key-value database stores data as a collection of unique keys associated with corresponding values. The value can contain simple information or more complex data depending on the database technology. This model is useful when applications primarily need to retrieve information based on a known key. It is commonly used for caching, session information, configuration data, and other high-speed lookup scenarios. Relational databases use tables and relationships, graph databases focus on nodes and edges, and document databases store document-oriented records. Therefore, the key-value model is the correct choice.

Question 343

Which Azure service is designed to provide managed relational database capabilities using SQL Server technology?

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

Correct Answer: 2

Explanation

Azure SQL Database is a fully managed relational database service based on Microsoft SQL Server technologies. It supports SQL queries, tables, indexes, relationships, transactions, views, and other relational database capabilities. Microsoft manages much of the underlying infrastructure, reducing the administrative work required from customers. Azure Cosmos DB is a NoSQL database service, Blob Storage is object storage, and Event Hubs is used for event ingestion. Azure SQL Database is therefore appropriate when an application requires a managed relational database in Azure without directly maintaining the database server infrastructure.

Question 344

Which SQL command is used to remove existing rows from a table?

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

Correct Answer: 4

Explanation

The DELETE statement removes existing rows from a relational database table. A WHERE clause is normally used to specify which rows should be removed. For example, an application might delete a customer record that matches a particular customer ID. If a WHERE clause is omitted, all rows can potentially be deleted, so care is required when executing DELETE statements. SELECT retrieves data, INSERT adds new rows, and UPDATE modifies existing rows. Therefore, DELETE is the appropriate SQL command when records need to be removed from a table.

Question 345

Which Azure service is used to create pipelines for moving and transforming data between different sources and destinations?

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

Correct Answer: 1

Explanation

Azure Data Factory is a cloud-based data integration service that allows organizations to create and manage data pipelines. Pipelines can copy information from different sources, move it to target systems, and coordinate transformation or processing activities. Data Factory is commonly used for ETL and ELT workflows and can connect to many different data stores and services. Azure Files provides file shares, Table Storage provides NoSQL entities, and Cosmos DB provides NoSQL database capabilities. Therefore, Azure Data Factory is the correct choice for orchestrating data movement and transformation pipelines.

Question 346

Which ACID property ensures that a database remains valid according to its defined rules after a transaction completes?

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

Correct Answer: 2

Explanation

Consistency ensures that a database moves from one valid state to another valid state after a transaction. Database constraints, rules, relationships, and other integrity requirements should remain satisfied when the transaction completes. Atomicity means that all operations in a transaction succeed together or are rolled back. Isolation controls how concurrent transactions interact, while durability ensures committed changes survive failures. Consistency is particularly important in relational databases because invalid relationships or constraint violations could lead to unreliable information. Therefore, consistency is the ACID property described in this question.

Question 347

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

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

Correct Answer: 3

Explanation

Azure Cosmos DB is a managed NoSQL database service designed for scalable and globally distributed applications. It can distribute data across geographic regions and provide low-latency access for users around the world. Cosmos DB supports flexible data models and is commonly used for modern web applications, IoT solutions, personalization systems, and globally distributed workloads. Azure SQL Database is a relational service, Azure Files provides shared file storage, and Data Factory provides data integration capabilities. Therefore, Azure Cosmos DB is the appropriate choice for globally distributed NoSQL applications.

Question 348

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

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

Correct Answer: 1

Explanation

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

Question 349

Which Azure storage service provides cloud-based file shares?

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

Correct Answer: 2

Explanation

Azure Files provides managed cloud file shares that applications and virtual machines can access. It is useful when workloads require a shared file-system experience similar to traditional network file shares. Organizations can use Azure Files for application data, configuration files, shared documents, and migration scenarios involving file servers. Blob Storage is designed for objects, Queue Storage is designed for messages, and Table Storage provides NoSQL entities. Therefore, Azure Files is the correct choice when an application needs shared cloud-based file storage accessible by multiple clients.

Question 350

Which workload is optimized for frequent inserts, updates, and deletes?

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

Correct Answer: 3

Explanation

OLTP stands for Online Transaction Processing and is designed for workloads involving frequent transactional operations. Examples include order processing, banking systems, inventory management, customer account updates, and reservation systems. OLTP databases are generally optimized for fast individual transactions and concurrent access. OLAP is focused on analytical queries and historical analysis, while data warehouses and data lakes are commonly used for analytical workloads. Therefore, OLTP is the appropriate workload type when applications continuously perform inserts, updates, and deletes on operational data.

Question 351

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

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

Correct Answer: 1

Explanation

Azure Event Hubs is a managed event ingestion service designed to handle large volumes of events and telemetry. Applications, IoT devices, monitoring systems, and other sources can send events to Event Hubs for downstream processing. It is commonly used as part of real-time analytics and streaming architectures. Azure Stream Analytics can process incoming events, while other services can store or analyze the resulting information. Azure Files, SQL Database, and Table Storage serve different purposes. Therefore, Event Hubs is the appropriate choice for high-volume event ingestion.

Question 352

Which SQL clause is used to filter rows before they are returned by a query?

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

Correct Answer: 2

Explanation

The WHERE clause is used to filter rows according to a specified condition. For example, a query can use WHERE to return only customers from a specific city or products whose price is greater than a particular amount. WHERE can also be used with UPDATE and DELETE statements to control which records are affected. ORDER BY sorts the result, 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 restrict rows based on a condition.

Question 353

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

1. Azure Data Factory
2. Azure Synapse Analytics
3. Azure Stream Analytics
4. Azure Files

Correct Answer: 3

Explanation

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

Question 354

Which type of data is commonly stored in JSON or XML format?

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

Correct Answer: 2

Explanation

JSON and XML are commonly classified as semi-structured data formats. They contain organizational elements such as fields, names, values, attributes, and nested structures, but they do not necessarily require every record to follow the same rigid schema as a relational table. This flexibility makes JSON and XML popular for APIs, configuration files, logs, and document-oriented applications. Structured data generally follows a predefined schema, such as rows and columns in a relational table. Therefore, semi-structured data is the correct classification for common JSON and XML information.

Question 355

Which key is used to uniquely identify a row within a relational table?

1. Foreign key
2. Primary key
3. Secondary index
4. Partition key

Correct Answer: 2

Explanation

A primary key uniquely identifies each row in a relational table. It must contain unique values and normally cannot contain NULL values. For example, an EmployeeID column can serve as the primary key in an Employees table. A foreign key is used to establish relationships with another table, while indexes are mainly used to improve query performance. Partition keys are commonly used in distributed or NoSQL systems. Therefore, the primary key is the correct choice when the requirement is to uniquely identify individual records within a relational table.

Question 356

Which Azure service is best suited for storing simple NoSQL data using entities and properties?

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

Correct Answer: 2

Explanation

Azure Table Storage is a NoSQL key-attribute data store that uses tables containing entities and properties. Each entity can have a flexible set of properties, making the service useful when a relational schema is unnecessary. It can provide scalable storage for applications that need simple NoSQL data access. Azure SQL Database uses a relational model, Azure Files provides shared file storage, and Event Hubs is designed for event ingestion. Therefore, Azure Table Storage is the appropriate choice for applications that need simple NoSQL entities and properties.

Question 357

Which Azure service provides enterprise-scale analytics and data warehousing capabilities?

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

Correct Answer: 4

Explanation

Azure Synapse Analytics is designed for large-scale analytical workloads and data warehousing. It enables organizations to analyze large amounts of information and integrate data from different sources for reporting and business intelligence. Synapse can support complex analytical queries and is commonly used in enterprise data platforms. Azure Files provides file storage, Queue Storage handles messages, and Azure Database for MySQL is a managed relational database service. Therefore, Azure Synapse Analytics is the appropriate choice for enterprise-scale analytics and data warehouse scenarios.

Question 358

Which process loads data into a target platform before performing transformations within that platform?

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

Correct Answer: 3

Explanation

ELT stands for Extract, Load, Transform. In this approach, data is extracted from source systems and loaded into the target data platform before many transformations are performed. Modern cloud data platforms can provide significant processing power, making this approach useful for large analytical workloads. ETL performs transformation before loading the data into the target. OLTP and OLAP describe different workload types rather than data integration sequences. Therefore, ELT is the correct choice when data is loaded into the target platform before transformation occurs.

Question 359

Which Azure service provides a managed relational database based on 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 the PostgreSQL database engine. It allows organizations to run PostgreSQL workloads in Azure while Microsoft handles much of the underlying infrastructure management. Applications can use SQL queries, tables, indexes, relationships, transactions, and other PostgreSQL capabilities. Azure Cosmos DB provides NoSQL functionality, Blob Storage is designed for object storage, and Event Hubs is used for event ingestion. Therefore, Azure Database for PostgreSQL is the correct choice for managed PostgreSQL relational workloads.

Question 360

Which Azure service is used to store and process data pipelines from multiple sources?

1. Azure Queue Storage
2. Azure Data Factory
3. Azure Files
4. Azure Table Storage

Correct Answer: 2

Explanation

Azure Data Factory is a cloud-based data integration service used to create and manage pipelines that move and transform data. It can connect to many different data sources and destinations and coordinate activities such as copying data, transformations, and processing steps. Data Factory is commonly used to build ETL and ELT workflows. Queue Storage is intended for messages, Azure Files provides shared file storage, and Table Storage is a NoSQL data store. Therefore, Azure Data Factory is the appropriate service for managing data pipelines across multiple sources.