Exam questions: DP-900: Microsoft Azure Data Fundamentals

You have an e-commerce application that reads and writes data to an Azure SQL database.

When can you use an Azure Resource Manager template?

You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.

Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:

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

To complete the sentence, select the appropriate option in the answer area.
Descriptive analytics tell you____

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Normalization involves eliminating relationships between database tables.
Normalizing a database reduces data redundancy.
Normalization improves data integrity.

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.

You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.

What are two characteristics of real-time data processing? Each correct answer presents a complete solution.

You need to create an Azure resource to store data in Azure Table storage.

You need to modify a view in a relational database by adding a new column.

You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

Which storage solution supports access control lists (ACLs) at the file and folder level?

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

You have an inventory management database that contains the following table.

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

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.

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?
Each correct answer presents a complete solution.

When you create an Azure SQL database, which account can always connect to the database?

A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense.

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.

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

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

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

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.

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?