DP-420 exam

You have a database in an Azure Cosmos DB Core (SQL) API account. You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks. How should you define the command statement in...

Topic 2, Misc. Questions You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US. You run the following PowerShell command. What is the effect of...

HOTSPOT You provision Azure resources by using the following Azure Resource Manager (ARM) template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: No An alert is triggered when the...

Topic 1, Litware, inc Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...

You have an Azure Cosmos DB Core (SQL) API account. You run the following query against a container in the account. SELECT IS_NUMBER("1234") AS A, IS_NUMBER(1234) AS B, IS_NUMBER({prop: 1234}) AS C What is the output of the query?A . [{"A": false, "B": true, "C": false}] B. [{"A": true, "B":...

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 question sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You plan to implement con-iot1 and con-iot2. You need to configure the default Time to Live setting for each container. The solution must meet the loT telemetry requirements. What should you configure? To answer, select the appropriate options in the answer NOTE: Each correct selection is worth one point....

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions. You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput. Which sink...

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 question sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You have a database named telemetry in an Azure Cosmos DB Core (SQL) API account that stores IoT data. The database contains two containers named readings and devices. Documents in readings have the following structure. id deviceid timestamp ownerid measures (array) - type - value - metricid Documents in...