Practice Free DP-900 Exam Online Questions
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
DRAG DROP
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Image files
Azure Blob storage is suitable for image files.
Box 2: Key/value pairs
Azure CosmosDB table API is a key-value storage hosted in the cloud.
Box 3: Relationship between employees
One-to-many relationships between business domain objects occur frequently: for example, one
department has many employees. There are several ways to implement one-to-many relationships in
the Azure Table service.
Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- A . multi-master replication
- B . Availability Zones
- C . automatic failover
- D . the strong consistency level
B
Explanation:
With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.
Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability
Which command-line tool can you use to query Azure SQL databases?
- A . sqlcmd
- B . bcp
- C . azdata
- D . Azure CLI
A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=singledatabase
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
- A . an Azure SQL Database elastic pool
- B . Azure SQL Managed Instance
- C . Azure Database for MySQL
- D . Azure SQL Database
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/data-factory/introduction
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Your company needs to design a database that shows how changes traffic in one area of a network
affect other components on the network.
Which type of data store should you use?
- A . Key/value
- B . Graph
- C . Document
- D . columnar
B
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
