DP-420 Exam Questions
143 real DP-420 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #144Optimize an Azure Cosmos DB solution
You have operational data in an Azure Cosmos DB for NoSQL database. Database users report that the performance of the database degrades significantly when a business analytics team...
Azure Synapse LinkWorkload isolationHTAPPerformance optimization - Question #146Optimize an Azure Cosmos DB solution
You are creating an Azure Cosmos DB for NoSQL account. You need to choose whether to configure capacity by using either provisioned throughput or serverless mode. Which two workloa...
Azure Cosmos DBServerless modeCapacity planningWorkload optimization - Question #149Maintain an Azure Cosmos DB solution
You have a container in an Azure Cosmos DB for NoSQL account. You need to create an alert based on a custom Log Analytics query. Which signal type should you use?
Azure MonitoringLog AnalyticsAlertsCosmos DB - Question #150Maintain an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...
Cosmos DB MonitoringKQLThroughput ManagementDiagnostic Logs - Question #151Maintain an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request unit...
Azure Cosmos DB MonitoringRequest Units (RU/s)Azure Monitor AlertsProvisioned Throughput - Question #154Integrate an Azure Cosmos DB solution
You have an Azure subscription that contains the resources shown in the following table. You need to store the account key of account1 in KV1. What should you use?
Azure Key VaultSecrets ManagementSecurityAccount Keys - Question #155Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request unit...
Azure Cosmos DB MonitoringRequest Units (RU/s)Azure Monitor AlertsPerformance Management - Question #156Maintain an Azure Cosmos DB solution
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. Backups for account1 have the following configurations: - Interval: 2 hours - Rete...
Backup and RestorePricingPeriodic BackupRetention Policy - Question #157Integrate an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account that contains a database named DB1 and a container named Container1. You need to manage the account by using the Azure Cosmos DB SDK....
Azure Cosmos DB SDKUser Defined Functions (UDFs)Server-side programmingContainer management - Question #159Design and implement data distribution
You plan to create an Azure Cosmos DB for NoSQL account that will have a single write region and three read regions. You need to set the consistency level for the account. The solu...
Azure Cosmos DBConsistency LevelsMulti-regionData distribution - Question #160Integrate an Azure Cosmos DB solution
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...
Azure Stream AnalyticsReference dataAzure Cosmos DB change feedAzure data integration - Question #166Design and implement data models
You have an Azure Cosmos DB database that hosts a container named container1. You need to ensure that the items stored in container1 will NOT expire unless their TTL value is set e...
Azure Cosmos DBTime-to-Live (TTL)Container configurationData expiry - Question #167Design and implement data distribution
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will be occur every second. Data will be retained indefinitely. The...
Partition keyHot partitionsData distributionSynthetic key - Question #168Optimize an Azure Cosmos DB solution
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that uses a default consistency level of Consistent Prefix. You execut...
Cosmos DB Consistency LevelsConsistent PrefixEventual ConsistencyRequest-level Consistency - Question #169Design and implement data distribution
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1. In DB1, you plan to create a container that will use a hierarchical partition key. You...
Hierarchical Partition KeysAzure Cosmos DB SDKPartitionKeyBuilderData Distribution - Question #170Design and implement data models
You are designing an Azure Cosmos DB for NoSQL data model that will contain authors, books the authors have written, and reviews of the books. You need to maintain referential inte...
Azure Cosmos DB TransactionsReferential IntegrityData Model DesignContainer Management - Question #172Design and implement data models
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You need to write a SQL query that will return multiple items. The solution must meet the followi...
Cosmos DB SQL APIDate and Time FunctionsQuerying DataISO 8601 - Question #173Optimize an Azure Cosmos DB solution
Drag and Drop Question You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are wri...
Cosmos DB SQL APINested Array QueryingAggregation FunctionsGROUP BY - Question #174Optimize an Azure Cosmos DB solution
You have an app named App1 that uses an Azure Cosmos DB for NoSQL database. App1 uses the spatial columns shown in the following table. You need to design an indexing strategy for...
Azure Cosmos DBIndexingSpatial Index - Question #175Design and implement data distribution
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. The fol...
Partition keyHot partitionsWrite optimizationSynthetic key - Question #176Design and implement data models
Drag and Drop Question You have an Azure Cosmos DB for NoSQL account. You need to implement Always Encrypted for all the data stored in the account. The solution must minimize admi...
Azure Cosmos DBAlways EncryptedData EncryptionSecurity PolicyKey Management - Question #177Design and implement data models
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. The fol...
Partition KeysSynthetic KeysHot PartitionsTime-Series Data - Question #179Integrate an Azure Cosmos DB solution
You have an on-premises computer named Computer1 that runs Windows 11. On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to...
Azure Cosmos DB EmulatorAPI for NoSQLLocal developmentConnection details - Question #181Design and implement data distribution
You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 IoT devices. The data will be updated once every minute. An app will read the data once...
Azure Cosmos DBPartition KeyData DistributionPerformance Optimization - Question #182Design and implement data distribution
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. The fol...
Partition key designHot partitionsPartition skewIoT solution design - Question #184Optimize an Azure Cosmos DB solution
You plan to create an Azure Cosmos DB account that will use an integrated cache. What will prevent you from using an integrated cache?
Integrated CachePrivate LinkCosmos DBLimitations - Question #185Optimize an Azure Cosmos DB solution
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key name...
Cosmos DBPartitioningQuery OptimizationIn-partition Query - Question #190Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL container named Container1 that contains 20,000 items. The items have 1,000 unique partition key values. Each item is 50 KB. You need to evalu...
Cross-partition queriesCost evaluationPartitioningData volume - Question #191Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL container named Contained that has a provisioned throughput of 1,000 request units per second (RU/s). Contained is queried by using an app nam...
ThroughputError HandlingRate LimitingReliability - Question #192Design and implement data models
You have an Azure subscription. You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to t...
Data ModelingDocument EmbeddingTransactional ConsistencyRead Cost Optimization - Question #193Optimize an Azure Cosmos DB solution
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Container1. Container1 has a provisioned...
Azure Cosmos DBThroughputBurst CapacityPhysical Partition - Question #195Integrate an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app wil...
Change FeedParallel ProcessingAzure Cosmos DB SDKPull Model - Question #197Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL container. All queries to the container use the Bounded Staleness consistency level. You discover that when many queries are executed against...
Azure Cosmos DB throttlingRequest Units (RU/s)Throughput scalingServer-side logic (triggers) - Question #198Design and implement data distribution
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that uses strong consistency and is deployed to the East US, West US,...
Cosmos DB ConsistencyMulti-region ReplicationWrite LatencyStrong Consistency - Question #199Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account that contains a database named DB1. Users run the following query against DB1. SELECT * FROM c WHERE c.bikeParts = "Frame, Chain, Pedd...
Query optimizationIndexingComposite indexesORDER BY clause - Question #200Maintain an Azure Cosmos DB solution
Drag and Drop Question You have an Azure Cosmos DB for NoSQL account named account1 that has a periodic backup policy with a four-hour backup interval and an eight-hour retention p...
Azure Cosmos DB BackupData RecoveryPeriodic BackupData Protection - Question #203Maintain an Azure Cosmos DB solution
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1. At some point during the past 4S hours, Container...
Azure Cosmos DBPoint-in-Time RestoreBackup and RestoreData Recovery - Question #204Maintain an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...
Azure Cosmos DB monitoringLog Analytics KQLThroughput managementDiagnostic logs - Question #205Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account that has multiple write regions. You need to receive an alert when requests that target the database exceed the available request unit...
Azure MonitorCosmos DB MetricsRequest UnitsPerformance Monitoring - Question #206Maintain an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...
Azure Cosmos DBDiagnostic LogsKusto Query LanguageThroughput Management - Question #208Optimize an Azure Cosmos DB solution
You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions. You need to test the performance of db1 in the secondary region. Which command shoul...
Multi-regionFailoverPerformance testingAzure CLI - Question #209Integrate an Azure Cosmos DB solution
Drag and Drop Question You have an Azure subscription that contains the resources shown in the following table. You need to create a container in db1 that has the following attribu...
Azure Cosmos DBClient-side encryptionAlways EncryptedContainer creation - Question #210Integrate an Azure Cosmos DB solution
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. You plan to configure the Apache Kafka service as a data source for account1. What...
Kafka IntegrationConfiguration StorageAzure Key VaultSecurity Best Practices