Free Microsoft DP-420 Exam Dumps Questions & Answers

Drag and Drop Question
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account contains a database named DB1 and an Azure Key Vault named KV1.
You need to create a container named Container1 in DB1. The solution must ensure that the properties of the items in container1 are encrypted by using Always Encrypted.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Which of the following function in Spark SQL separates the array's elements into multiple rows with positions and utilizes the column names 'pos' for position and 'col' for elements of the array?

• A.Separate()
• B.explode()
• C.posexplode()
• D.preexplode()

Hotspot Question
You have an Azure Cosmos DB for NoSQL account that hosts a container named Customers.
You need to add customers to Customers by using the Azure Cosmos DB Spark Connector.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

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 following is a sample of the data.

You need to select a partition key that meets the following requirements for writes:
- Minimizes the partition skew
- Avoids capacity limits
- Avoids hot partitions
What should you do?

• A.Create a new synthetic key that contains deviceId and a random number.
• B.Create a new synthetic key that contains deviceId and sensor1Value.
• C.Use timestamp as the partition key.
• D.Create a new synthetic key that contains deviceId and deviceManufacturer.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.
In account1, you create a container that has the following configurations:
- Partition key: CompanyID
- Composite unique key: UserName and EmailAddress
To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

• A.0
• B.2
• C.3
• D.1