DP-900 Free Practice Test

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

1. A. supports partitioning
2. B. provides resiliency if art Azure region fads
3. C. provides a higher storage capacity
4. D. supports a multi-master model

Correct Answer: D
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs. Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?

1. A. a table
2. B. an index
3. C. scalar function
4. D. a view

Correct Answer: D
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

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?

1. A. queue
2. B. blob
3. C. file
4. D. table

Correct Answer: C
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.

Which Azure Data Factory component initiates the execution of a pipeline?

1. A. a control flow
2. B. a trigger
3. C. a parameter
4. D. an activity

Correct Answer: B