Question # 1 You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege. Which roles should you assign to User1?
A. CosmosDB Operator only
B. DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor
C. DocumentDB Account Contributor only
D. Cosmos DB Built-in Data Contributor only
Click for Answer
A. CosmosDB Operator only
Answer Description Explanation: Cosmos DB Operator: Can provision Azure Cosmos accounts, databases, and containers. Cannot access any data or use Data Explorer. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/role-based-access-control
Question # 2 You have a container in an Azure Cosmos DB Core (SQL) API account. You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency. What should you include in the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer Description
Question # 3 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 the function?
A. cmd = "SELECT * FROM Persons p WHERE p.accountnumber = 'accountnumber'"
B. cmd = "SELECT * FROM Persons p WHERE p.accountnumber = LIKE @accountnumber"
C. cmd = "SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber"
D. cmd = "SELECT * FROM Persons p WHERE p.accountnumber = '" + accountnumber + "'"
Click for Answer
C. cmd = "SELECT * FROM Persons p WHERE p.accountnumber = @accountnumber"
Answer Description Explanation: Azure Cosmos DB supports queries with parameters expressed by the familiar @ notation. Parameterized SQL provides robust handling and escaping of user input, and prevents accidental exposure of data through SQL injection. For example, you can write a query that takes lastName and address.state as parameters, and execute it for various values of lastName and address.state based on user input. SELECT * FROM Families f WHERE f.lastName = @lastName AND f.address.state = @addressState Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-queryparameterized- queries
Question # 4 You have the following query. SELECT * FROM WHERE c.sensor = "TEMP1" AND c.value < 22 AND c.timestamp >= 1619146031231 You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?
A. a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)
B. a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)
C. a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)
D. a composite index for (sensor ASC, value ASC, timestamp ASC)
Click for Answer
A. a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)
Answer Description If a query has a filter with two or more properties, adding a composite index will improve performance. Consider the following query: SELECT * FROM c WHERE c.name = “Tim” and c.age > 18 In the absence of a composite index on (name ASC, and age ASC), we will utilize a range index for this query. We can improve the efficiency of this query by creating a composite index for name and age. Queries with multiple equality filters and a maximum of one range filter (such as >,<, <=, >=, !=) will utilize the composite index. Reference: https://azure.microsoft.com/en-us/blog/three-ways-to-leverage-compositeindexes- in-azure-cosmos-db/
Question # 5 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.
Answer Description
Question # 6 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.
Click for Answer
C. Register the trigger as a pre-trigger.
Answer Description 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 # 7 You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data. The following is a sample of a document in container1.
Answer Description
Question # 8 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
Click for Answer
Answer Description 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
Up-to-Date
We always provide up-to-date DP-420 exam dumps to our clients. Keep checking website for updates and download.
Excellence
Quality and excellence of our Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB practice questions are above customers expectations. Contact live chat to know more.
Success
Your SUCCESS is assured with the DP-420 exam questions of passin1day.com. Just Buy, Prepare and PASS!
Quality
All our braindumps are verified with their correct answers. Download Microsoft Certified: Azure Cosmos DB Developer Specialty Practice tests in a printable PDF format.
Basic
$80
Any 3 Exams of Your Choice
3 Exams PDF + Online Test Engine
Buy Now
Premium
$100
Any 4 Exams of Your Choice
4 Exams PDF + Online Test Engine
Buy Now
Gold
$125
Any 5 Exams of Your Choice
5 Exams PDF + Online Test Engine
Buy Now
Passin1Day has a big success story in last 12 years with a long list of satisfied customers.
We are UK based company, selling DP-420 practice test questions answers. We have a team of 34 people in Research, Writing, QA, Sales, Support and Marketing departments and helping people get success in their life.
We dont have a single unsatisfied Microsoft customer in this time. Our customers are our asset and precious to us more than their money.
DP-420 Dumps
We have recently updated Microsoft DP-420 dumps study guide. You can use our Microsoft Certified: Azure Cosmos DB Developer Specialty braindumps and pass your exam in just 24 hours. Our Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB real exam contains latest questions. We are providing Microsoft DP-420 dumps with updates for 3 months. You can purchase in advance and start studying. Whenever Microsoft update Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB exam, we also update our file with new questions. Passin1day is here to provide real DP-420 exam questions to people who find it difficult to pass exam
Microsoft Certified: Azure Cosmos DB Developer Specialty can advance your marketability and prove to be a key to differentiating you from those who have no certification and Passin1day is there to help you pass exam with DP-420 dumps. Microsoft Certifications demonstrate your competence and make your discerning employers recognize that Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB certified employees are more valuable to their organizations and customers. We have helped thousands of customers so far in achieving their goals. Our excellent comprehensive Microsoft exam dumps will enable you to pass your certification Microsoft Certified: Azure Cosmos DB Developer Specialty exam in just a single try. Passin1day is offering DP-420 braindumps which are accurate and of high-quality verified by the IT professionals. Candidates can instantly download Microsoft Certified: Azure Cosmos DB Developer Specialty dumps and access them at any device after purchase. Online Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB practice tests are planned and designed to prepare you completely for the real Microsoft exam condition. Free DP-420 dumps demos can be available on customer’s demand to check before placing an order.
What Our Customers Say
Jeff Brown
Thanks you so much passin1day.com team for all the help that you have provided me in my Microsoft exam. I will use your dumps for next certification as well.
Mareena Frederick
You guys are awesome. Even 1 day is too much. I prepared my exam in just 3 hours with your DP-420 exam dumps and passed it in first attempt :)
Ralph Donald
I am the fully satisfied customer of passin1day.com. I have passed my exam using your Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB braindumps in first attempt. You guys are the secret behind my success ;)
Lilly Solomon
I was so depressed when I get failed in my Cisco exam but thanks GOD you guys exist and helped me in passing my exams. I am nothing without you.