73 free Microsoft DP-900 practice questions from the CertStash pack of 323, each with the correct answer and a full explanation. The rule is the same for every exam: ten free on the product page, 73 free here, all 323 in the pack, and each step includes the one before it.
Get all 323 questions (US$39) · Download the first 10 as a PDF · Read the study guide
Question 1
You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, D. read-access geo-redundant storage (RA-GRS); geo-redundant storage (GRS)
Geo-redundant storage (GRS) and read-access geo-redundant storage (RA-GRS) both replicate data outside the Azure region automatically. GRS replicates to a secondary region asynchronously, while RA-GRS provides the same replication plus read access to the secondary region. Zone-redundant storage (ZRS) replicates only within a single region across availability zones, and locally-redundant storage (LRS) replicates only within a single datacenter, so neither meets the requirement of replicating outside the region.
Why the other options are wrong
- A. ZRS replicates across availability zones within a single region, not outside the region.
- C. LRS replicates only within a single datacenter and does not provide geo-replication.
Question 2
Which statement is an example of Data Manipulation Language (DML)?
Show answer and explanation
Correct answer: C. INSERT
INSERT is a Data Manipulation Language (DML) statement used to add new rows of data to a table. DML statements modify data within the database. REVOKE and GRANT are Data Control Language (DCL) statements for managing permissions, and DISABLE is not a standard SQL statement.
Why the other options are wrong
- A. REVOKE is a Data Control Language (DCL) statement for revoking permissions, not DML.
- B. DISABLE is not a standard SQL DML statement.
- D. GRANT is a Data Control Language (DCL) statement for granting permissions, not DML.
Question 3
You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?
Show answer and explanation
Correct answer: B. a view
A view is a database object that stores a predefined SQL query, allowing other users to rerun the same query without needing to write it themselves. Views can include calculated columns and combine data from multiple tables. An index improves query performance but does not store queries, a scalar function returns a single value but is not designed for sharing complex queries, and a table stores data but not query logic.
Why the other options are wrong
- A. An index optimizes query performance but does not store the query logic itself.
- C. A scalar function returns a single value and is not the appropriate object for storing multi-row query results.
- D. A table stores data but does not encapsulate the query logic needed to combine and calculate data.
Question 4
What are two characteristics of real-time data processing? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, D. Low latency is expected; Data is processed as it is created
Real-time data processing is characterized by low latency and the processing of data as it is created. Data arrives continuously and must be processed immediately or near-immediately to provide timely insights. Periodic processing and high latency are characteristics of batch processing, not real-time processing.
Why the other options are wrong
- A. Real-time processing handles data continuously, not periodically.
- C. Real-time processing requires low latency, not high latency.
Question 5
Which statement is an example of Data Manipulation Language (DML)?
Show answer and explanation
Correct answer: D. UPDATE
UPDATE is a Data Manipulation Language (DML) statement used to modify existing data in a table. DML statements are used to insert, update, delete, and retrieve data. REVOKE is a Data Control Language (DCL) statement, CREATE is a Data Definition Language (DDL) statement, and DISABLE is not a standard SQL statement.
Why the other options are wrong
- A. REVOKE is a Data Control Language (DCL) statement for managing permissions.
- B. DISABLE is not a standard SQL DML statement.
- C. CREATE is a Data Definition Language (DDL) statement for creating database objects.
Question 6
You have the following data. Which type of data is this?
Show answer and explanation
Correct answer: B. semi-structured
This data is JSON (JavaScript Object Notation), which is a semi-structured format. Semi-structured data has some organizational properties and schema elements (keys defining the structure) but lacks the rigid, fully-defined schema of structured data like relational databases. The data exhibits characteristics of semi-structured formats: it uses consistent key-value pairs and nested objects that provide partial organization, but the structure is self-describing through the format itself rather than enforced by a strict database schema. This makes it more organized than unstructured data (like plain text or images) but less rigid than fully structured data.
Why the other options are wrong
- A. Unstructured data lacks organizational properties and schema entirely, such as plain text documents or images; JSON has clear structural organization through key-value pairs.
- C. Structured data requires a predefined, rigid schema enforced by a database management system; JSON's flexibility and self-describing nature make it semi-structured rather than fully structured.
Question 7
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
Show answer and explanation
Correct answer: B. az storage account create
To create an Azure resource for storing data in Azure Table storage, you must first create a storage account using 'az storage account create'. Table storage is a service within a storage account. While 'az storage container create' creates a blob container (for blob storage) and 'az cosmosdb create' creates a Cosmos database, and 'az storage share create' creates a file share, none of these commands directly provision Table storage. The storage account must exist first.
Why the other options are wrong
- A. This command creates a file share, not Table storage.
- C. This command creates a Cosmos DB resource, which is a different service from Table storage.
- D. This command creates a blob container, not Table storage.
Question 8
You need to modify a view in a relational database by adding a new column. Which statement should you use?
Show answer and explanation
Correct answer: B. ALTER
The ALTER statement is used to modify existing database objects, including views. To add a new column to a view definition, you use ALTER VIEW. MERGE is used to perform insert, update, or delete operations based on source and target conditions, INSERT adds new rows, and UPDATE modifies existing row data, none of these modify the structure of a view itself.
Why the other options are wrong
- A. MERGE is used for conditional insert, update, or delete operations, not for modifying view structure.
- C. INSERT adds new data rows but does not modify the view definition.
- D. UPDATE modifies data values but does not alter the view structure or definition.
Question 9
You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling. Which service should you implement?
Show answer and explanation
Correct answer: A. Azure SQL Database
Azure SQL Database is a Platform as a Service (PaaS) offering that includes built-in autoscaling capabilities, allowing the database to automatically adjust compute and storage resources based on demand. SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) solution requiring manual scaling, Azure SQL Managed Instance is a hybrid offering with limited autoscaling, and Azure SQL Edge is designed for edge computing scenarios without comprehensive autoscaling support.
Why the other options are wrong
- B. SQL Server on Virtual Machines is IaaS, not PaaS, and requires manual management of scaling.
- C. Azure SQL Managed Instance does not provide the same level of built-in autoscaling as Azure SQL Database.
- D. Azure SQL Edge is designed for edge and embedded scenarios, not for PaaS relational database workloads with autoscaling.
Question 10
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
Show answer and explanation
Correct answer: B. Azure Data Lake Storage
Azure Data Lake Storage provides native support for POSIX-compliant access control lists (ACLs) at both the file and directory level, enabling fine-grained permission management. This is a key feature that distinguishes Data Lake Storage from other Azure storage solutions and makes it suitable for big data analytics workloads requiring advanced security controls.
Why the other options are wrong
- A. Azure Table storage is a NoSQL key-value store and does not support POSIX-compliant ACLs.
- C. Azure Queue storage is designed for message queuing and does not support file-level ACLs.
- D. Azure Files supports SMB and NFS protocols but does not provide POSIX-compliant ACLs at the same level as Data Lake Storage.
What people say about the full DP-900 pack 5.0 from 10
I passed the DP-900 exam with the help of Certstash Great Dumps. I scored almost 900 marks in the Microsoft Certified: Azure Data Fundamentals certification. All credits go to this website, you should give this certification dumps a try.
Certstash surely changed my perspective regarding the authenticity of the dumps. Your content within the dumps is so original and helped me so well. I am so grateful for you guys!
For anyone beginning their Azure certification journey these dumps are a priceless resource. Highly recommended for everyone
Question 11
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Show answer and explanation
Correct answer: B. WHERE
The WHERE clause is used to filter data based on conditions that can leverage indexes to avoid full table scans. When WHERE clauses reference indexed columns, the database management system uses the index to locate matching rows efficiently rather than scanning every row in the table.
Why the other options are wrong
- A. SELECT specifies which columns to retrieve but does not instruct the DBMS to use an index.
- C. JOIN combines tables but does not directly instruct the DBMS to use an index over a full table scan.
Question 12
Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, B. report and dashboard creation; report sharing and distribution
Report and dashboard creation can be performed entirely within the Power BI service, including creating visualizations from existing datasets and arranging them into interactive reports and dashboards. Report sharing and distribution are also native service functions. Data modeling and acquisition require Power BI Desktop or alternative tools.
Why the other options are wrong
- C. Data modeling typically requires Power BI Desktop for advanced modeling tasks, though basic modeling can occur in the service.
- D. Data acquisition and preparation require Power BI Desktop or external tools; the service consumes already-prepared data sources.
Question 13
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use?
Show answer and explanation
Correct answer: C. document
Document stores are designed for high-volume JSON data with flexible, application-defined schemas. They store semi-structured data natively and allow schema variation across documents, making them ideal for scenarios where the data structure is defined by the application rather than enforced by the database.
Why the other options are wrong
- A. Columnar stores are optimized for analytical queries on fixed schemas, not flexible JSON data.
- B. Key/value stores lack the ability to query within the document structure that JSON data requires.
- D. Graph databases are optimized for relationship traversal, not storing large volumes of JSON documents.
Question 14
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data store should you use?
Show answer and explanation
Correct answer: A. graph
Graph databases are designed to model and visualize relationships between entities. Network device utilization levels and their interconnected relationships are best represented as nodes (devices) and edges (relationships), making a graph database ideal for this scenario.
Why the other options are wrong
- B. Key/value stores lack the relationship modeling capabilities needed to show how device utilization levels interconnect.
- C. Document stores organize self-contained entities rather than emphasizing relationships between network devices.
- D. Columnar databases are optimized for analytical aggregations on large datasets, not for illustrating entity relationships.
Question 15
You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down. What should you use in Microsoft Power BI?
Show answer and explanation
Correct answer: B. a report
A Power BI report provides an interactive graphical interface that depicts key performance indicators and supports drill-down data exploration. Reports combine visualizations, interactivity, and analytical capability to enable executives to explore data and gain insights.
Why the other options are wrong
- A. A view is a database object, not a Power BI component for interactive visualization and exploration.
- C. A dataflow is used for data preparation and transformation, not for presenting interactive analytics to executives.
- D. Power Apps is used for building custom business applications, not for creating analytical reports and dashboards.
Question 16
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
Show answer and explanation
Correct answer: D. supports a multi-master model
Azure Cosmos DB Table API supports multi-master replication, allowing writes across multiple regions simultaneously. Azure Table storage does not support multi-master capabilities, making this a key differentiating benefit of Cosmos DB.
Why the other options are wrong
- A. Azure Table storage also supports region failover through geo-redundancy; this is not unique to Cosmos DB Table API.
- B. Both Azure Table storage and Cosmos DB Table API support partitioning; this is not a distinguishing feature.
- C. Storage capacity differences are not a primary architectural benefit of Cosmos DB Table API over Table storage.
Question 17
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?
Show answer and explanation
Correct answer: B. Azure Data Studio
Azure Data Studio is a lightweight, cross-platform tool that supports SQL notebooks, allowing users to embed markdown documentation, SQL queries, and results together in a single interactive notebook. This makes it ideal for creating troubleshooting guides and query documentation.
Why the other options are wrong
- A. SQL Server Management Studio (SSMS) does not support notebook functionality for embedding documents with queries.
- C. Azure CLI is a command-line interface and does not support interactive notebook creation with embedded documentation.
- D. Azure PowerShell is for infrastructure automation and does not provide SQL notebook capabilities.
Question 18
You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?
Show answer and explanation
Correct answer: A. Azure Files
Azure Files provides SMB protocol support that allows Windows applications to mount network shares as mapped drives. This is the only Azure service listed that supports the standard Windows file-sharing protocols required for mapped drive functionality.
Why the other options are wrong
- B. Azure Blob Storage is object storage without mapped drive support.
- C. Azure Cosmos DB is a NoSQL database, not a file storage service.
- D. Azure Table Storage is for structured key-value data, not file-based mapped drives.
Question 19
You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
Show answer and explanation
Correct answer: C. UPDATE
The UPDATE statement is used to modify existing records in a table. To change the inventory quantity of Product1 from 100 to 270, you use UPDATE with a SET clause to specify the new value and a WHERE clause to identify which row to modify. The correct syntax would be: UPDATE table_name SET Quantity = 270 WHERE ProductName = 'Product1'.
Why the other options are wrong
- A. INSERT is used to add new records to a table, not to modify existing values.
- B. MERGE is used to perform conditional insert, update, or delete operations based on matching conditions, which is more complex than needed for a simple value change.
- D. CREATE is used to create new database objects like tables or schemas, not to modify existing data.
Question 20
Your company is designing a data store that will contain student data. The data has the following format. Which type of data store should you use?
Show answer and explanation
Correct answer: D. columnar
The student data exhibits a tabular structure with rows (student records) and columns (StudentNumber and StudentInformation fields). The data contains heterogeneous attributes within each student record, including names, email addresses, phone numbers, and IDs. Columnar data stores are optimized for storing and querying data organized in columns, making them ideal for structured tabular data with mixed attribute types where you may need to access specific fields across many records efficiently.
Why the other options are wrong
- A. Graph databases are designed for data with complex relationships and connections between entities, not for structured tabular student records.
- B. Key/value stores are simple lookup structures lacking the schema and structure needed to organize multiple typed fields per student record.
- C. Object stores are designed for unstructured binary data like images and documents, not for structured relational student information.
Question 21
When can you use an Azure Resource Manager template?
Show answer and explanation
Correct answer: A. to automate the creation of an interdependent group of Azure resources in a repeatable way
Azure Resource Manager templates enable Infrastructure as Code by automating the creation of interdependent groups of Azure resources in a repeatable and idempotent way. Templates define resource configurations declaratively, allowing consistent deployments across environments and making resource management scalable and maintainable.
Why the other options are wrong
- B. Azure Policy, not ARM templates, is the service used to apply policies for compliance and governance across subscriptions.
- C. Subscriptions are provisioned through the Azure portal or partner channels, not through Resource Manager templates.
- D. Role-based access control and service/feature restrictions are managed through RBAC and Azure Policy, not through ARM templates.
Question 22
Which setting can only be configured during the creation of an Azure Cosmos DB account?
Show answer and explanation
Correct answer: D. API
The API selection (SQL, MongoDB, Cassandra, Table, or Gremlin) must be chosen during account creation and cannot be changed afterward. All other settings including geo-redundancy, multi-region writes, and account type can be modified after creation.
Why the other options are wrong
- A. Geo-redundancy can be configured or modified at any time after account creation.
- B. Multi-region writes can be enabled or disabled after the account is created.
- C. Production or non-production designation can be changed after account creation.
Question 23
What is a characteristic of batch processing?
Show answer and explanation
Correct answer: C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
Batch processing inherently involves a time delay between when data is ingested and when results are obtained, as data is collected and processed together in groups rather than immediately upon arrival. This is a defining characteristic that distinguishes batch processing from stream processing or real-time processing.
Why the other options are wrong
- A. Batch processing specifically does not require immediate processing upon data receipt; data is accumulated before processing begins.
- B. There is no 1 GB size limit requirement for batches; batch sizes are determined by business logic and system requirements.
- D. Batch processing can handle both structured and unstructured data, so this is not a limitation.
Question 24
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, D. access to the latest features; reduced administrative effort for managing the server infrastructure
PaaS relational databases like Azure SQL Database provide access to the latest features through automatic updates without customer involvement, and they significantly reduce administrative effort by handling infrastructure management, patching, backups, and high availability automatically. Customers focus on application logic rather than server maintenance.
Why the other options are wrong
- B. While PaaS services handle backups, customers have limited control over backup and restore processes compared to IaaS; this is a limitation, not a benefit.
- C. In-database machine learning services are a specific feature, not a universal benefit of all PaaS relational databases, and may not apply to all scenarios.
Question 25
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
Show answer and explanation
Correct answer: B. Azure SQL Database
Azure SQL Database is a fully managed PaaS relational database service that minimizes ongoing maintenance by handling patching, backups, high availability, and scaling automatically. This is the ideal choice for companies seeking a relational database without operational overhead.
Why the other options are wrong
- A. Azure HDInsight is for big data processing and analytics, not a traditional relational database management system.
- C. Azure Cosmos DB is a NoSQL database, not a relational database solution.
- D. SQL Server on Azure Virtual Machines requires significant manual maintenance including patching, backups, and configuration management.
Question 26
Which storage solution supports access control lists (ACLs) at the file and folder level?
Show answer and explanation
Correct answer: A. Azure Data Lake Storage
Azure Data Lake Storage supports access control lists (ACLs) at both the file and folder level, providing granular permissions management. This hierarchical ACL support is essential for data governance and security in analytics scenarios.
Why the other options are wrong
- B. Azure Queue storage is a message queuing service and does not support file or folder-level ACLs.
- C. Azure Blob storage supports role-based access control (RBAC) but not traditional file and folder-level ACLs like Data Lake Storage.
- D. Azure Cosmos DB is a NoSQL database and does not support file and folder-level ACLs.
Question 27
Which type of database is Azure Database for PostgreSQL?
Show answer and explanation
Correct answer: A. Platform as a service (PaaS)
Azure Database for PostgreSQL is a Platform as a Service (PaaS) offering, meaning Microsoft manages the infrastructure, operating system, and database software, while customers focus only on data and application configuration. This eliminates the need for manual patching, backups, and maintenance tasks.
Why the other options are wrong
- B. Infrastructure as a Service involves managing VMs and infrastructure yourself, which is not the case with Azure Database for PostgreSQL.
- C. Azure Database for PostgreSQL is a PostgreSQL service, not Microsoft SQL Server.
- D. Azure Database for PostgreSQL is a cloud-hosted service, not an on-premises solution.
Question 28
A team of developers has computers that run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense. What should the developers use?
Show answer and explanation
Correct answer: C. Azure Data Studio
Azure Data Studio is a cross-platform tool that runs on Windows 10, Ubuntu Desktop, and macOS. It supports connections to Azure SQL databases and provides code assistance features like IntelliSense. SSMS is Windows-only, sqlcmd lacks GUI and IntelliSense features, and Azure Data Explorer is for analytics rather than database querying.
Why the other options are wrong
- A. sqlcmd is a command-line utility without graphical interface or IntelliSense support.
- B. SQL Server Management Studio runs only on Windows, not on Ubuntu Desktop.
- D. Azure Data Explorer is designed for analytics and big data queries, not for connecting to Azure SQL databases.
Question 29
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?
Show answer and explanation
Correct answer: A. Microsoft SQL Server Data Tools (SSDT)
Microsoft SQL Server Data Tools (SSDT) is a graphical design tool that supports project-oriented offline database development, allowing developers to design and model databases in a project structure. SSMS is primarily a query and administration tool, Azure Databricks is for analytics, and Azure Data Studio is for querying rather than design.
Why the other options are wrong
- B. SQL Server Management Studio is for querying and administration, not database design and modeling.
- C. Azure Databricks is an analytics platform, not a database design tool.
- D. Azure Data Studio is primarily for querying databases, not designing them.
Question 30
You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, C, E. You must have SELECT access to the Products table; You must have a user in the database; Your IP address must be allowed to connect to the database.
To query the Products table from the internet, three requirements must be met: you must have a user created in the database (C), you must have SELECT permissions on the Products table (B), and your IP address must be allowed through the firewall rules (E). The Reader role (A) is not sufficient for database access; you need database-level permissions. The Contributor role (D) is unnecessary when you only need query permissions.
Why the other options are wrong
- A. Reader role only provides access to view Azure resource properties, not to query database contents.
- D. Contributor role is unnecessarily high-privileged when query access is all that is needed.
Question 31
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
Show answer and explanation
Correct answer: A. document
Document databases are specifically designed to store data as JSON (or similar semi-structured formats) with flexible schemas, where all data for an entity is stored together in a single document. This matches all three criteria in the question perfectly.
Why the other options are wrong
- B. Columnar stores organize data by column rather than by document, and are optimized for analytical queries on specific columns.
- C. Graph databases store data as nodes and edges to represent relationships, not as JSON documents.
- D. Time series databases are optimized for timestamped data points, not flexible schema JSON documents.
Question 32
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
Show answer and explanation
Correct answer: A. atomicity
Atomicity is the ACID property that guarantees each transaction is treated as a single indivisible unit, it either completes entirely and succeeds, or fails completely with no partial results. This all-or-nothing approach prevents data inconsistencies from incomplete transactions.
Why the other options are wrong
- B. Isolation ensures transactions do not interfere with each other, not that they succeed or fail completely.
- C. Durability ensures committed data persists after a transaction completes, not that transactions are all-or-nothing.
- D. Consistency ensures the database moves from one valid state to another, not that transactions are treated as single units.
Question 33
Which type of database contains nodes and edges?
Show answer and explanation
Correct answer: A. graph
A graph database is specifically designed to store and query data organized as nodes and edges, representing entities and their relationships. Graph databases excel at traversing complex relationship networks and are used for social networks, recommendation systems, and knowledge graphs.
Why the other options are wrong
- B. Key/value databases store simple key-value pairs without explicit node and edge structures.
- C. Columnar databases organize data by columns for analytical queries, not by nodes and edges.
- D. Time series databases are optimized for time-stamped data points, not graph structures with nodes and edges.
Question 34
What are two uses of data visualization? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, C. Represent trends and patterns over time; Communicate the significance of data
Data visualization serves to represent trends and patterns over time by making temporal changes visible and easy to understand, and to communicate the significance of data by presenting information in a way that stakeholders can quickly grasp meaning and insights. These are core purposes of effective data visualization.
Why the other options are wrong
- B. Machine learning implementation is a data science technique, not a primary use of data visualization itself.
- D. Enforcing business logic is typically done through data governance, access controls, and application logic rather than visualization.
Question 35
You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact. What should you do on the dedicated SQL pool?
Show answer and explanation
Correct answer: B. Pause the pool.
Pausing a dedicated SQL pool is the optimal solution for minimizing costs during idle times. When paused, you stop incurring compute charges while all data remains fully intact and recoverable. This is specifically designed for scenarios where resources are only needed during specific hours.
Why the other options are wrong
- A. Scaling down DWUs reduces performance but still incurs compute charges; pausing eliminates charges entirely.
- C. Creating a restore point does not reduce costs and is used for data recovery purposes only.
- D. Deleting the pool would require recreating it, losing data and requiring redeployment.
Question 36
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, C, E. a report page; a visualization from a report; a text box
Power BI dashboards can contain report pages, visualizations from reports, and text boxes. Report pages can be pinned to dashboards as tiles, visualizations (charts, tables, etc.) from any report can be pinned as dashboard tiles, and text boxes allow you to add descriptive or contextual text. These three object types are the primary components you can add to customize a dashboard.
Why the other options are wrong
- B. PowerPoint slides cannot be directly added to Power BI dashboards; Power BI and PowerPoint are separate Microsoft applications with different purposes.
- D. Dataflows are data preparation and transformation tools in Power BI but cannot be added as objects to a dashboard itself.
Question 37
When you create an Azure SQL database, which account can always connect to the database?
Show answer and explanation
Correct answer: B. the server admin login account of the logical server
The server admin login account (also called the server administrator) is the account created during logical server provisioning and always has permission to connect to any database on that server. This is the guaranteed access point regardless of Azure AD configuration or other authentication methods.
Why the other options are wrong
- A. The Azure AD account that created the database may have limited permissions and may not always have direct connection rights depending on role assignments.
- C. The Azure AD administrator account requires proper Azure AD setup and configuration; it is not guaranteed to always connect without additional setup.
- D. The sa account is a SQL Server system administrator account that does not exist in Azure SQL Database; this is a legacy SQL Server concept not applicable to managed Azure services.
Question 38
You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?
Show answer and explanation
Correct answer: C. PolyBase
PolyBase is the technology that enables Azure Synapse Analytics to query external data sources like Azure Data Lake Storage Gen2 using Transact-SQL. It creates an abstraction layer allowing SQL queries to directly access files in data lakes without moving the data.
Why the other options are wrong
- A. Azure Functions are for serverless compute and event-driven workloads, not for querying data lakes from Synapse.
- B. SSIS is an on-premises ETL tool and is not used for querying cloud data lakes from Synapse.
- D. Azure Data Factory is an orchestration and ETL service, not a mechanism for executing T-SQL queries against data lakes.
Question 39
Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data store should you use?
Show answer and explanation
Correct answer: A. graph
Graph databases excel at modeling relationships and dependencies between entities. Network traffic patterns showing how changes in one area affect others represents a connected relationship problem that graph data structures handle optimally.
Why the other options are wrong
- B. Key/value stores are designed for simple lookups and do not model complex relationships well.
- C. Document stores are better for storing self-contained entities rather than modeling cross-entity relationships.
- D. Columnar databases are optimized for analytical queries on large datasets, not for representing relationships between entities.
Question 40
Which storage solution supports role-based access control (RBAC) at the file and folder level?
Show answer and explanation
Correct answer: B. Azure Data Lake Storage
Azure Data Lake Storage provides role-based access control (RBAC) at the file and folder level using Azure Active Directory integration and access control lists (ACLs). This granular permission model allows fine-grained security for individual files and directories.
Why the other options are wrong
- A. Azure Disk Storage is block storage for virtual machines and does not support file/folder level RBAC.
- C. Azure Blob Storage supports RBAC at the container or blob level but not at folder level like Data Lake Storage does.
- D. Azure Queue Storage is a message queue service without file/folder hierarchies or RBAC at that granularity.
Question 41
You need to recommend a data store service that meets the following requirements: • Native SQL API access • Configurable indexes What should you recommend?
Show answer and explanation
Correct answer: D. Azure Cosmos DB
Azure Cosmos DB provides native SQL API access for querying data and supports configurable indexing policies, allowing you to optimize indexes for your specific query patterns. No other option combines both native SQL API access and configurable indexing.
Why the other options are wrong
- A. Azure Files is for file sharing and does not support SQL APIs or configurable indexing.
- B. Azure Blob storage stores unstructured binary data and does not provide SQL API access or indexing capabilities.
- C. Azure Table storage uses a simple key-attribute model, not SQL API, and has limited indexing configuration options.
Question 42
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, D, F. heavy writes and moderate reads; schema defined in a database; normalized data
OLTP workloads are characterized by heavy writes and moderate reads as they process many transactions, normalized data schemas to reduce redundancy and maintain data integrity, and schemas defined in a database at design time. These characteristics optimize transactional systems for quick inserts, updates, and deletes with strong consistency.
Why the other options are wrong
- A. Denormalized data is typical of OLAP (analytical) systems, not OLTP systems.
- C. Light writes and heavy reads describes OLAP workloads, which are analytical in nature, not transactional.
- E. Schema-on-read is a data lake pattern for handling unstructured data, not a characteristic of OLTP databases.
Question 43
You have an Azure SQL database that you access directly from the Internet. You recently changed the public IP address of your computer. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue?
Show answer and explanation
Correct answer: D. a database-level firewall
Azure SQL Database uses firewall rules to control which IP addresses can connect to the database. When your public IP address changes, your old IP is no longer in the allowed IP list, and your new IP hasn't been added to the firewall rules. This causes connection failures even though you can access other Azure resources that may have different or no IP-based restrictions.
Why the other options are wrong
- A. RBAC controls access to Azure resources and management operations, not network connectivity to SQL databases.
- B. DHCP assigns IP addresses but does not block database connections; the firewall rule is what prevents the connection.
- C. DNS translates domain names to IP addresses; if DNS were the issue, you wouldn't be able to resolve the server name at all.
Question 44
What is a characteristic of non-relational data?
Show answer and explanation
Correct answer: B. self-describing entities
Non-relational data is typically characterized by self-describing entities, where the structure and metadata are embedded within the data itself. This allows flexible schemas and varied structures across different records without predefined enforcement.
Why the other options are wrong
- A. Non-relational databases typically have indexes to optimize query performance.
- C. Non-relational data specifically allows flexible, application-defined schemas rather than well-defined rigid schemas.
- D. Non-relational data stores do use unique key values to identify records.
Question 45
You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?
Show answer and explanation
Correct answer: C. file
Azure Files provides cloud-based file shares that replicate the functionality of Windows network file shares, making it the natural replacement for an on-premises shared folder. It supports SMB and NFS protocols and integrates seamlessly with existing file-based workflows.
Why the other options are wrong
- A. Queue storage is for message queuing and asynchronous communication, not file sharing.
- B. Blob storage is for unstructured binary data and does not provide file share semantics or folder hierarchies.
- D. Table storage is for structured key-attribute data, not for hierarchical file organization.
Question 46
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
Show answer and explanation
Correct answer: C. Online Analytical Processing (OLAP)
A quality assurance application reading from a data warehouse uses Online Analytical Processing (OLAP). Data warehouses are designed to support analytical queries and reporting on historical data, which is the core function of OLAP systems.
Why the other options are wrong
- A. OLTP is used for transactional systems with frequent writes and operational data, not analytical queries against historical warehouse data.
- B. Batch processing refers to processing data in scheduled groups, while OLAP provides interactive analytical query capability.
- D. Stream processing handles real-time continuous data flows, not the static analytical queries typical of data warehouse applications.
Question 47
Which Azure Data Factory component initiates the execution of a pipeline?
Show answer and explanation
Correct answer: B. a trigger
A trigger is the Azure Data Factory component that initiates pipeline execution. Triggers define when and how a pipeline should run, whether on a schedule, in response to events, or through manual invocation.
Why the other options are wrong
- A. Control flow manages the flow of activities within a pipeline after execution has begun, not the initiation.
- C. Parameters are used to pass values into pipelines but do not initiate execution.
- D. Activities are individual tasks within a pipeline that execute after the pipeline has been triggered.
Question 48
You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. Which type of data store should you recommend?
Show answer and explanation
Correct answer: C. object
Object stores are specifically designed for storing large binary files such as text files, videos, audio streams, and virtual disk images, along with metadata and unique identifiers. This is their primary use case, providing efficient storage and retrieval of unstructured data at scale.
Why the other options are wrong
- A. Key/value stores are not optimized for large binary files and lack content-based retrieval capabilities.
- B. Columnar databases are for structured analytical data, not large media files.
- D. Document stores are designed for JSON and structured data, not efficient binary file storage.
Question 49
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
Show answer and explanation
Correct answer: B. native support for cross-database queries and transactions
Azure SQL Managed Instance provides native support for cross-database queries and transactions, which is a key advantage over Azure SQL Database. This feature allows developers to run queries that span multiple databases within the same managed instance. Built-in high availability, automatic backups, and encryption at rest are available in both deployment options.
Why the other options are wrong
- A. Both Azure SQL Database and Managed Instance provide built-in high availability.
- C. Both Azure SQL Database and Managed Instance support system-initiated automatic backups.
- D. Both Azure SQL Database and Managed Instance support encryption at rest.
Question 50
Structured data where each row represents a single data entity uses which type of schema?
Show answer and explanation
Correct answer: B. tabular
Tabular schema represents structured data in rows and columns where each row represents a single data entity. This is the standard format for relational databases and structured data storage, with consistent columns across rows.
Why the other options are wrong
- A. XML is a hierarchical, semi-structured format that does not organize data as simple rows and columns.
- C. Blob storage holds unstructured binary data without schema or rows.
- D. JSON is a semi-structured format that can nest data and does not enforce the strict tabular row-column structure.
Question 51
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?
Show answer and explanation
Correct answer: A. key/value
Key/value stores provide the lowest latency for retrieval because they use simple hash-based lookups to fetch data by a unique key, which is optimal for session data like notifications, personalization attributes, and shopping cart items. This direct key lookup pattern is faster than graph traversals, columnar scans, or document field searches.
Why the other options are wrong
- B. Graph databases are optimized for relationship traversal, not simple key-based retrieval of session data.
- C. Columnar databases are designed for analytical queries across large datasets, not low-latency point lookups.
- D. Document databases have more overhead than key/value stores due to schema flexibility and nested document parsing.
Question 52
You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, C. the throughput; the partition key
Throughput can be configured at the container level to control the resource units (RUs) allocated to that specific container. The partition key must be specified at container creation and defines how data is distributed across logical partitions. Read regions and API are configured at the account level, not the container level.
Why the other options are wrong
- B. Read regions are configured at the account level, not at the container level.
- D. The API is selected during account creation and applies to the entire account, not individual containers.
Question 53
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
Show answer and explanation
Correct answer: D. JOIN
The JOIN clause is used in SELECT statements to combine rows from two or more tables based on related columns. SET is used in UPDATE statements, VALUES is used in INSERT statements, and KEY is used for constraint definitions, not for combining table rows.
Why the other options are wrong
- A. SET is used in UPDATE statements to modify column values.
- B. VALUES is used in INSERT statements to specify the data being inserted.
- C. KEY is used to define constraints or indexes, not to combine rows from tables.
Question 54
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, C. Azure HDInsight; Azure Databricks
Azure HDInsight and Azure Databricks are both Azure services that can provision Apache Spark clusters. HDInsight offers managed Hadoop and Spark clusters in a traditional cloud infrastructure model, while Databricks provides a unified analytics platform built on Spark.
Why the other options are wrong
- A. Azure Time Series Insights is a time-series data storage and analytics service, not a Spark cluster provisioning platform.
- D. Azure Log Analytics is a monitoring and log analysis service, not a platform for provisioning Spark clusters.
Question 55
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
Show answer and explanation
Correct answer: B. Availability Zones
Availability Zones provide redundancy and high availability within a single Azure region by distributing replicas across multiple physically separate zones within that region. This ensures data remains available even if one zone fails.
Why the other options are wrong
- A. Multi-master replication provides redundancy across multiple regions, not within a single region.
- C. Strong consistency is a consistency level setting that does not provide redundancy within a region.
- D. Automatic failover handles recovery when a failure occurs but does not itself provide the redundancy mechanism within a region.
Question 56
Which statement is an example of Data Definition Language (DDL)?
Show answer and explanation
Correct answer: D. CREATE
CREATE is a DDL (Data Definition Language) statement that defines database schema objects such as tables, indexes, and views. DDL statements modify the structure of the database itself rather than the data within it.
Why the other options are wrong
- A. SELECT is a DML (Data Manipulation Language) statement used to retrieve data, not define schema.
- B. JOIN is a clause used within DML queries to combine rows from multiple tables, not a DDL statement.
- C. UPDATE is a DML statement used to modify existing data, not define or alter database structure.
Question 57
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
Show answer and explanation
Correct answer: C. Azure SQL Managed Instance
Azure SQL Managed Instance provides the highest compatibility with SQL Server 2019 Enterprise edition because it maintains near-complete SQL Server compatibility, supports the same T-SQL features, agent jobs, cross-database queries, and enterprise features that SQL Server 2019 offers.
Why the other options are wrong
- A. Azure SQL Database has compatibility constraints and does not support all SQL Server 2019 Enterprise features like cross-database queries and SQL Agent.
- B. Azure Database for MySQL is designed for MySQL workloads, not SQL Server migration.
- D. Elastic pools are a deployment option within Azure SQL Database, which has the same compatibility limitations as single databases.
Question 58
You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?
Show answer and explanation
Correct answer: D. Online Transaction Processing (OLTP)
An e-commerce application that reads and writes data in real-time performs Online Transaction Processing (OLTP). OLTP systems handle individual transactions immediately, which is characteristic of e-commerce platforms that process orders, payments, and inventory updates as they occur. Azure SQL Database is optimized for OLTP workloads with its support for concurrent transactions and ACID properties.
Why the other options are wrong
- A. Stream processing handles continuous data flows in real-time, not discrete database transactions typical of e-commerce.
- B. Batch processing groups multiple transactions together for processing at scheduled intervals, not the immediate transaction handling needed for e-commerce.
- C. OLAP is used for analytical queries on historical data, not the transactional operations of an e-commerce application.
Question 59
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?
Show answer and explanation
Correct answer: C. Azure SQL Database
Azure SQL Database is a PaaS relational database service specifically designed for Online Transaction Processing workloads. It provides full ACID compliance, supports complex transactions, and is optimized for read/write operations characteristic of SaaS applications requiring robust transactional support.
Why the other options are wrong
- A. Azure Cosmos DB is a NoSQL database designed for distributed, non-relational data and global scale, not traditional OLTP with relational schemas.
- B. Azure HDInsight is a managed analytics service for big data processing, not suitable for transactional OLTP applications.
- D. Azure Synapse Analytics is designed for OLAP and data warehousing with large-scale analytical queries, not transactional OLTP workloads.
Question 60
Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?
Show answer and explanation
Correct answer: D. Azure Private Link
Azure Private Link enables private connectivity between Azure virtual machines and Azure SQL databases by creating private endpoints, eliminating exposure to the public internet. This solution provides secure, dedicated network connections without requiring VPN or gateway configurations.
Why the other options are wrong
- A. Application Gateway is a web traffic load balancer, not designed for private database connectivity.
- B. Traffic Manager is a DNS-based traffic router for load balancing across regions, not for private connectivity.
- C. DNS is a name resolution service and does not provide private connectivity between services.
Question 61
What is the primary purpose of a data warehouse?
Show answer and explanation
Correct answer: A. to provide answers to complex queries that rely on data from multiple sources
A data warehouse consolidates data from many sources into a model optimised for analysis. Its primary purpose is to answer complex analytical queries that draw on that combined data, supporting reporting and business intelligence.
Why the other options are wrong
- B. Transformation between source and target stores is the job of ETL or ELT tools, not the warehouse itself.
- C. Holding historical data is a characteristic of a warehouse, but storage is not its purpose, and warehouses are loaded and updated rather than strictly read-only.
- D. Transactional line-of-business applications use OLTP databases, not data warehouses.
Question 62
You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?
Show answer and explanation
Correct answer: A. Archive
The Archive tier provides the lowest storage cost for long-term data retention, making it optimal for seven-year compliance storage where retrieval time is not critical. Archive tier charges minimal storage fees while accepting higher access latencies and retrieval costs.
Why the other options are wrong
- B. Hot tier is designed for frequently accessed data and has significantly higher storage costs than Archive tier.
- C. Cool tier is for infrequently accessed data but still more expensive than Archive tier for long-term seven-year storage.
Question 63
Which Azure Data Factory component provides the compute environment for activities?
Show answer and explanation
Correct answer: B. an integration runtime
An integration runtime is the compute infrastructure in Azure Data Factory that provides the execution environment for activities. It handles data movement, activity dispatch, and execution across on-premises and cloud environments. Integration runtimes are essential for running pipelines and activities.
Why the other options are wrong
- A. SSIS packages are SQL Server Integration Services components and are not part of the Azure Data Factory architecture.
- C. A control flow is a logical structure within a pipeline for orchestrating activities, not a compute environment.
- D. A pipeline is a container for activities and doesn't provide compute; it relies on integration runtimes for execution.
Question 64
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
Show answer and explanation
Correct answer: C. Online Analytical Processing (OLAP)
Paginated reports querying a dimensional model in a data warehouse use Online Analytical Processing (OLAP). OLAP is designed for complex analytical queries against multidimensional data structures, which is the foundation of data warehouse dimensional models.
Why the other options are wrong
- A. Stream processing handles continuous data flows in real-time, not the static analytical queries of paginated reports.
- B. Batch processing processes data in groups at scheduled intervals, while OLAP provides interactive analytical query capability.
- D. OLTP handles transactional operations with frequent writes and reads on normalized data, opposite to the analytical nature of this scenario.
Question 65
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?
Show answer and explanation
Correct answer: B. Azure Active Directory (Azure AD) authentication
Azure Active Directory (Azure AD) authentication supports multi-factor authentication (MFA) for connections to Azure SQL databases. Azure AD is the identity platform that integrates with MFA capabilities. Service principal, SQL, and certificate authentication do not natively support MFA requirements.
Why the other options are wrong
- A. Service principal authentication does not support MFA.
- C. SQL authentication (username/password) does not support MFA.
- D. Certificate authentication does not support MFA.
Question 66
You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?
Show answer and explanation
Correct answer: A. You need to generate reports without affecting the transactional workload.
A read-only database replica is implemented to offload reporting and analytics workloads from the transactional database, preventing reports from affecting the performance of the application's transactional operations. Auditing is handled through other mechanisms, high availability for regional outages uses geo-replication failover groups, and RPO is improved through backup strategies.
Why the other options are wrong
- B. Auditing is implemented through Azure SQL Database auditing features, not read-only replicas.
- C. Regional outage protection is achieved using failover groups and geo-replication, not read-only replicas.
- D. Recovery point objective is improved through backup and restore strategies, not read-only replicas.
Question 67
You need to store data by using Azure Table storage. What should you create first?
Show answer and explanation
Correct answer: B. a storage account
A storage account is the foundational Azure resource that must be created first. Azure Table storage is a service within a storage account, so the storage account must exist before you can create tables or use any table storage functionality.
Why the other options are wrong
- A. Azure Cosmos DB is a separate service and not required for Azure Table storage.
- C. Blob containers are for blob storage, a different service, and not needed for Table storage.
- D. A table cannot be created without first having a storage account to contain it.
Question 68
Which statement is an example of Data Definition Language (DDL)?
Show answer and explanation
Correct answer: D. DROP
DROP is a Data Definition Language (DDL) statement used to remove database objects like tables, databases, or schemas. DDL statements define and modify the structure of database objects. SELECT is DML (retrieval), INSERT is DML (data modification), and DELETE is DML (data modification).
Why the other options are wrong
- A. SELECT is Data Manipulation Language (DML), not DDL.
- B. INSERT is Data Manipulation Language (DML), not DDL.
- C. DELETE is Data Manipulation Language (DML), not DDL.
Question 69
You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?
Show answer and explanation
Correct answer: D. streaming
Streaming workloads are designed for real-time data ingestion from continuous sources like mobile applications. They process data as it arrives with minimal latency, which matches the requirement to gather real-time telemetry data from a mobile application.
Why the other options are wrong
- A. OLTP handles transactional queries, not continuous real-time data streams.
- B. Batch processing collects data over time before processing it, not real-time gathering.
- C. Massively parallel processing (MPP) is for large-scale data analytics, not real-time telemetry collection.
Question 70
Which command-line tool can you use to query Azure SQL databases?
Show answer and explanation
Correct answer: A. sqlcmd
sqlcmd is a command-line tool specifically designed to execute SQL queries against SQL Server and Azure SQL databases. It supports interactive and batch query execution, making it the direct tool for database queries from the command line.
Why the other options are wrong
- B. bcp is the bulk copy utility used for importing and exporting large amounts of data, not for interactive querying.
- C. azdata is a command-line tool for managing Azure Data Studio and SQL Server Big Data Clusters, not for querying standard Azure SQL databases.
- D. Azure CLI is a general-purpose tool for managing Azure resources and services, not specifically for executing SQL queries.
Question 71
Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?
Show answer and explanation
Correct answer: B. time series
Time series databases are purpose-built for storing and analyzing sensor data collected over time. They are optimized for ingesting high-volume sequential data points and performing trend analysis, making them ideal for temperature sensor telemetry that requires temporal analysis.
Why the other options are wrong
- A. Relational databases are not optimized for the high-velocity, high-volume nature of sensor data.
- C. Graph databases are for relationship analysis, not temporal trend analysis.
- D. Columnar databases, while good for analytics, lack the temporal optimizations of time series databases.
Question 72
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, D, F. heavy writes and moderate reads; schema on write; normalized data
OLTP workloads are characterized by heavy writes and moderate reads, normalized data structures to minimize redundancy and maintain data integrity, and schema on write enforcement where data validation occurs at insertion time. These characteristics support transactional consistency and concurrent updates typical of operational systems.
Why the other options are wrong
- A. Denormalized data is characteristic of OLAP and data warehouses, not OLTP systems.
- C. Light writes and heavy reads characterize OLAP and analytical workloads, opposite to OLTP's transaction-heavy nature.
- E. Schema on read is characteristic of data lakes and big data platforms, not OLTP systems which enforce strict schemas.
Question 73
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, C. database; container
Throughput in Azure Cosmos DB can be set at two levels: at the database level (applying to all containers within it) or at the container level (for individual container control). This two-level approach allows flexible resource allocation depending on workload requirements.
Why the other options are wrong
- B. Item-level throughput is not a configuration option in Azure Cosmos DB.
- D. Partition-level throughput is not a user-configurable setting; partitions are managed automatically by the service.
That was 73 of 323.
The full Microsoft DP-900 pack has all 323 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.
Not ready yet? Get the first 161 free as one PDF by email. Get the Half Pack →