Microsoft DP-900 Exam Dumps & Practice Test Questions
Question 1
You are setting up a new Azure resource to store structured NoSQL data using Azure Table storage, which functions as a key-value store. What is the first Azure CLI command you need to execute?
A. az storage share create
B. az storage account create
C. az cosmosdb create
D. az storage container create
Correct Answer : B
Explanation:
The first command you need to execute when setting up Azure Table storage is az storage account create. This command is used to create an Azure Storage account, which is the foundational resource required for using Azure Table Storage. Once the storage account is created, you can create tables and containers within it for storing structured NoSQL data.
A. az storage share create - This command is used to create a file share in an Azure Storage account, typically used for Azure Files, not for Table storage.
C. az cosmosdb create - This command is used to create a Cosmos DB account, which is a globally distributed database service, not specifically related to Azure Table Storage. While Cosmos DB can support Table API, it is not the same as using Azure Table Storage.
D. az storage container create - This command is used to create a container in Azure Blob Storage, not for Azure Table Storage.
B. az storage account create is the correct command to create the necessary storage account for setting up Azure Table Storage.
Question 2
You need to enhance an existing SQL view by including an additional column. Which SQL command is suitable for this task?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE
Correct Answer : B
Explanation:
To enhance an existing SQL view by including an additional column, the appropriate command is ALTER. Specifically, ALTER VIEW is used to modify an existing view, such as adding or removing columns, changing the SQL logic, or updating the structure of the view.
A. MERGE - The MERGE statement is used for combining INSERT, UPDATE, and DELETE operations in a single statement, typically for handling changes between a source and target table. It is not used to modify views.
C. INSERT - The INSERT statement is used to add data into a table, not to modify the structure of a view.
D. UPDATE - The UPDATE statement is used to modify data within a table, not to modify the structure or definition of a view.
B. ALTER is the correct command because it allows you to modify the structure of an existing SQL view, such as adding a new column.
Question 3
Your solution requires a fully managed, scalable relational database service on Azure that minimizes infrastructure overhead. Which service should you use?
A. Azure SQL Database
B. SQL Server on Azure Virtual Machines
C. Azure SQL Managed Instance
D. Azure SQL Edge
Answer: A
Explanation:
Azure SQL Database is the fully managed, scalable relational database service on Azure that minimizes infrastructure overhead. It is a Platform-as-a-Service (PaaS) offering that automatically handles database maintenance tasks such as backups, patching, and scaling, which reduces the need for manual infrastructure management. It is ideal for applications that require a fully managed SQL database without the complexity of managing virtual machines or underlying infrastructure.
Option A, Azure SQL Database, provides automatic scaling, high availability, and built-in security, all while offering a simplified management experience compared to traditional on-premises SQL Server databases or VMs. It is the most efficient choice for minimizing infrastructure overhead.
Option B, SQL Server on Azure Virtual Machines, requires more management overhead because it involves managing the virtual machine and SQL Server installation. It is suitable for scenarios where you need full control over the SQL Server instance but comes with more infrastructure management responsibilities.
Option C, Azure SQL Managed Instance, is a fully managed SQL Server instance with more control over configuration and compatibility with on-premises SQL Server. While it offers more control than Azure SQL Database, it may involve additional management overhead compared to the simpler Azure SQL Database offering.
Option D, Azure SQL Edge, is a smaller, lightweight version of Azure SQL that is designed for edge computing environments, such as IoT devices. It is not meant for scalable, cloud-based relational database services.
Thus, the correct answer is A, Azure SQL Database.
Question 4
Which Azure storage offering provides built-in support for POSIX-style access control lists (ACLs), making it suitable for detailed file permissions and big data workloads?
A. Azure Table Storage
B. Azure Data Lake Storage
C. Azure Queue Storage
D. Azure Files
Answer: B
Explanation:
Azure Data Lake Storage (ADLS) provides built-in support for POSIX-style access control lists (ACLs), which allow for detailed file-level permissions, making it highly suitable for big data workloads. ADLS is built on top of Azure Blob Storage but offers additional features tailored for big data and analytics workloads, such as hierarchical namespace and fine-grained access control via ACLs.
Option B, Azure Data Lake Storage, is specifically designed for handling large-scale data with complex file structures and supports POSIX ACLs, which are critical for managing fine-grained access control in big data scenarios.
Option A, Azure Table Storage, is a NoSQL service designed for storing large amounts of unstructured data. It does not support file-level permissions or POSIX ACLs, making it unsuitable for detailed file permissions or big data workloads.
Option C, Azure Queue Storage, is a message queuing service and does not provide support for file storage or detailed ACLs. It is used for storing messages between application components, not for managing large datasets with file-level access control.
Option D, Azure Files, provides file shares over the cloud and supports SMB protocol. While it offers file-level permissions, it does not natively support POSIX ACLs for detailed access control, making it less suitable for advanced big data workloads compared to Azure Data Lake Storage.
Thus, the correct answer is B, Azure Data Lake Storage.
Question 5
Choose the best option to complete the following sentence:
Relational data is typically organized in:
A. a file system as unstructured data.
B. a hierarchical folder structure.
C. a tabular layout with rows and columns.
D. comma-separated value (CSV) files.
Correct Answer : C
Explanation:
Relational data is typically organized in a tabular layout with rows and columns. In relational databases, data is structured in tables (also known as relations), where each table is composed of rows (records) and columns (fields). Each row represents a unique data entry, and each column represents a specific attribute of the data. This tabular format is a hallmark of relational database systems and allows for efficient querying and management of structured data.
A. a file system as unstructured data - While data can be stored in a file system, relational data is not unstructured. Relational data is structured and follows a defined schema with rows and columns, making it different from unstructured data like text or images.
B. a hierarchical folder structure - A hierarchical folder structure is more commonly associated with file systems or object-oriented databases, not relational databases. Relational databases organize data into tables, not folders.
D. comma-separated value (CSV) files - CSV files are a common way to store tabular data, but they are not how relational data is primarily organized. CSV files can be a means to export or import data, but relational databases store data in tables, not as CSV files.
C. a tabular layout with rows and columns is the best option, as this is the structure in which relational data is organized.
Question 6
In a database, what do we call a saved block of code that executes specific operations such as inserting or retrieving data?
A. Stored Procedure
B. Table
C. View
D. Index
Correct Answer : A
Explanation:
A Stored Procedure is a saved block of code in a database that executes a set of SQL commands, typically for operations like inserting, updating, deleting, or retrieving data. Stored procedures are precompiled, which can improve performance by reducing the need to recompile the SQL code every time it is executed. They also provide reusability, security (by restricting direct access to underlying data), and help in managing complex operations that are frequently performed.
B. Table - A table is a basic structure in a database that stores data in rows and columns. It is not a block of code; rather, it is a data container.
C. View - A view is a virtual table that represents a query result. It does not store data but rather provides a way to query data from one or more tables in a specific manner. While views can be used to simplify complex queries, they are not blocks of code for executing operations like a stored procedure.
D. Index - An index is a database structure that improves the speed of data retrieval operations. It is not a block of code for performing operations; rather, it helps optimize query performance.
A. Stored Procedure is the correct answer because it is a saved block of code that executes specific operations in a database.
Question 7
What service model does Azure Database for PostgreSQL use, and how is it provided by Microsoft?
A. Platform as a Service (PaaS)
B. Infrastructure as a Service (IaaS)
C. Microsoft SQL Server
D. On-Premises Deployment
Answer: A
Explanation:
Azure Database for PostgreSQL is a Platform as a Service (PaaS) offering. This means that Microsoft manages the infrastructure, database server, and all underlying maintenance tasks like patching, backups, and scaling. As a PaaS, it allows users to focus purely on using and managing the PostgreSQL database without needing to worry about managing the physical servers or the operating system.
In the PaaS model, customers get a managed database service that provides high availability, scaling, and security out of the box. Microsoft ensures the availability, performance, and security of the underlying infrastructure while allowing customers to focus on application development.
Option B, Infrastructure as a Service (IaaS), would mean the customer is responsible for managing virtual machines and infrastructure, which is not the case with Azure Database for PostgreSQL.
Option C, Microsoft SQL Server, refers to another Microsoft database product and does not describe the PostgreSQL service model.
Option D, On-Premises Deployment, refers to when you install and manage the database server yourself, which is not the case with Azure Database for PostgreSQL.
Thus, the correct answer is A, Platform as a Service (PaaS).
Question 8
Which Azure storage solution enables file and folder-level permission control using ACLs?
A. Azure Data Lake Storage
B. Azure Queue Storage
C. Azure Blob Storage
D. Azure Cosmos DB
Answer: A
Explanation:
Azure Data Lake Storage (ADLS) enables file and folder-level permission control using Access Control Lists (ACLs). It is specifically designed for big data analytics workloads and provides a hierarchical namespace with support for managing fine-grained access controls on files and directories. The ACLs feature allows users to define detailed permissions at both the file and folder levels, making it ideal for managing access in complex data environments.
Option A, Azure Data Lake Storage, is the correct answer because it supports the hierarchical namespace and POSIX-style ACLs, which are essential for detailed file and folder-level permission control.
Option B, Azure Queue Storage, is a messaging service for storing messages between application components, and it does not support ACLs or file/folder-level permissions.
Option C, Azure Blob Storage, is an object storage service, and while it provides basic security and access control mechanisms like shared access signatures (SAS) and Azure Active Directory (AAD) integration, it does not natively support POSIX ACLs for managing file and folder-level permissions.
Option D, Azure Cosmos DB, is a globally distributed NoSQL database service, and it does not deal with file or folder-level permission control, as it is focused on storing and managing data in NoSQL format.
Thus, the correct answer is A, Azure Data Lake Storage.
Question 9
You are tasked with creating an Azure service to store large amounts of unstructured data (such as images and videos) with scalable storage. Which Azure storage service would you use?
A. Azure Blob Storage
B. Azure Table Storage
C. Azure Data Lake Storage
D. Azure Queue Storage
Correct Answer : A
Explanation:
The best Azure storage service for storing large amounts of unstructured data like images, videos, and other media files is Azure Blob Storage. Azure Blob Storage is designed for storing massive amounts of unstructured data and is highly scalable. It allows for efficient management and access to large binary or text files (blobs). This service is optimized for use cases such as media storage, backups, logs, and other unstructured data types.
B. Azure Table Storage - Azure Table Storage is used for storing structured NoSQL data in a key-value format, not suitable for large unstructured data like images or videos.
C. Azure Data Lake Storage - While Azure Data Lake Storage is designed for large-scale data storage, it is typically used for big data analytics and is more tailored to structured and semi-structured data, rather than serving as a general-purpose storage solution for unstructured media files.
D. Azure Queue Storage - Azure Queue Storage is designed for storing and managing messages between application components, not for storing unstructured data like images and videos.
A. Azure Blob Storage is the best choice as it is designed for scalable and efficient storage of unstructured data.
Question 10
Which of the following Azure database services provides automatic scalability and high availability, making it ideal for applications with unpredictable workloads?
A. Azure SQL Database
B. SQL Server on Azure Virtual Machines
C. Azure Cosmos DB
D. Azure Database for MySQL
Correct Answer : C
Explanation:
Azure Cosmos DB is the Azure database service that provides automatic scalability and high availability, making it ideal for applications with unpredictable workloads. Cosmos DB is a globally distributed, multi-model database designed for high performance, low latency, and the ability to scale automatically as application demands fluctuate. It supports multiple data models, including document, graph, key-value, and column-family, and automatically adjusts throughput and storage based on workload demands.
A. Azure SQL Database - While Azure SQL Database offers high availability and scalability, it does not provide the same level of flexibility in terms of automatic global distribution and low-latency performance across geographically distributed applications that Cosmos DB offers.
B. SQL Server on Azure Virtual Machines - Running SQL Server on Azure Virtual Machines offers high availability but requires manual management of scalability and infrastructure, which may not be ideal for applications with unpredictable workloads.
D. Azure Database for MySQL - Azure Database for MySQL is a fully managed database service but is more suited for MySQL-based applications. While it provides high availability and scalability, it does not have the global distribution and multi-model flexibility offered by Cosmos DB.
C. Azure Cosmos DB is the correct choice for applications requiring automatic scalability and high availability, especially for unpredictable and globally distributed workloads.
