Valid DP-420 Dumps shared by ExamDiscuss.com for Helping Passing DP-420 Exam! ExamDiscuss.com now offer the newest DP-420 exam dumps, the ExamDiscuss.com DP-420 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-420 dumps with Test Engine here:
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?
Correct Answer: C
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