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

 

Question 361

Which Azure service is designed to store unstructured object data such as images and videos?

1. Azure Table Storage
2. Azure SQL Database
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. Examples include images, videos, documents, backups, logs, and other files. It organizes objects into containers and provides scalable cloud storage for applications. Unlike relational databases, Blob Storage does not require a fixed table schema for the stored objects. Azure Table Storage is a NoSQL entity store, Queue Storage handles messages, and Azure SQL Database provides relational database functionality. Therefore, Azure Blob Storage is the appropriate service when an application needs scalable storage for unstructured objects.

Question 362

Which Azure service provides a managed relational database compatible with PostgreSQL?

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

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 applications in Azure without having to manage all the underlying database infrastructure themselves. The service supports relational tables, SQL queries, indexes, constraints, and transactions. Azure Cosmos DB is a NoSQL database service, Blob Storage provides object storage, and Event Hubs is designed for event ingestion. Therefore, Azure Database for PostgreSQL is the appropriate Azure service for applications that require PostgreSQL-based relational database capabilities.

Question 363

Which SQL statement is used to retrieve records from a database table?

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

Correct Answer: 3

Explanation

The SELECT statement is used to retrieve data from relational database tables. It can return specific columns and rows and can include clauses such as WHERE, GROUP BY, ORDER BY, and JOIN. For example, SELECT can retrieve customer names, filter orders by date, or calculate totals using aggregate functions. INSERT adds new records, UPDATE changes existing records, and DELETE removes records. Therefore, SELECT is the correct SQL statement when the requirement is to read information from a database rather than modify the stored data.

Question 364

Which Azure service provides a globally distributed NoSQL database?

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

Correct Answer: 1

Explanation

Azure Cosmos DB is a globally distributed NoSQL database service designed for applications that require scalable performance and low-latency access. Data can be distributed across geographic regions, allowing applications to serve users from locations closer to where they are located. Cosmos DB supports flexible data models and is commonly used for modern web applications, IoT workloads, and globally distributed systems. Azure SQL Database provides relational database functionality, Azure Files provides shared file storage, and Data Factory handles data integration. Therefore, Azure Cosmos DB is the correct choice.

Question 365

Which ACID property ensures that concurrent transactions do not improperly interfere with one another?

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

Correct Answer: 4

Explanation

Isolation is the ACID property that controls how concurrent transactions interact with each other. It helps ensure that one transaction does not improperly see intermediate or uncommitted changes made by another transaction. This is important in systems where many users may access and modify data simultaneously. Atomicity ensures a transaction is completed completely or rolled back, consistency maintains database rules, and durability preserves committed changes. Isolation helps databases maintain predictable behavior when multiple transactions execute at the same time, making it essential for reliable transactional applications.

Question 366

Which Azure service is used to create and orchestrate data integration pipelines?

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

Correct Answer: 2

Explanation

Azure Data Factory is a cloud-based data integration service used to create, schedule, and manage data pipelines. Pipelines can move data between different sources and destinations and coordinate activities such as copying, transformation, and processing. It can be used in both ETL and ELT architectures and supports integration with many Azure and external data services. Azure Files provides shared file storage, Queue Storage provides messaging, and Table Storage provides NoSQL entity storage. Therefore, Azure Data Factory is the correct choice for orchestrating data integration workflows.

Question 367

Which data model represents entities as nodes and relationships as edges?

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

Correct Answer: 2

Explanation

A graph data model represents entities as nodes and relationships between entities as edges. This structure makes graph databases useful when relationships are an important part of the application’s data. Examples include social networks, recommendation systems, fraud detection, and network analysis. Document databases organize information as documents, key-value databases use pairs of keys and values, and relational databases organize information into tables. Graph databases can efficiently represent complex connections between entities. Therefore, the graph model is the correct choice for data centered around relationships.

Question 368

Which SQL clause is used to arrange query results in ascending or descending order?

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

Correct Answer: 3

Explanation

ORDER BY is the SQL clause used to sort query results. It can arrange records in ascending order using ASC or descending order using DESC. For example, a sales report can use ORDER BY to display products from highest to lowest sales. WHERE filters rows based on conditions, GROUP BY organizes rows into groups for aggregation, and JOIN combines data from multiple tables. ORDER BY is therefore the correct clause when the requirement is to control how returned records are arranged for users or reports.

Question 369

Which Azure storage service is designed for asynchronous message queuing?

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 messaging for asynchronous communication between application components. A producer can place messages into a queue, while a consumer can retrieve and process them later. This approach can help applications handle workloads at different speeds and reduce direct dependencies between components. Blob Storage is intended for objects, Azure Files provides shared file storage, and Table Storage stores NoSQL entities. Therefore, Azure Queue Storage is the appropriate choice when an application needs a simple queue for asynchronous messages.

Question 370

Which workload is primarily designed for business intelligence and historical analysis?

1. OLTP
2. OLAP
3. Message processing
4. File storage

Correct Answer: 2

Explanation

OLAP, or Online Analytical Processing, is designed for analytical workloads such as business intelligence, reporting, historical analysis, and complex aggregations. OLAP systems often work with large amounts of historical data and allow users to analyze trends and patterns. OLTP systems are optimized for day-to-day transactional operations such as inserting and updating records. Message processing and file storage are different types of workloads. Therefore, OLAP is the appropriate workload type when an organization needs to analyze historical data and support business intelligence activities.

Question 371

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

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

Correct Answer: 2

Explanation

Azure Event Hubs is a managed event ingestion service designed for high-throughput scenarios. It can receive large volumes of telemetry and event data from applications, IoT devices, monitoring systems, and other sources. The ingested data can then be processed by downstream services such as Azure Stream Analytics or stored for later analysis. Azure SQL Database and Azure Database for MySQL are relational database services, while Azure Files provides shared file storage. Therefore, Event Hubs is the appropriate choice for collecting large amounts of incoming event data.

Question 372

Which SQL statement modifies existing records in a table?

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

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 meet a specified condition. A WHERE clause is commonly included to ensure only the intended rows are changed. INSERT adds new records, SELECT retrieves records, and DELETE removes records. For example, an application can use UPDATE to change a customer’s address or modify a product’s price. Therefore, UPDATE is the correct SQL statement for changing values in existing database records.

Question 373

Which type of data does not follow a fixed relational table structure?

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

Correct Answer: 1

Explanation

Unstructured data does not follow a fixed relational table structure. Examples include images, videos, audio recordings, documents, and many types of free-form text. This data can still contain valuable information, but it does not naturally fit into predefined rows and columns. Structured data, such as relational database records, follows a defined schema. Semi-structured data, such as JSON and XML, has some organizational elements but remains more flexible than relational tables. Understanding these categories helps organizations select appropriate storage and processing technologies for different data types.

Question 374

Which Azure service is a managed relational database service based on MySQL?

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

Correct Answer: 3

Explanation

Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It allows applications to use familiar MySQL capabilities while Azure handles many infrastructure management tasks. Applications can work with tables, SQL queries, indexes, relationships, and transactions. Azure Database for PostgreSQL is based on PostgreSQL, Cosmos DB provides NoSQL capabilities, and Blob Storage provides object storage. Therefore, Azure Database for MySQL is the correct choice when an application specifically requires a managed MySQL relational database.

Question 375

Which SQL clause groups rows for aggregate calculations such as SUM and COUNT?

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

Correct Answer: 2

Explanation

The GROUP BY clause groups rows that have matching values in one or more columns. It is frequently used with aggregate functions such as SUM, COUNT, AVG, MIN, and MAX. For example, a sales report can group transactions by product category and calculate total sales for each category. WHERE filters individual rows before grouping, ORDER BY sorts the final results, and JOIN combines related tables. Therefore, GROUP BY is the appropriate SQL clause when the requirement is to create groups for aggregate calculations.

Question 376

Which Azure service provides shared file storage accessible through standard file protocols?

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 virtual machines. It is designed for workloads that need shared file-system functionality and can support scenarios such as application configuration, shared documents, and migration from traditional file servers. Blob Storage is designed for object storage, Queue Storage is intended for asynchronous messages, and Event Hubs handles high-volume event ingestion. Therefore, Azure Files is the correct choice when applications require shared cloud-based file storage rather than object, message, or event storage.

Question 377

Which Azure service provides managed data warehousing and analytical capabilities?

1. Azure Queue Storage
2. Azure Cosmos DB
3. Azure Synapse Analytics
4. Azure Files

Correct Answer: 3

Explanation

Azure Synapse Analytics provides capabilities for large-scale analytics and data warehousing. It can be used to analyze data from multiple sources and support reporting, business intelligence, and complex analytical workloads. Synapse is designed for scenarios where organizations need to work with significant volumes of data and perform analytical queries. Queue Storage provides messaging, Cosmos DB is a NoSQL database service, and Azure Files provides shared file storage. Therefore, Azure Synapse Analytics is the appropriate Azure service for data warehousing and enterprise analytical workloads.

Question 378

Which concept describes data that has some organizational structure but does not require a rigid schema?

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

Correct Answer: 2

Explanation

Semi-structured data contains organizational elements such as fields, tags, keys, or attributes but does not necessarily follow a rigid relational schema. JSON and XML are common examples. A JSON document can contain different fields or nested structures in different records while still maintaining recognizable organization. Structured data generally follows a predefined schema, such as a relational table. Unstructured data, such as images and videos, does not have this type of inherent organization. Therefore, semi-structured data provides a flexible middle ground between structured and unstructured information.

Question 379

Which Azure service is designed for processing streaming data with near real-time results?

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

Correct Answer: 2

Explanation

Azure Stream Analytics is a managed service for processing and analyzing streaming data in real time or near real time. It can continuously process incoming events and perform operations such as filtering, grouping, aggregation, and calculations. It is commonly used for IoT telemetry, real-time dashboards, monitoring, and event-based applications. Azure Data Factory focuses on data integration pipelines, SQL Database provides relational storage, and Azure Files provides file shares. Therefore, Azure Stream Analytics is the appropriate service for continuous processing of streaming information.

Question 380

Which process extracts data, transforms it before loading, and then stores it in a target system?

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

Correct Answer: 3

Explanation

ETL stands for Extract, Transform, Load. In an ETL workflow, data is extracted from one or more source systems, transformed according to business or analytical requirements, and then loaded into a target system. Transformations may include cleaning, filtering, joining, formatting, and aggregation. ELT differs because the data is loaded into the target platform before transformation is performed there. OLTP and OLAP describe workload types rather than data integration processes. Therefore, ETL is the correct answer for a workflow that transforms data before loading it into the destination.