Dumps4free
Black Friday Dumps Sale
Home / Microsoft / Microsoft Certified: Azure Cosmos DB Developer Specialty / DP-420 - Microsoft Azure Cosmos DB Developer Specialty

Microsoft DP-420 Dumps

Total Questions Answers: 128
Last Updated: 20-Nov-2024
Available with 1, 3, 6 and 12 Months Free Updates Plans
PDF: $15 $60

Test Engine: $20 $80

PDF + Engine: $25 $99

Check Our Recently Added DP-420 Exam Questions


Question # 1



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": false, "C": true}]

C.

[{"A": true, "B": true, "C": false}]

D.

[{"A": true, "B": true, "C": true}]




A.   

[{"A": false, "B": true, "C": false}]



Explanation:
IS_NUMBER returns a Boolean value indicating if the type of the specified expression is a
number.
"1234" is a string, not a number.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-is-number




Question # 2



You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before
an item is inserted into a container.
Which two actions should you perform to ensure that the trigger runs? Each correct answer
presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

Append pre to the name of the JavaScript function trigger.

B.

For each create request, set the access condition in RequestOptions.

C.

Register the trigger as a pre-trigger.

D.

For each create request, set the consistency level to session in RequestOptions.

E.

For each create request, set the trigger name in RequestOptions.




C.   

Register the trigger as a pre-trigger.



Explanation:
C: When triggers are registered, you can specify the operations that it can run with.
F: When executing, pre-triggers are passed in the RequestOptions object by specifying
PreTriggerInclude and then passing the name of the trigger in a List object.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-use-storedprocedures-
triggers-udfs




Question # 3



You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict
resolution policy. The account has a registered merge procedure that throws a runtime
exception.
The runtime exception prevents conflicts from being resolved.
You need to use an Azure function to resolve the conflicts.
What should you use?

A.

a function that pulls items from the conflicts feed and is triggered by a timer trigger

B.

a function that receives items pushed from the change feed and is triggered by an Azure
Cosmos DB trigger

C.

a function that pulls items from the change feed and is triggered by a timer trigger

D.

a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger




D.   

a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger



Explanation: The Azure Cosmos DB Trigger uses the Azure Cosmos DB Change Feed to
listen for inserts and updates across partitions. The change feed publishes inserts and
updates, not deletions.
Reference: https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindingscosmosdb




Question # 4



You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.
You have an Azure Functions app named function1 that is supposed to run whenever items
are inserted or replaced in container1.
You discover that function1 runs, but not on every upsert.
You need to ensure that function1 processes each upsert within one second of the upsert.
Which property should you change in the Function.json file of function1?

A.

checkpointInterval

B.

leaseCollectionsThroughput

C.

maxItemsPerInvocation

D.

feedPollDelay




D.   

feedPollDelay



Explanation:
With an upsert operation we can either insert or update an existing record at the same
time.
FeedPollDelay: The time (in milliseconds) for the delay between polling a partition for new
changes on the feed, after all current changes are drained. Default is 5,000 milliseconds, or
5 seconds.
Reference: https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindingscosmosdb-
v2-trigger




Question # 5



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 answer a question in this section, you will NOT be able to return to it. As a result,
these questions will not appear in the review screen.
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.
You need to make the contents of container1 available as reference data for an Azure
Stream Analytics job.
Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL)
API as the input and Azure Blob Storage as the output.
Does this meet the goal?

 

A.

Yes

B.

No




B.   

No



Instead create an Azure function that uses Azure Cosmos DB Core (SQL) API change feed
as a trigger and Azure event hub as the output.
The Azure Cosmos DB change feed is a mechanism to get a continuous and incremental
feed of records from an Azure Cosmos container as those records are being created or
modified. Change feed support works by listening to container for any changes. It then
outputs the sorted list of documents that were changed in the order in which they were
modified.
The following diagram represents the data flow and components involved in the solution:

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/changefeedecommerce-
solution




Question # 6



You have the indexing policy shown in the following exhibit.




Question # 7



You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.
You need to analyze the data stored in the account by using Apache Spark to create
machine learning models. The solution must NOT affect the performance of the web apps.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the
data source.

B.

Create a private endpoint connection to the account.

C.

In an Azure Synapse Analytics serverless SQL pool, create a view that uses
OPENROWSET and the CosmosDB provider.

D.

Enable Azure Synapse Link for the account and Analytical store on the container.

E.

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the
data source.




A.   

In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the
data source.




D.   

Enable Azure Synapse Link for the account and Analytical store on the container.



Reference:
https://github.com/microsoft/MCW-Cosmos-DB-Real-Time-Advanced-
Analytics/blob/main/Hands-on-lab/HOL-step-by-step-
-Cosmos-DB-real-time-advanced-analytics.md




Question # 8



You have a database in an Azure Cosmos DB Core (SQL) API account. The database is
backed up every two hours.
You need to implement a solution that supports point-in-time restore.
What should you do first?

A.

Enable Continuous Backup for the account.

B.

Configure the Backup & Restore settings for the account.

C.

Create a new account that has a periodic backup policy.

D.

Configure the Point In Time Restore settings for the account.




A.   

Enable Continuous Backup for the account.



Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/provision-accountcontinuous-
backup




Question # 9



You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses
provisioned throughput capacity mode.
The storage1 account contains the databases shown in the following table.




Question # 10



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 answer a question in this section, you will NOT be able to return to it. As a result,
these questions will not appear in the review screen.
You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses
autoscale throughput.
You need to run an Azure function when the normalized request units per second for a
container in account1 exceeds a specific value.
Solution: You configure an Azure Monitor alert to trigger the function.
Does this meet the goal?

A.

Yes

B.

No




A.   

Yes



Explanation:
You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the
Azure portal.
Note: Alerts are used to set up recurring tests to monitor the availability and
responsiveness of your Azure Cosmos DB resources. Alerts can send you a notification in
the form of an email, or execute an Azure Function when one of your metrics reaches the
threshold or if a specific event is logged in the activity log.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-alerts



Get 128 Microsoft Azure Cosmos DB Developer Specialty questions Access in less then $0.12 per day.

Microsoft Bundle 1:


1 Month PDF Access For All Microsoft Exams with Updates
$100

$400

Buy Bundle 1

Microsoft Bundle 2:


3 Months PDF Access For All Microsoft Exams with Updates
$200

$800

Buy Bundle 2

Microsoft Bundle 3:


6 Months PDF Access For All Microsoft Exams with Updates
$300

$1200

Buy Bundle 3

Microsoft Bundle 4:


12 Months PDF Access For All Microsoft Exams with Updates
$400

$1600

Buy Bundle 4
Disclaimer: Fair Usage Policy - Daily 5 Downloads

Microsoft Azure Cosmos DB Developer Specialty Exam Dumps


Exam Code: DP-420
Exam Name: Microsoft Azure Cosmos DB Developer Specialty

  • 90 Days Free Updates
  • Microsoft Experts Verified Answers
  • Printable PDF File Format
  • DP-420 Exam Passing Assurance

Get 100% Real DP-420 Exam Dumps With Verified Answers As Seen in the Real Exam. Microsoft Azure Cosmos DB Developer Specialty Exam Questions are Updated Frequently and Reviewed by Industry TOP Experts for Passing Microsoft Certified: Azure Cosmos DB Developer Specialty Exam Quickly and Hassle Free.

Microsoft DP-420 Dumps


Struggling with Microsoft Azure Cosmos DB Developer Specialty preparation? Get the edge you need! Our carefully created DP-420 dumps give you the confidence to pass the exam. We offer:

1. Up-to-date Microsoft Certified: Azure Cosmos DB Developer Specialty practice questions: Stay current with the latest exam content.
2. PDF and test engine formats: Choose the study tools that work best for you.
3. Realistic Microsoft DP-420 practice exam: Simulate the real exam experience and boost your readiness.

Pass your Microsoft Certified: Azure Cosmos DB Developer Specialty exam with ease. Try our study materials today!

Official Microsoft Azure Cosmos DB Developer Specialty exam info is available on Microsoft website at https://learn.microsoft.com/en-us/credentials/certifications/azure-cosmos-db-developer-specialty/

Prepare your Microsoft Certified: Azure Cosmos DB Developer Specialty exam with confidence!

We provide top-quality DP-420 exam dumps materials that are:

1. Accurate and up-to-date: Reflect the latest Microsoft exam changes and ensure you are studying the right content.
2. Comprehensive Cover all exam topics so you do not need to rely on multiple sources.
3. Convenient formats: Choose between PDF files and online Microsoft Azure Cosmos DB Developer Specialty practice test for easy studying on any device.

Do not waste time on unreliable DP-420 practice test. Choose our proven Microsoft Certified: Azure Cosmos DB Developer Specialty study materials and pass with flying colors. Try Dumps4free Microsoft Azure Cosmos DB Developer Specialty 2024 material today!

Microsoft Certified: Azure Cosmos DB Developer Specialty Exams
  • Assurance

    Microsoft Azure Cosmos DB Developer Specialty practice exam has been updated to reflect the most recent questions from the Microsoft DP-420 Exam.

  • Demo

    Try before you buy! Get a free demo of our Microsoft Certified: Azure Cosmos DB Developer Specialty exam dumps and see the quality for yourself. Need help? Chat with our support team.

  • Validity

    Our Microsoft DP-420 PDF contains expert-verified questions and answers, ensuring you're studying the most accurate and relevant material.

  • Success

    Achieve DP-420 success! Our Microsoft Azure Cosmos DB Developer Specialty exam questions give you the preparation edge.

If you have any question then contact our customer support at live chat or email us at support@dumps4free.com.