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

 

Question 81

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

1. Azure Cosmos DB
2. Azure Database for PostgreSQL
3. Azure Table Storage
4. Azure Blob 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 databases in Azure without managing the underlying operating system, physical servers, or much of the database infrastructure. It supports relational tables, SQL queries, transactions, indexes, and relationships between data. This service is useful for applications that are already designed to use PostgreSQL or require PostgreSQL-specific capabilities. Azure Cosmos DB is a NoSQL service, while Blob Storage and Table Storage serve different storage requirements.

Question 82

Which Azure storage service is designed to provide shared file storage that can be accessed using standard file-sharing protocols?

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

Correct Answer: 1

Explanation

Azure Files provides fully managed file shares in the cloud. Applications and users can access these shares using standard file-sharing protocols such as SMB, making Azure Files useful for scenarios that require shared file storage. Organizations can use it to migrate file shares to Azure, provide shared application storage, or support applications that expect a traditional file system. Blob Storage is intended for object storage, Queue Storage is designed for messaging, and Table Storage provides NoSQL entity storage. Azure Files is therefore the appropriate choice when a cloud-based shared file system is required.

Question 83

Which type of data does JSON commonly represent?

1. Structured only
2. Semi-structured
3. Unstructured only
4. Binary-only

Correct Answer: 2

Explanation

JSON is commonly considered a semi-structured data format because it contains identifiable fields and values but does not require every record to follow a rigid relational table schema. JSON documents can contain nested objects, arrays, and optional properties. This flexibility makes JSON popular for web APIs, application data, configuration files, and NoSQL databases. A relational table with a predefined schema is an example of structured data, while files such as images and videos are generally unstructured. Semi-structured formats provide a useful balance between organization and flexibility.

Question 84

Which Azure service is designed for asynchronous message storage between application components?

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

Correct Answer: 3

Explanation

Azure Queue Storage provides cloud-based message storage that can help separate application components. A producer can place messages into a queue, and a consumer can process those messages later. This approach supports asynchronous processing and can help applications handle workloads where tasks do not need to be completed immediately. Queue Storage is commonly useful for background processing, task scheduling, and decoupling application components. It is different from Azure Files, which stores files, and Azure SQL Database, which stores relational data. Queue Storage focuses specifically on message-based communication.

Question 85

What is a foreign key primarily used for in a relational database?

1. Encrypting a table
2. Creating a backup
3. Linking related tables
4. Compressing database files

Correct Answer: 3

Explanation

A foreign key is used to establish a relationship between tables in a relational database. It typically contains values that reference the primary key of another 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 remain logically connected. Foreign keys do not perform encryption, compression, or backups. They are an important part of relational database design because they allow information to be distributed across related tables.

Question 86

Which Azure service is designed for storing unstructured objects such as documents, backups, and media files?

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

Correct Answer: 1

Explanation

Azure Blob Storage is an object storage service designed for large amounts of unstructured data. Common examples include documents, images, videos, backups, log files, and other media. Data is stored as blobs inside containers, allowing applications to organize and access objects efficiently. Blob Storage is highly scalable and can support different access patterns through storage tiers. It is not intended to provide relational database functionality. When an application needs scalable cloud storage for files and other objects rather than rows and columns, Azure Blob Storage is generally the appropriate option.

Question 87

Which database model uses a key to retrieve an associated value?

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

Correct Answer: 3

Explanation

A key-value database stores data as pairs consisting of a unique key and its associated value. Applications can use the key to quickly retrieve the corresponding value. This model is simple and can provide efficient access for workloads where records are primarily retrieved by known identifiers. The value may contain text, numbers, objects, or other information depending on the database system. Unlike relational databases, key-value stores generally do not depend on tables, joins, or complex relational schemas. The model is commonly used for caching, session information, and other simple high-speed access scenarios.

Question 88

Which Azure service can provide a managed MySQL database?

1. Azure Synapse Analytics
2. Azure Database for MySQL
3. Azure Files
4. Azure Data Factory

Correct Answer: 2

Explanation

Azure Database for MySQL is a managed relational database service based on the MySQL database engine. It allows developers to use MySQL databases in Azure while Microsoft manages much of the underlying infrastructure. The service supports common relational database concepts such as tables, SQL queries, indexes, and relationships. It can be used by web applications, business applications, and other workloads that require MySQL. Azure Data Factory is used for data integration, Azure Files provides file shares, and Synapse Analytics focuses on analytical workloads rather than being a managed MySQL database service.

Question 89

Which activity is an example of data transformation?

1. Changing a date format from MM/DD/YYYY to YYYY-MM-DD
2. Turning off a virtual machine
3. Creating a network
4. Assigning a user a role

Correct Answer: 1

Explanation

Data transformation involves changing data into a required format, structure, or representation. Converting a date from one format to another is a simple example of transformation. Other transformations can include changing data types, combining fields, calculating new values, removing duplicates, or standardizing text. Transformations are commonly performed as part of data integration and analytics pipelines. Azure Data Factory and other Azure data services can participate in data transformation workflows. The other options relate to infrastructure or access management rather than changing the contents or structure of data.

Question 90

Which Azure service is primarily used to visualize data and create interactive business reports?

1. Azure Queue Storage
2. Azure Files
3. Power BI
4. Azure Table Storage

Correct Answer: 3

Explanation

Power BI is a business analytics platform used to connect to data sources, create visualizations, build reports, and develop interactive dashboards. Organizations can use Power BI to analyze business information and communicate insights to users. Reports can include charts, tables, maps, filters, and other interactive visual elements. Power BI can connect to many Azure data services as well as external sources. Azure Queue Storage, Azure Files, and Azure Table Storage are data storage or messaging services and are not primarily designed for creating business intelligence reports.

Question 91

What does normalization primarily help reduce in a relational database?

1. Data redundancy
2. Network bandwidth
3. File encryption
4. User authentication

Correct Answer: 1

Explanation

Normalization is a relational database design technique that organizes data to reduce unnecessary duplication and improve data integrity. During normalization, information is commonly separated into related tables so that each piece of information is stored in an appropriate location. This can reduce update anomalies and inconsistencies caused by repeated data. For example, customer information can be stored in a Customers table while order information is maintained separately and linked using keys. Normalization does not primarily address encryption, authentication, or network bandwidth. It focuses on organizing relational data efficiently and consistently.

Question 92

Which Azure service is designed to analyze real-time streaming data?

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

Correct Answer: 2

Explanation

Azure Stream Analytics is a managed service designed to process and analyze streaming data in real time. It can consume data from streaming sources and perform operations such as filtering, aggregating, and detecting patterns before sending results to other destinations. Common scenarios include IoT telemetry, application monitoring, fraud detection, and real-time dashboards. Unlike batch-oriented data processing, streaming analytics continuously handles incoming events. Azure Data Factory is primarily focused on data integration and orchestration, while Azure Files and Azure SQL Database serve storage and relational database purposes respectively.

Question 93

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

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

Correct Answer: 3

Explanation

The SELECT statement is used to retrieve data from one or more tables in a relational database. A SELECT query can specify particular columns, filter rows using WHERE conditions, sort results, group records, and combine data from multiple tables using joins. For example, a query can retrieve all customers from a Customers table or calculate sales totals from an Orders table. INSERT adds new records, UPDATE modifies existing records, and DELETE removes records. SELECT is therefore the primary SQL statement used for querying and reading relational data.

Question 94

Which storage option is most suitable for a collection of large video files?

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

Correct Answer: 1

Explanation

Azure Blob Storage is well suited for storing large video files because it provides scalable object storage for unstructured data. Videos can be stored as blobs inside containers and accessed by applications when needed. Blob Storage is commonly used for media content, backups, documents, images, and other large objects. Azure Queue Storage is intended for messages, Table Storage stores NoSQL entities, and Azure SQL Database is a relational database service. Choosing Blob Storage for large media files avoids forcing unstructured binary content into a relational table structure unnecessarily.

Question 95

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

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

Correct Answer: 4

Explanation

Durability is the ACID property that ensures changes from a successfully committed transaction persist even if a system failure occurs afterward. Once a transaction has been committed, the database system takes measures to preserve those changes. Atomicity ensures that a transaction is treated as a complete unit, consistency maintains valid database rules, and isolation controls the interaction between concurrent transactions. Durability is especially important for financial and business systems where users expect completed transactions to remain recorded. Together, the ACID properties help provide reliable transactional database behavior.

Question 96

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

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

Correct Answer: 1

Explanation

Azure Cosmos DB is a fully managed NoSQL database service designed for scalable and globally distributed applications. It can distribute data across Azure regions and provide low-latency access for users in different geographic locations. Cosmos DB supports flexible data models and multiple APIs, making it useful for applications with varying data requirements. Common scenarios include web applications, IoT solutions, recommendation systems, and globally distributed services. Azure Files and Blob Storage provide storage capabilities, while Azure Data Factory focuses on moving and transforming data between systems.

Question 97

What is the main purpose of a data lake?

1. Store only relational tables
2. Store large amounts of raw data in various formats
3. Process only financial transactions
4. Replace all visualization tools

Correct Answer: 2

Explanation

A data lake is designed to store large amounts of data in its original or raw form. It can contain structured, semi-structured, and unstructured data such as relational records, JSON files, logs, images, videos, and other formats. This flexibility makes data lakes useful for data science, analytics, machine learning, and large-scale data processing. Data does not necessarily need to be transformed into a rigid schema before being stored. This differs from a traditional data warehouse, where data is generally organized and prepared for structured analytical querying.

Question 98

Which SQL command is used to add new rows to a table?

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

Correct Answer: 3

Explanation

The INSERT statement is used to add new rows to a relational database table. An INSERT statement can specify the target table and the values that should be stored in its columns. For example, an application can use INSERT to create a new customer record in a Customers table. SELECT retrieves data, UPDATE changes existing rows, and ALTER is used to modify database objects such as table structures. Understanding basic SQL commands is important for working with relational databases and developing applications that create, retrieve, modify, and manage data.

Question 99

Which Azure service is designed to provide a cloud-based relational database compatible with the SQL Server engine without requiring users to manage the underlying server infrastructure?

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

Correct Answer: 1

Explanation

Azure SQL Database is a fully managed relational database service based on the SQL Server database engine. Microsoft manages the underlying infrastructure, allowing organizations to focus on database development and application workloads rather than server maintenance. Azure SQL Database supports SQL queries, relational tables, indexes, transactions, and other database capabilities. It is commonly used for cloud applications that need a managed relational database. Unlike SQL Server running on an Azure virtual machine, users do not need to manage the operating system or virtual machine infrastructure themselves.

Question 100

Which statement best describes semi-structured data?

1. Data with no identifiable organization at all
2. Data stored exclusively in normalized relational tables
3. Data that contains organizational elements but does not require a rigid tabular schema
4. Data that can only contain numerical values

Correct Answer: 3

Explanation

Semi-structured data contains organizational elements such as fields, keys, tags, or metadata but does not require a rigid table-based schema. JSON and XML are common examples. A JSON document can contain different fields or nested structures between records while still providing meaningful organization. This flexibility is useful for applications where data structures can change over time. Structured data, such as relational tables, normally follows a predefined schema. Unstructured data, such as images and videos, does not naturally follow a predefined data structure. Semi-structured data sits between these two categories.