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

 

Question 181

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

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

Correct Answer: 2

Explanation

Azure SQL Database is a fully managed relational database service based on the SQL Server database engine. It allows organizations to run relational database workloads without managing the underlying physical servers or operating system. Azure SQL Database supports SQL queries, tables, indexes, transactions, constraints, and relationships. It is commonly used by cloud applications that require a managed relational database platform. Azure Cosmos DB provides NoSQL capabilities, Table Storage provides non-relational entity storage, and Blob Storage is designed for object storage. Azure SQL Database is therefore appropriate for managed SQL Server-compatible relational workloads.

Question 182

Which type of data contains tags, keys, or metadata but does not require a rigid tabular schema?

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

Correct Answer: 3

Explanation

Semi-structured data contains organizational elements such as keys, tags, metadata, or field names but does not require a rigid relational table structure. JSON and XML are common examples. A JSON document can contain nested objects and arrays and may have different properties from another document. This flexibility makes semi-structured data useful for web APIs, application data, and many NoSQL workloads. Structured data follows a predefined schema, usually in tables and columns. Transactional data describes how data is used in a workload rather than how it is structurally organized.

Question 183

Which Azure service is designed for storing large amounts of data as objects?

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

Correct Answer: 1

Explanation

Azure Blob Storage is Microsoft’s object storage service for storing large amounts of unstructured data. It can store images, videos, documents, backups, logs, and other files as objects within containers. Blob Storage is designed for scalability and can support different access patterns through storage tiers. Azure SQL Database stores relational data, Queue Storage is used for messages, and Azure Files provides cloud-based file shares. When an application needs scalable object storage rather than a relational database or shared file system, Azure Blob Storage is an appropriate choice.

Question 184

Which SQL command is used to remove records from a relational database table?

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

Correct Answer: 4

Explanation

The DELETE statement is used to remove rows from a relational database table. A WHERE clause can be used to specify which records should be deleted. For example, an application might delete a customer record based on a specific CustomerID. Without an appropriate filtering condition, a DELETE operation can remove more records than intended, so it should be used carefully. SELECT retrieves records, INSERT adds new records, and UPDATE modifies existing records. These statements form part of the basic SQL data manipulation operations used in relational database systems.

Question 185

Which Azure service is primarily used to create data pipelines for moving and transforming data?

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

Correct Answer: 1

Explanation

Azure Data Factory is a cloud-based data integration service used to create pipelines for moving and transforming data. It can connect to many types of data sources and destinations, including databases, files, cloud services, and analytical platforms. Pipelines can contain activities that copy data, perform transformations, and coordinate processing workflows. Data Factory is commonly used for ETL and ELT scenarios. Azure Files provides file storage, Cosmos DB provides NoSQL database functionality, and Queue Storage handles asynchronous messages. Data Factory is therefore focused on data movement and orchestration.

Question 186

Which database model stores data as key-value pairs?

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

Correct Answer: 2

Explanation

A key-value database stores information as pairs consisting of a unique key and an associated value. Applications can use the key to quickly retrieve the corresponding value. This model is useful for simple, high-speed lookups and workloads such as caching, session storage, configuration information, and other scenarios where complex relationships are not required. Document databases store information as documents, graph databases focus on relationships, and relational databases organize information into tables. The key-value model is intentionally simple and can provide efficient access when the application’s primary operation is retrieving data using known keys.

Question 187

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

1. Azure Data Factory
2. Azure Stream Analytics
3. Azure Files
4. Azure Table Storage

Correct Answer: 2

Explanation

Azure Stream Analytics is a managed service designed to process and analyze streaming data in real time. It can continuously consume incoming events and perform operations such as filtering, aggregation, calculations, and pattern detection. Common use cases include IoT telemetry, application monitoring, fraud detection, and real-time dashboards. Unlike batch processing, streaming analytics can produce results while data is still arriving. Azure Data Factory focuses primarily on data integration, while Azure Files and Table Storage are storage services. Stream Analytics is therefore appropriate for workloads that require continuous event processing.

Question 188

Which database object can provide a virtual representation of data from one or more tables?

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

Correct Answer: 1

Explanation

A view is a database object based on a query that provides a virtual representation of data. A view can combine information from multiple tables, filter records, or expose only selected columns. Views can simplify complex queries and can also help control access to sensitive information by exposing only the required data. An index is used primarily to improve query performance, a primary key uniquely identifies rows, and a foreign key establishes relationships between tables. Views are especially useful when applications or reporting users need a consistent way to access selected database information.

Question 189

Which workload is optimized for frequent short transactions such as creating orders and updating customer records?

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

Correct Answer: 3

Explanation

OLTP stands for Online Transaction Processing and is designed for operational workloads involving frequent short transactions. Examples include creating orders, processing payments, updating customer details, and changing inventory quantities. OLTP systems are optimized for reliable inserts, updates, and deletes and typically emphasize transaction consistency and quick response times. OLAP is focused on analytical queries over large datasets, while data warehouses are generally used for analytical reporting. Batch analytics processes groups of data rather than individual operational transactions. Identifying the workload type helps determine the appropriate data platform.

Question 190

Which Azure service provides a globally distributed NoSQL database?

1. Azure SQL Database
2. Azure Cosmos DB
3. Azure Database for MySQL
4. Azure Files

Correct Answer: 2

Explanation

Azure Cosmos DB is a globally distributed NoSQL database service designed for scalable applications. It can replicate data across multiple Azure regions and provide low-latency access to users in different geographic locations. Cosmos DB supports multiple APIs and flexible data models, making it suitable for modern applications with varying data requirements. Typical scenarios include globally distributed web applications, IoT solutions, recommendation systems, and personalized applications. Azure SQL Database and Azure Database for MySQL are relational services, while Azure Files provides managed file shares rather than database functionality.

Question 191

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

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

Correct Answer: 1

Explanation

Atomicity ensures that a transaction is treated as one complete 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 in the database. For example, a transfer between two accounts should not complete only the withdrawal while failing to complete the deposit. Durability ensures committed changes survive failures, isolation controls concurrent transactions, and consistency maintains valid database rules. Atomicity is therefore essential for reliable transactional operations.

Question 192

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

1. Azure Cosmos DB
2. Azure Blob Storage
3. Azure Database for MySQL
4. Azure Queue 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 MySQL in Azure while Microsoft manages much of the underlying infrastructure. The service supports common relational database capabilities such as tables, SQL queries, indexes, relationships, and transactions. It is useful for web applications and business systems that depend on MySQL. Azure Cosmos DB is a NoSQL database, Blob Storage is object storage, and Queue Storage is designed for asynchronous messaging. Therefore, Azure Database for MySQL is the appropriate choice for managed MySQL workloads.

Question 193

Which data storage solution is best suited for a large collection of video files?

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

Correct Answer: 2

Explanation

Azure Blob Storage is designed for object storage and is well suited to large collections of video files. Videos are generally unstructured data and can be stored as blobs within containers. Blob Storage provides scalable capacity and supports different access tiers depending on how frequently content is accessed. Queue Storage is designed for messages, Table Storage provides NoSQL entity storage, and Azure SQL Database is a relational database service. Storing large media files in Blob Storage avoids forcing binary objects into a relational database and provides a storage model specifically designed for this type of content.

Question 194

Which SQL statement is used to modify existing records?

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

Correct Answer: 3

Explanation

The UPDATE statement modifies existing rows in a relational database. It can change one or more column values for records that meet a specified condition. For example, an application can update an order’s status or change a customer’s contact information. A WHERE clause is normally used to identify the records that should be changed. INSERT adds new records, SELECT retrieves information, and DELETE removes records. UPDATE is an important SQL operation in transactional applications because business information frequently changes after records have been created.

Question 195

Which Azure service provides cloud-based shared file storage?

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

Correct Answer: 1

Explanation

Azure Files provides managed cloud file shares that can be accessed by applications and users. It is useful for scenarios where multiple systems need access to common files or when organizations want to move traditional file-share workloads to Azure. Azure Files supports standard file-sharing protocols and provides a familiar file-system model. Cosmos DB is a NoSQL database, Queue Storage provides asynchronous messaging, and Synapse Analytics is focused on large-scale analytics. Therefore, Azure Files is the appropriate service when the requirement is shared cloud-based file storage.

Question 196

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

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

Correct Answer: 4

Explanation

ELT stands for Extract, Load, Transform. In this approach, data is extracted from source systems and loaded into the target platform before transformations are performed. Modern cloud data platforms can provide significant processing capabilities, making this approach practical for many analytical workloads. ETL performs transformations before loading the data. OLTP and OLAP describe workload types rather than data integration sequences. ELT can be useful when organizations want to preserve raw data in the target environment and perform transformations there according to different analytical requirements.

Question 197

Which type of database is most appropriate when an application needs to analyze relationships such as social connections?

1. Key-value
2. Document
3. Graph
4. Object storage

Correct Answer: 3

Explanation

A graph database is designed to represent and analyze relationships between entities. It uses nodes to represent entities and edges to represent relationships. This makes graph databases useful for social networks, recommendation systems, fraud detection, network management, and other scenarios where connections are central to the data. Key-value databases focus on direct access by keys, document databases store flexible documents, and object storage is designed for files rather than relational analysis. A graph model can make traversing complex relationships more natural and efficient for appropriate workloads.

Question 198

Which Azure service is designed for large-scale analytical queries and data warehousing?

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

Correct Answer: 1

Explanation

Azure Synapse Analytics is designed for large-scale data analytics and data warehousing workloads. It provides capabilities for querying and analyzing large datasets and can integrate with information from multiple data sources. Organizations can use Synapse to support reporting, business intelligence, historical analysis, and complex analytical queries. Azure Files provides file shares, Queue Storage handles asynchronous messages, and Azure Database for MySQL provides relational database functionality. Synapse is therefore appropriate when the primary requirement involves analyzing large volumes of data rather than handling routine operational transactions.

Question 199

Which constraint is used to ensure that a column cannot contain duplicate values?

1. DEFAULT
2. CHECK
3. UNIQUE
4. FOREIGN KEY

Correct Answer: 3

Explanation

The UNIQUE constraint ensures that values in a specified column or combination of columns cannot be duplicated. It is useful for attributes that must remain unique, such as an email address, employee number, or product code. A primary key also enforces uniqueness while serving as the main identifier for each row. DEFAULT provides a value when none is specified, CHECK enforces a condition, and a foreign key establishes a relationship between tables. Constraints are important because they allow database systems to enforce data integrity and business rules automatically.

Question 200

Which statement best describes a data warehouse?

1. A system designed primarily for analytical queries and reporting
2. A service used only for asynchronous messages
3. A storage system exclusively for video files
4. A database used only for application sessions

Correct Answer: 1

Explanation

A data warehouse is designed primarily for analytical queries, reporting, and business intelligence. It typically stores integrated and historical information collected from multiple operational sources. Data warehouses are optimized for activities such as aggregations, trend analysis, comparisons, and complex queries across large datasets. They are different from OLTP databases, which are optimized for frequent operational transactions. A data warehouse does not replace every operational system and is not limited to storing media or messages. It provides an analytical environment where organizations can examine historical business data and support decision-making.