Microsoft DP-900 Practice Test - Questions Answers, Page 15

List of questions
Question 141

You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Question 142

Which statement is an example of Data Manipulation Language (DML)?
Question 143

Which command-line tool can you use to query Azure SQL databases?
Question 144

Which statement is an example of Data Definition Language (DDL)?
Question 145

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
Question 146

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
Question 147

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
Question 148

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
Question 149

You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)
NOTE: Each correct selection is worth one point.
Question 150

You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
Question