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

 

Question 201

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

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

Correct Answer: 2

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 without managing the underlying database server infrastructure themselves. Applications can use standard SQL, tables, indexes, relationships, and transactions. The service is suitable for web applications, business applications, and other workloads that require PostgreSQL compatibility. Azure Cosmos DB is a NoSQL database, Blob Storage is object storage, and Queue Storage is designed for asynchronous messaging. Azure Database for PostgreSQL is therefore the appropriate service for managed PostgreSQL relational workloads.

Question 202

Which type of workload typically involves complex queries over large amounts of historical data?

1. OLTP
2. Transaction processing
3. OLAP
4. Message processing

Correct Answer: 3

Explanation

OLAP, or Online Analytical Processing, is designed for complex analysis of large datasets. Analytical workloads often involve aggregations, filtering, grouping, historical comparisons, and calculations across large amounts of information. Organizations commonly use OLAP systems for business intelligence, reporting, forecasting, and trend analysis. OLTP systems are instead optimized for frequent operational transactions such as inserting orders or updating customer records. Analytical platforms such as data warehouses are commonly designed to support OLAP workloads. Understanding the distinction between OLTP and OLAP is important when selecting an appropriate data platform.

Question 203

Which Azure Storage service is designed to store messages for asynchronous communication between application components?

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

Correct Answer: 1

Explanation

Azure Queue Storage provides cloud-based message queues that can be used for asynchronous communication between application components. One application can place messages into a queue while another application retrieves and processes them later. This approach can help separate application components and handle temporary differences in processing speed. Blob Storage is designed for objects such as files and media, Azure Files provides shared file storage, and Table Storage provides NoSQL key-attribute data storage. Queue Storage is therefore appropriate when an application needs simple, scalable asynchronous message handling.

Question 204

Which SQL statement is used to retrieve data from a table?

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

Correct Answer: 3

Explanation

The SELECT statement is used to retrieve data from one or more tables in a relational database. It can return specific columns, filter rows using WHERE conditions, sort results, group records, and combine information from multiple tables using joins. For example, an application can use SELECT to retrieve customer names and order details. INSERT adds new rows, UPDATE modifies existing rows, and DELETE removes rows. SELECT is one of the most frequently used SQL statements because applications and reporting systems commonly need to read information stored in relational databases.

Question 205

Which Azure service provides a NoSQL table-style data store using entities with properties?

1. Azure SQL Database
2. Azure Table Storage
3. Azure Files
4. Azure Data Factory

Correct Answer: 2

Explanation

Azure Table Storage is a NoSQL key-attribute data store designed for storing large amounts of structured non-relational data. Data is organized into tables containing entities, and each entity can contain properties. Unlike a traditional relational database, Table Storage does not require a fixed set of columns for every entity. It is useful for workloads that need scalable storage with simple access patterns based on keys. Azure SQL Database provides relational database capabilities, Azure Files provides file shares, and Azure Data Factory is used for data integration and pipelines.

Question 206

Which database component is primarily used to improve the speed of data retrieval?

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

Correct Answer: 2

Explanation

An index is a database structure designed to improve the performance of data retrieval operations. Instead of scanning every row in a table, the database can use an appropriate index to locate matching records more efficiently. Indexes are particularly useful for columns frequently used in filtering, joining, or sorting operations. However, indexes also consume storage and can add overhead to INSERT, UPDATE, and DELETE operations because the index may need to be maintained. Primary keys, foreign keys, and views serve different purposes and are not primarily designed as query-performance structures.

Question 207

Which Azure service is commonly used to build and manage data integration pipelines?

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

Correct Answer: 2

Explanation

Azure Data Factory is a cloud data integration service used to create and manage data pipelines. Pipelines can copy data between different systems, execute transformations, and coordinate data-processing activities. It can connect to many sources and destinations, making it useful when organizations need to bring data together for analytics or other processing. Data Factory can support both ETL and ELT workflows depending on where transformations are performed. Cosmos DB is a NoSQL database, Blob Storage is object storage, and Azure SQL Database is a relational database service.

Question 208

Which characteristic describes unstructured data?

1. It always uses fixed columns and rows
2. It requires a relational primary key
3. It has no predefined tabular schema
4. It can only contain numerical values

Correct Answer: 3

Explanation

Unstructured data does not follow a predefined tabular schema like a traditional relational database. Examples include photographs, videos, audio recordings, documents, and many types of free-form text. Although unstructured data may contain useful information and metadata, its internal structure is not necessarily organized into fixed rows and columns. Blob Storage is commonly used for storing this type of data. Structured data, by contrast, follows a defined schema. Semi-structured data falls between these categories because it contains organizational elements such as keys, tags, or metadata without requiring a rigid relational structure.

Question 209

Which Azure service is designed to analyze streaming data with low latency?

1. Azure Stream Analytics
2. Azure Files
3. Azure Database for MySQL
4. Azure Table Storage

Correct Answer: 1

Explanation

Azure Stream Analytics is designed to process and analyze streaming data in near real time. It can continuously process incoming events and perform filtering, aggregation, calculations, and other operations as the data arrives. Common scenarios include analyzing IoT telemetry, monitoring applications, detecting unusual activity, and creating real-time analytical outputs. This differs from traditional batch processing, where data is collected and processed as a group. Azure Files and Table Storage are storage services, while Azure Database for MySQL provides relational database functionality. Stream Analytics is specifically intended for continuous stream processing.

Question 210

Which ACID property ensures that committed transaction changes survive a system failure?

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

Correct Answer: 2

Explanation

Durability is the ACID property that ensures committed transaction changes remain stored even if a system failure occurs immediately afterward. Once a transaction has been successfully committed, the database system should preserve those changes. Atomicity ensures that a transaction is completed fully or not applied, isolation controls how concurrent transactions interact, and consistency ensures that database rules remain valid. Durability is especially important for systems such as financial applications, order processing, and inventory management because users need confidence that successfully committed operations will not simply disappear after a failure.

Question 211

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

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

Correct Answer: 3

Explanation

Azure Synapse Analytics is an analytics service designed for large-scale data warehousing and analytical workloads. It can bring together data integration, SQL-based analytics, and other analytical capabilities to support organizations working with large datasets. It is commonly associated with reporting, business intelligence, historical analysis, and complex queries. Azure Files is used for shared file storage, Queue Storage handles asynchronous messages, and Azure Database for PostgreSQL provides a managed relational database. When the primary requirement is large-scale analytics and data warehousing, Synapse Analytics is an appropriate Azure service.

Question 212

Which SQL operation adds new rows to a table?

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

Correct Answer: 3

Explanation

The INSERT statement is used to add new rows to a relational database table. An INSERT operation can provide values for selected columns or for all required columns in the table. For example, an application might use INSERT when a new customer creates an account. UPDATE is used to modify existing rows, DELETE removes rows, and SELECT retrieves information. INSERT is therefore an essential SQL data manipulation operation for applications that need to create new records. Database constraints may also be checked during insertion to ensure that the new data follows defined rules.

Question 213

Which data model is most suitable for storing JSON documents with varying structures?

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

Correct Answer: 1

Explanation

A document data model is well suited for storing JSON documents that may have varying structures. Each document can contain fields, nested objects, and arrays without requiring every document to follow exactly the same schema. This flexibility makes document databases useful for modern applications where data structures can evolve over time. A relational model generally organizes information into predefined tables and columns. Key-value databases focus primarily on pairs of keys and values, while graph databases emphasize relationships between entities. Document databases are therefore a natural choice for many JSON-based application workloads.

Question 214

Which Azure storage service provides a shared file system accessible by multiple machines?

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

Correct Answer: 3

Explanation

Azure Files provides managed cloud file shares that can be accessed by multiple machines and applications. It is useful when applications require a shared file-system experience rather than object storage or database storage. Organizations can use Azure Files for shared application files, configuration files, migration of traditional file-server workloads, and other scenarios requiring shared file access. Blob Storage is intended for object storage, Queue Storage handles messages, and Table Storage provides NoSQL entity storage. Azure Files is therefore the appropriate Azure Storage service when the requirement is shared file-system access.

Question 215

What is the primary purpose of a foreign key in a relational database?

1. To uniquely identify every row
2. To improve network speed
3. To establish a relationship between tables
4. To store large binary files

Correct Answer: 3

Explanation

A foreign key is used to establish a relationship between tables in a relational database. It generally references a primary key or another unique key in a related table. For example, an Orders table might contain a CustomerID foreign key that references the CustomerID primary key in a Customers table. This relationship helps maintain referential integrity and ensures that related records are logically connected. A primary key identifies rows within its own table, while Blob Storage is more appropriate for large binary files. Foreign keys are fundamental to relational database design.

Question 216

Which approach is commonly used to combine data from multiple sources, transform it, and then load it into a destination system?

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

Correct Answer: 1

Explanation

ETL stands for Extract, Transform, Load. In an ETL process, data is first extracted from one or more source systems, transformed into the required format or structure, and then loaded into the target system. Transformations can include filtering, cleansing, joining, aggregating, and converting data types. ETL is commonly used when data must be prepared before being stored in a data warehouse or analytical platform. OLTP and OLAP describe workload types, while ACID describes transactional properties. ETL specifically describes a data integration and transformation workflow.

Question 217

Which Azure service is optimized for globally distributed applications requiring a NoSQL database?

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

Correct Answer: 2

Explanation

Azure Cosmos DB is designed for globally distributed NoSQL applications that require scalable performance and low-latency access. It supports data distribution across Azure regions and provides multiple APIs for different application development scenarios. Cosmos DB can be used for applications such as globally available web platforms, IoT solutions, personalization systems, and other workloads with flexible data requirements. Azure SQL Database is a relational database service, Data Factory handles data integration, and Azure Files provides shared file storage. Cosmos DB is therefore appropriate when the workload requires globally distributed NoSQL capabilities.

Question 218

Which database design technique helps reduce unnecessary duplication of data?

1. Normalization
2. Indexing
3. Aggregation
4. Partitioning

Correct Answer: 1

Explanation

Normalization is a relational database design technique used to reduce unnecessary data duplication and improve data integrity. It involves organizing data into related tables and defining appropriate relationships between them. For example, instead of storing the same customer information repeatedly in every order record, customer details can be stored in a separate Customers table and referenced using a key. Indexing primarily improves query performance, aggregation combines data for analysis, and partitioning divides data into manageable sections. Normalization helps create a more consistent and maintainable relational database structure.

Question 219

Which type of processing collects data and processes it as a group rather than continuously as events arrive?

1. Stream processing
2. Real-time processing
3. Batch processing
4. Interactive processing

Correct Answer: 3

Explanation

Batch processing collects data and processes it as a group, usually at scheduled times or after a particular amount of data has accumulated. For example, an organization might process all sales transactions from the previous day during an overnight job. Batch processing is useful when immediate results are not required and large volumes of data can be handled together. Stream processing, by contrast, continuously processes events as they arrive and is suitable for real-time scenarios. Choosing between batch and stream processing depends on the workload’s latency and processing requirements.

Question 220

Which Azure service provides object storage that is commonly used for images, documents, backups, and media files?

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

Correct Answer: 2

Explanation

Azure Blob Storage provides scalable object storage for unstructured data such as images, documents, videos, backups, logs, and media files. Objects are stored within containers and can be accessed by applications through Azure-supported interfaces. Blob Storage supports different access tiers that can be selected based on access frequency and storage requirements. Azure SQL Database is a relational database service, Table Storage provides NoSQL entity storage, and Queue Storage is designed for asynchronous messages. Blob Storage is therefore the appropriate choice when an application needs scalable cloud-based object storage.