Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 201:

  Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

  A. relational

  B. columnar

  C. graph

  D. time series

  Correct Answer: D

  Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the

  records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.

  Reference:

  https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

• Question 202:

  At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

  A. database

  B. partition

  C. collection

  D. account

  Correct Answer: C

• Question 203:

  Your company if 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?

  A. key/value

  B. document

  C. graph

  D. columnar

  Correct Answer: A

  A key/value store associates each data value with a unique key.

  An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

  Reference:

  https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

• Question 204:

  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

  Correct Answer: B

  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

• Question 205:

  When can you use an Azure Resource Manager template?

  A. to automate the creation of an interdependent group of Azure resources in a repeatable way

  B. to automate the creation of an interdependent and develop can deploy from the Azure portal

  C. To provision Azure subscriptions and apply policies for multi-tenant deployments

  D. To set complex permissions automatically on existing objects in an Azure subscription

  Correct Answer: A

  You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.

  Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

• Question 206:

  You need to create an Azure Storage account.

  Data in the account must replica outside the Azure region automatically.

  Which two types of replica can you us for the storage account?

  Each correct answer presents a complete solution.NOTE: Each correct selection is worth one pint.

  A. read-access geo-redundant storage (RA_GRS)

  B. zone-redundant storage (ZRS)

  C. geo-redundant storage (GRS)

  D. locally-redundant storage (LRS)

  Correct Answer: AC

  Azure Storage offers two options for copying your data to a secondary region:

  Geo-redundant storage (GRS)

  Geo-zone-redundant storage (GZRS)

  With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region.

  For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone- redundant storage (RA-GZRS).

  Reference:

  https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a- secondary-region

• Question 207:

  You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, 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?

  A. document

  B. key/value

  C. object

  D. columnar

  Correct Answer: C

  Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store- overview

• Question 208:

  You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?

  A. Azure Cosmos DB

  B. Azure Table storage

  C. Azure Files

  D. Azure Blob Storage

  Correct Answer: C

• Question 209:

  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?

  A. Key/value

  B. Graph

  C. Document

  D. columnar

  Correct Answer: B

  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

• Question 210:

  You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

  A. You need to generate reports without affecting the transactional workload.

  B. You need to audit the transactional application.

  C. You need to implement high availability in the event of a regional outage

  D. You need to improve the recovery point objective (RPO).

  Correct Answer: A

  Use read-only replicas to offload read-only query workloads.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out