DP-900 Practice Test Questions – Microsoft Azure Data Fundamentals

DP-900 Microsoft Azure Data Fundamentals exam is intended for candidates beginning to work with data in the cloud. Candidates for this exam should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. PassQuestion provides you the latest DP-900 Practice Test Questions, which have have a very close similarity with real exam. PassQuestion can promise that you can 100% pass your first time to attend Microsoft DP-900 exam.

DP-900 Practice Test Questions – Microsoft Azure Data Fundamentals

1. 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.

 
 
 
 
 

2. 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?

 
 
 
 

3. Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

Which Azure service should you use?

 
 
 
 

4. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook.

What should you use?

 
 
 
 

5. Which command-line tool can you use to query Azure SQL databases?

 
 
 
 

6. Which statement is an example of Data Definition Language (DDL)?

 
 
 
 

7. 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?

 
 
 
 

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

 
 
 
 

9. You need to design and model a database by using a graphical tool that supports project-oriented offline database development.

What should you use?

 
 
 
 

10. You have a transactional application that stores data in an Azure SQL managed instance.

When should you implement a read-only database replica?

 
 
 
 

New AZ-304 Exam Questions To Pass Microsoft Azure Architect Design
AZ-303 Practice Test Questions - Microsoft Azure Architect Technologies

Leave a Reply

Your email address will not be published. Required fields are marked *