Question # 1
You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region
writes. The account contains a database that has two containers named container1 and
container2.
The following is a sample of a document in container1:
{
"customerId": 1234,
"firstName": "John",
"lastName": "Smith",
"policyYear": 2021
}
The following is a sample of a document in container2:
{
"gpsId": 1234,
"latitude": 38.8951,
"longitude": -77.0364
}
You need to configure conflict resolution to meet the following requirements:
For container1 you must resolve conflicts by using the highest value for policyYear.
For container2 you must resolve conflicts by accepting the distance closest to latitude:
40.730610 and longitude: -73.935242.
Administrative effort must be minimized to implement the solution.
What should you configure for each container? To answer, drag the appropriate
configurations to the correct containers. Each configuration may be used once, more than
once, or not at all. You may need to drag the split bar between panes or scroll to view
content.
NOTE: Each correct selection is worth one point.
|
Question # 2
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 + "'" |
C. cmd = "SELECT * FROM Persons p
WHERE p.accountnumber = @accountnumber"
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 # 3
You maintain a relational database for a book publisher. The database contains the
following tables.
The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API
that will replace the relational database. The solution must minimize latency and read
operation costs.
What should you include in the solution? | | A. Create a container for Author and a container for Book. In each Author document,
embed bookId for each book by the author. In each Book document embed authorId of
each author. | | B. Create Author, Book, and Bookauthorlnk documents in the same container. | | C. Create a container that contains a document for each Author and a document for each
Book. In each Book document, embed authorId. | | D. Create a container for Author and a container for Book. In each Author document and
Book document embed the data from Bookauthorlnk. |
A. Create a container for Author and a container for Book. In each Author document,
embed bookId for each book by the author. In each Book document embed authorId of
each author.
Explanation:
Store multiple entity types in the same container.
Question # 4
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 # 5
You need to identify which connectivity mode to use when implementing App2. The
solution must support the planned changes and meet the business requirements.
Which connectivity mode should you identify? | | A. Direct mode over HTTPS | | B. Gateway mode (using HTTPS) | | C. Direct mode over TCP |
Explanation:
Scenario: Develop an app named App2 that will run from the retail stores and query the
data in account2. App2 must be limited to a single DNS endpoint when accessing
account2.
By using Azure Private Link, you can connect to an Azure Cosmos account via a private
endpoint. The private endpoint is a set of private IP addresses in a subnet within your
virtual network.
When you're using Private Link with an Azure Cosmos account through a direct mode
connection, you can use only the TCP protocol. The HTTP protocol is not currently
supported.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-configure-private-endpoints
Question # 6
The following is a sample of a document in orders.
The orders container uses customerId as the partition key.
You need to provide a report of the total items ordered per month by item type. The
solution must meet the following requirements:
Ensure that the report can run as quickly as possible.
Minimize the consumption of request units (RUs).
What should you do? | | A. Configure the report to query orders by using a SQL query. | | B. Configure the report to query a new aggregate container. Populate the aggregates by
using the change feed. | | C. Configure the report to query orders by using a SQL query through a dedicated
gateway. | | D. Configure the report to query a new aggregate container. Populate the aggregates by
using SQL queries that run daily. |
B. Configure the report to query a new aggregate container. Populate the aggregates by
using the change feed.
Explanation: You can facilitate aggregate data by using Change Feed and Azure
Functions, and then use it for reporting.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/change-feed
Question # 7
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.
|
Microsoft DP-420 Exam Dumps
5 out of 5
Pass Your Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam in First Attempt With DP-420 Exam Dumps. Real Microsoft Certified: Azure Cosmos DB Developer Specialty Exam Questions As in Actual Exam!
— 136 Questions With Valid Answers
— Updation Date : 16-Dec-2024
— Free DP-420 Updates for 90 Days
— 98% Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam Passing Rate
PDF Only Price 99.99$
19.99$
Buy PDF
Speciality
Additional Information
Testimonials
Related Exams
- Number 1 Microsoft Microsoft Certified: Azure Cosmos DB Developer Specialty study material online
- Regular DP-420 dumps updates for free.
- Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Practice exam questions with their answers and explaination.
- Our commitment to your success continues through your exam with 24/7 support.
- Free DP-420 exam dumps updates for 90 days
- 97% more cost effective than traditional training
- Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Practice test to boost your knowledge
- 100% correct Microsoft Certified: Azure Cosmos DB Developer Specialty questions answers compiled by senior IT professionals
Microsoft DP-420 Braindumps
Realbraindumps.com is providing Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 braindumps which are accurate and of high-quality verified by the team of experts. The Microsoft DP-420 dumps are comprised of Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB questions answers available in printable PDF files and online practice test formats. Our best recommended and an economical package is Microsoft Certified: Azure Cosmos DB Developer Specialty PDF file + test engine discount package along with 3 months free updates of DP-420 exam questions. We have compiled Microsoft Certified: Azure Cosmos DB Developer Specialty exam dumps question answers pdf file for you so that you can easily prepare for your exam. Our Microsoft braindumps will help you in exam. Obtaining valuable professional Microsoft Microsoft Certified: Azure Cosmos DB Developer Specialty certifications with DP-420 exam questions answers will always be beneficial to IT professionals by enhancing their knowledge and boosting their career.
Yes, really its not as tougher as before. Websites like Realbraindumps.com are playing a significant role to make this possible in this competitive world to pass exams with help of Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 dumps questions. We are here to encourage your ambition and helping you in all possible ways. Our excellent and incomparable Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB exam questions answers study material will help you to get through your certification DP-420 exam braindumps in the first attempt.
Pass Exam With Microsoft Microsoft Certified: Azure Cosmos DB Developer Specialty Dumps. We at Realbraindumps are committed to provide you Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB braindumps questions answers online. We recommend you to prepare from our study material and boost your knowledge. You can also get discount on our Microsoft DP-420 dumps. Just talk with our support representatives and ask for special discount on Microsoft Certified: Azure Cosmos DB Developer Specialty exam braindumps. We have latest DP-420 exam dumps having all Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB dumps questions written to the highest standards of technical accuracy and can be instantly downloaded and accessed by the candidates when once purchased. Practicing Online Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 braindumps will help you to get wholly prepared and familiar with the real exam condition. Free Microsoft Certified: Azure Cosmos DB Developer Specialty exam braindumps demos are available for your satisfaction before purchase order.
Send us mail if you want to check Microsoft DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB DEMO before your purchase and our support team will send you in email.
If you don't find your dumps here then you can request what you need and we shall provide it to you.
Bulk Packages
$60
- Get 3 Exams PDF
- Get $33 Discount
- Mention Exam Codes in Payment Description.
Buy 3 Exams PDF
$90
- Get 5 Exams PDF
- Get $65 Discount
- Mention Exam Codes in Payment Description.
Buy 5 Exams PDF
$110
- Get 5 Exams PDF + Test Engine
- Get $105 Discount
- Mention Exam Codes in Payment Description.
Buy 5 Exams PDF + Engine
 Jessica Doe
Microsoft Certified: Azure Cosmos DB Developer Specialty
We are providing Microsoft DP-420 Braindumps with practice exam question answers. These will help you to prepare your Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB exam. Buy Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 dumps and boost your knowledge.
|
