Free Sample — 15 Practice Questions
Preview 15 of 282 real practice questions from the Microsoft DP-900 study guide.
Question 170
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?
A. Scale down the data warehouse units (DWUs).
B. Pause the pool.
C. Create a user-defined restore point.
D. Delete the pool
Show Answer
Correct Answer: B
Explanation:
Pausing a dedicated SQL pool stops compute charges while preserving all data on storage. This is the most cost‑effective option during idle periods and allows the pool to be resumed when needed without data loss. Scaling down still incurs compute costs, creating restore points does not reduce ongoing costs, and deleting the pool would remove the data.
Question 277
HOTSPOT -
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Hot Area:
Show Answer
Correct Answer: Customer: a root object
Address: a nested object
Social media: a nested array
Explanation:
The top-level element is the customer object (root). Address is an object nested inside customer. Social media is an array ([]) nested inside customer, containing objects.
Question 44
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: aggregated
Explanation:
OLAP systems store pre-aggregated, multidimensional data to optimize fast analytical queries such as roll-up, drill-down, and slice-and-dice.
Question 282
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Show Answer
Correct Answer: enable the hierarchical namespace.
Explanation:
A hierarchical namespace (Azure Data Lake Storage Gen2) enables true folders with POSIX-like ACLs for folder-level security and supports atomic directory operations such as rename and move.
Question 131
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: the same set of columns
Explanation:
In a relational table, the schema (columns and data types) is fixed. Every row represents a record that conforms to this same structure.
Question 173
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: treemap
Explanation:
A treemap displays data as colored rectangles where each rectangle’s size represents the relative value of an item, and it can show hierarchical data using nested rectangles.
Question 194
Which Azure Data Factory component provides the compute environment for activities?
A. SSIS packages
B. an integration runtime
C. a control flow
D. a pipeline
Show Answer
Correct Answer: B
Explanation:
In Azure Data Factory, the Integration Runtime (IR) is the compute infrastructure that provides the execution environment for activities. Pipelines and control flows define orchestration logic, and SSIS packages are workloads that can be run, but the IR supplies the actual compute used to move, transform, and process data.
Question 247
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Show Answer
Correct Answer: transactional writes
Explanation:
Relational databases are designed for high volumes of ACID-compliant transactions, ensuring consistency and integrity. They are not ideal for geographically distributed writes or flexible schemas, which are better handled by non-relational databases.
Question 28
HOTSPOT -
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: random read and write operations.
Explanation:
Azure Page Blobs are designed for frequent, random read/write access to fixed-size pages, making them suitable for scenarios like virtual hard disks where small segments are updated at known offsets.
Question 220
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?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer
Show Answer
Correct Answer: C
Explanation:
The developers use both Windows 10 and Ubuntu Desktop and require IntelliSense and query capabilities for Azure SQL Database. Azure Data Studio is cross-platform (Windows, Linux, macOS) and provides full query editing with IntelliSense and extensions. SSMS is Windows-only, sqlcmd lacks IntelliSense, and Azure Data Explorer is a different analytics service, not a SQL client.
Question 135
What is required to provision Azure Data Lake Storage in an Azure Storage account?
A. Versioning must be disabled.
B. Hierarchical namespace must be disabled.
C. Versioning must be enabled.
D. Hierarchical namespace must be enabled.
Show Answer
Correct Answer: D
Explanation:
Azure Data Lake Storage Gen2 requires the storage account to have the hierarchical namespace feature enabled. This namespace provides directory and file system semantics needed for analytics workloads. Versioning settings are unrelated to provisioning ADLS Gen2.
Question 120
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Show Answer
Correct Answer: structured data
Explanation:
In the exam context, relationships between users and followers stored in a graph database are treated as structured data because nodes and edges follow a defined schema and can be queried systematically.
Question 151
You have the following two tables of customer data.
Which type of data do the tables contain?
A. structured
B. non-relational
C. semi-structured
D. unstructured
Show Answer
Correct Answer: A
Explanation:
The data is organized into tables with defined columns, rows, and keys (e.g., primary/foreign keys) that enable joins. This is the definition of structured data, as opposed to semi-structured (JSON/XML), non-relational, or unstructured data (text, images, audio).
Question 74
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: the Power BI service
Explanation:
Power BI Desktop is used to create models and reports, and publishing makes them available online for sharing and collaboration through the cloud-based Power BI service.
Question 150
You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?
A. Azure SQL Database single database
B. an Azure SQL Database elastic pool
C. Azure SQL Managed instance
D. SQL Server on Azure virtual machines
Show Answer
Correct Answer: C
Explanation:
Azure SQL Managed Instance provides near 100% SQL Server engine compatibility with minimal maintenance overhead. It supports SQL Server features such as Database Mail and Service Broker, which are not supported in Azure SQL Database single databases or elastic pools. Compared to SQL Server on Azure VMs, Managed Instance significantly reduces administrative and maintenance effort while still meeting the feature requirements.