Microsoft Azure

Azure Cosmos DB Developer Specialty

DP-420

Specialize in Azure Cosmos DB with the DP-420 exam designed for developers.

147 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 41–50 of 147

Q41

A company needs to migrate a large volume of documents to Azure Cosmos DB. What approach should they take to optimize this process?

  • A Manual data entry via Azure Portal
  • B Use AzCopy tool for bulk import
  • C Cloud Backup solution
  • D SQL Server Import and Export Wizard
Explanation Using the AzCopy tool is the most efficient way to perform bulk imports into Azure Cosmos DB.
Q42

You are configuring partitioning for your Azure Cosmos DB container. What happens if you choose a partition key that is frequently accessed?

  • A Higher throughput with throttling risks
  • B Even distribution of writes
  • C Lower read latency across partitions
  • D Increased operational costs due to hot partition
Explanation Choosing a frequently accessed partition key can lead to a hot partition, causing increased costs and throttling.
Q43

Which capability allows for automatic data partitioning in Azure Cosmos DB?

  • A Partition Key
  • B Content Delivery Network
  • C Serverless Warehousing
  • D Data Squares
Explanation The Partition Key enables automatic data partitioning, while the others do not relate to data partitioning.
Q44

A company needs to configure multi-region writes for their Azure Cosmos DB account. Which consistency level should they choose?

  • A Eventual
  • B Bounded Staleness
  • C Strong
  • D Session
Explanation Bounded Staleness supports multi-region writes, while others do not.
Q45

What happens when you attempt to create a SQL API container with an invalid partition key definition in Azure Cosmos DB?

  • A Container is created successfully
  • B Create operation fails
  • C Container is created with default settings
  • D Partition keys are ignored
Explanation The create operation fails due to invalid key definition, as it must be valid to succeed.
Q46

Which service allows you to structure partition keys in Cosmos DB?

  • A Azure Functions
  • B Partitioning Design
  • C Data Azure Table
  • D Blob Storage
Explanation Partitioning Design is critical for effective scaling and performance, while the others do not directly relate to partition keys.
Q47

A company needs to efficiently manage throughput in a multi-tenant application using Cosmos DB. What should they use?

  • A Request Units per second
  • B Elastic Database Tools
  • C Read Replicas
  • D Logical Partitioning
Explanation Request Units per second allows dynamic management of throughput, while others do not address multi-tenancy efficiently.
Q48

What happens when you set a TTL of zero in Cosmos DB?

  • A Documents are retained indefinitely
  • B Documents are deleted immediately
  • C Documents require manual deletion
  • D TTL setting has no effect
Explanation Setting TTL to zero ensures immediate deletion of documents, while the other options imply indefinite retention or incomplete control.
Q49

A company needs to frequently query a large dataset in Azure Cosmos DB based on timestamp. Which indexing strategy should they employ?

  • A Use range indexing for the timestamp.
  • B Disable indexing for the timestamp.
  • C Use composite indexing for all fields.
  • D Use spatial indexing for better queries.
Explanation Range indexing is optimal for querying by timestamps, while the others either disable key capabilities or aren't applicable.
Q50

What happens when you attempt to set a dedicated throughput for a container in Azure Cosmos DB that already has existing throughput?

  • A Throughput settings are ignored.
  • B Old throughput is replaced with new.
  • C Container is deleted and recreated.
  • D Throughput settings are merged.
Explanation Setting a new dedicated throughput replaces the old settings; the others do not reflect correct behavior.