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

 

Question 221

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

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

Correct Answer: 3

Explanation

Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It allows organizations to deploy MySQL databases in Azure without having to manage the underlying operating system and much of the database infrastructure themselves. Applications can use standard SQL, tables, indexes, relationships, and transactions. It is suitable for web applications and other workloads that depend on MySQL. Azure Cosmos DB is designed for NoSQL workloads, Blob Storage stores objects, and Table Storage provides NoSQL key-attribute storage. Therefore, Azure Database for MySQL is the appropriate choice for managed MySQL workloads.

Question 222

Which data type is typically considered semi-structured?

1. JSON
2. Video
3. Relational table
4. Bitmap image

Correct Answer: 1

Explanation

JSON is commonly classified as semi-structured data because it contains organizational elements such as keys, values, nested objects, and arrays, but it does not require the rigid tabular structure of a traditional relational database. JSON is widely used by web APIs and modern applications because it can represent complex and changing data structures. Video and bitmap images are generally considered unstructured data. Relational tables are structured data because they follow predefined rows, columns, and schemas. Semi-structured formats provide flexibility while still containing enough organization for software to interpret and process the information.

Question 223

Which Azure service can be used to store large amounts of unstructured objects?

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

Correct Answer: 2

Explanation

Azure Blob Storage is designed for storing large amounts of unstructured object data. Examples include photographs, videos, documents, backups, logs, and other files. Data is stored as blobs inside containers, allowing applications to access objects through Azure-supported interfaces. Blob Storage is highly scalable and is commonly used for data lakes, media storage, backup solutions, and application content. Queue Storage is designed for messages, PostgreSQL is a relational database service, and Table Storage is a NoSQL key-attribute store. Therefore, Blob Storage is the appropriate choice when the requirement is scalable object storage.

Question 224

Which workload is primarily designed for frequent inserts, updates, and deletes of individual records?

1. OLAP
2. Data warehousing
3. OLTP
4. Data visualization

Correct Answer: 3

Explanation

OLTP stands for Online Transaction Processing and is designed for workloads involving frequent transactional operations such as INSERT, UPDATE, and DELETE. Examples include order processing, banking transactions, inventory updates, and customer account management. OLTP systems generally prioritize fast transaction processing, consistency, and reliable handling of many concurrent users. OLAP systems are instead optimized for analytical queries over large datasets. Data warehouses support analytical workloads, while data visualization presents information to users. Understanding the difference between OLTP and OLAP helps determine whether a workload requires an operational database or an analytical platform.

Question 225

Which Azure service is commonly used to visualize analytical data and create interactive reports?

1. Azure Data Factory
2. Azure Queue Storage
3. Power BI
4. Azure Files

Correct Answer: 3

Explanation

Power BI is a Microsoft analytics and visualization platform used to create interactive reports, dashboards, and visualizations from data. It can connect to many different data sources and allows users to analyze information through charts, tables, filters, and other visual elements. Organizations commonly use Power BI to present business metrics and analytical results to decision-makers. Azure Data Factory focuses on data integration and pipelines, Queue Storage handles asynchronous messages, and Azure Files provides shared file storage. Power BI is therefore the appropriate choice when the main requirement is visualizing and exploring analytical data.

Question 226

Which Azure service can provide a managed SQL Server environment with high compatibility for existing SQL Server applications?

1. Azure SQL Managed Instance
2. Azure Blob Storage
3. Azure Table Storage
4. Azure Queue Storage

Correct Answer: 1

Explanation

Azure SQL Managed Instance is a fully managed Azure database service designed to provide broad compatibility with SQL Server workloads. It is useful when organizations want to migrate existing SQL Server applications to Azure while minimizing application changes. Managed Instance provides many SQL Server features while Azure manages much of the underlying infrastructure. Azure SQL Database is another managed relational option but is generally more database-focused. Blob Storage, Table Storage, and Queue Storage are Azure Storage services rather than SQL Server-compatible database platforms. SQL Managed Instance is therefore appropriate for many SQL Server migration scenarios.

Question 227

Which SQL statement is used to modify existing rows in a table?

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

Correct Answer: 2

Explanation

The UPDATE statement is used to modify existing records in a relational database table. It can change one or more columns for rows that meet a specified condition. A WHERE clause is commonly used with UPDATE to identify the records that should be changed. Without an appropriate condition, an UPDATE statement can potentially affect every row in the table. INSERT adds new records, SELECT retrieves records, and CREATE is used to create database objects such as tables. UPDATE is therefore the SQL operation used when existing stored information needs to be changed.

Question 228

Which Azure service is designed to ingest large volumes of event data from applications and devices?

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

Correct Answer: 1

Explanation

Azure Event Hubs is a managed event ingestion service designed to handle high volumes of events from applications, devices, and other sources. It is commonly used for telemetry, application logging, IoT data, and streaming data pipelines. Event Hubs can receive large numbers of events and make them available for downstream processing and analysis. Azure Stream Analytics can then process streaming data in real time, while other Azure services can store or analyze the resulting information. Azure Files, MySQL, and Table Storage serve different purposes and are not primarily designed for high-volume event ingestion.

Question 229

Which key uniquely identifies each row in a relational database table?

1. Foreign key
2. Index
3. Primary key
4. Composite view

Correct Answer: 3

Explanation

A primary key is used to uniquely identify each row in a relational database table. Each primary-key value must be unique, and a primary key normally cannot contain NULL values. For example, a CustomerID column can serve as the primary key in a Customers table, allowing each customer record to be uniquely identified. A foreign key establishes relationships between tables, while an index primarily helps improve query performance. A view is a virtual representation of query results. Primary keys are therefore fundamental to relational database design and data integrity.

Question 230

Which storage option is best suited for applications that require SMB or NFS file shares?

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

Correct Answer: 2

Explanation

Azure Files provides managed cloud file shares that applications can access using common file-sharing protocols such as SMB, with NFS available for supported configurations. This makes Azure Files useful when applications need a traditional shared file-system experience in the cloud. It can be used for shared application files, configuration data, and migration of traditional file-server workloads. Blob Storage is intended for object storage, Queue Storage provides message queues, and Cosmos DB is a NoSQL database service. Therefore, Azure Files is the appropriate choice for cloud-based shared file storage.

Question 231

Which analytical storage architecture is designed to store large amounts of raw data in its original format?

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

Correct Answer: 1

Explanation

A data lake is designed to store large amounts of data in raw or relatively unprocessed form. It can contain structured, semi-structured, and unstructured data, including database records, JSON files, logs, images, and other formats. Organizations commonly use data lakes as centralized repositories for analytics, data science, and large-scale processing. Unlike a traditional data warehouse, which generally stores highly structured and prepared data, a data lake can preserve data before detailed transformation occurs. Azure Data Lake Storage Gen2 is an Azure service commonly used to build data lake solutions.

Question 232

Which ACID property ensures that a transaction either completes fully or has no effect?

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

Correct Answer: 4

Explanation

Atomicity is the ACID property that ensures a transaction is treated as a single 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 controls interactions between concurrent transactions, and durability ensures committed changes survive failures. Atomicity is especially important for operations involving multiple related changes, such as transferring money between accounts where both the withdrawal and deposit must be handled together.

Question 233

Which Azure service provides a globally distributed NoSQL database platform?

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

Correct Answer: 3

Explanation

Azure Cosmos DB is a globally distributed NoSQL database service designed for applications that need scalable performance and low-latency access across geographic regions. It supports flexible data models and multiple APIs, making it suitable for many modern application scenarios. Organizations can use Cosmos DB for globally available web applications, IoT workloads, personalization systems, and other applications requiring distributed data access. Azure SQL Database provides relational database capabilities, Data Factory handles data integration, and Azure Files provides shared file storage. Cosmos DB is therefore the appropriate service for globally distributed NoSQL database requirements.

Question 234

Which process describes loading raw data into a destination first and transforming it afterward?

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

Correct Answer: 3

Explanation

ELT stands for Extract, Load, Transform. In an ELT process, data is extracted from source systems and loaded into a destination platform before the transformation is performed. This approach is commonly associated with modern cloud data platforms that can provide significant processing power for transforming large datasets after ingestion. ETL performs transformation before loading the data into the destination. OLTP and OLAP describe workload types rather than data integration processes. Understanding ETL and ELT is important when designing modern data pipelines and determining where transformations should occur.

Question 235

Which Azure service can orchestrate activities such as copying data between different systems?

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

Correct Answer: 1

Explanation

Azure Data Factory is a cloud-based data integration service that can orchestrate data movement and processing activities. It allows organizations to create pipelines that copy data between different sources and destinations, execute transformations, and coordinate workflows. For example, a pipeline can retrieve data from a database, move it into cloud storage, and then trigger additional processing. Cosmos DB is a NoSQL database, Table Storage provides key-attribute storage, and Queue Storage is designed for asynchronous messaging. Data Factory is therefore well suited to coordinating multi-step data integration workflows.

Question 236

Which type of database is specifically designed to represent entities and the relationships between them?

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

Correct Answer: 2

Explanation

A graph database is designed to represent entities as nodes and the relationships between them as edges. This model is useful when relationships are central to the application and need to be explored efficiently. Common examples include social networks, recommendation systems, fraud detection, and network analysis. Document databases focus on documents, while key-value databases organize information around key-value pairs. Relational databases can also represent relationships, but graph databases are specifically optimized for traversing connected data. Therefore, a graph database is appropriate when the relationships between entities are a primary part of the workload.

Question 237

Which Azure service provides cloud-based object storage for data such as videos and backups?

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

Correct Answer: 3

Explanation

Azure Blob Storage is Microsoft’s object storage service for large amounts of unstructured data. It is commonly used for videos, images, backups, documents, logs, and other objects that do not need to be stored as relational database rows. Blob Storage organizes objects into containers and supports scalable storage for applications and analytical workloads. Azure Files provides shared file storage, while SQL Database and PostgreSQL provide relational database capabilities. When the requirement is to store large quantities of files or objects rather than relational records, Azure Blob Storage is generally the appropriate service.

Question 238

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

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

Correct Answer: 1

Explanation

The WHERE clause is used in SQL queries to filter rows according to specified conditions. For example, a query can use WHERE to return only customers from a particular city or orders above a certain amount. WHERE can contain comparison operators, logical operators, and other expressions. ORDER BY is used to sort results, GROUP BY groups rows for aggregation, and JOIN combines related data from multiple tables. Using WHERE appropriately helps reduce the number of rows returned and allows applications and analysts to retrieve only the records relevant to a particular query.

Question 239

Which Azure service is primarily designed for storing and retrieving messages between application components?

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

Correct Answer: 2

Explanation

Azure Queue Storage provides a simple cloud-based messaging mechanism for asynchronous communication between application components. One application can place messages into a queue, while another application retrieves and processes them. This helps decouple application components and allows processing workloads to operate independently. Queue Storage is useful when a producer and consumer do not need to communicate synchronously. Blob Storage stores objects, Azure Files provides shared file storage, and Azure Database for MySQL provides relational database capabilities. Therefore, Queue Storage is the most appropriate service for simple asynchronous message handling.

Question 240

Which Azure service provides a managed relational database compatible with the SQL Server database engine?

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

Correct Answer: 3

Explanation

Azure SQL Database is a fully managed relational database service based on the Microsoft SQL Server database engine. It supports standard relational database concepts such as tables, relationships, indexes, SQL queries, transactions, and constraints. Microsoft manages much of the underlying infrastructure, helping organizations reduce administrative responsibilities. Azure Cosmos DB is a NoSQL database service, Blob Storage provides object storage, and Queue Storage handles asynchronous messages. Azure SQL Database is therefore an appropriate choice when an application requires a managed relational database platform using SQL Server technologies.