Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

  1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Azure Cosmos DB Developer Specialty
  5. DP-420 Discussions
  6. DP-420 Exam Topic 4 Question 37 Discussion

Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB DP-420 Question # 37 Topic 4 Discussion

 Microsoft Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Microsoft Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB DP-420 Question # 37 Topic 4 Discussion

DP-420 Exam Topic 4 Question 37 Discussion:
Question #: 37
Topic #: 4

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 + " ' "

Get Premium DP-420 Questions
Actual exam question for Microsoft DP-420 exam by Echo17171 at Jun 20, 2026, 4:38:01 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next