Microsoft Azure Data Fundamentals DP-900 Exam Questions

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have a database that stores data in the format shown in the following table.

Of which type of database is this an example?

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?

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

Which service can be used to build extract, transform, and load (ETL) pipelines?

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.

Which type of data store should you use?

You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named accounts account1 stores raw sales transaction data from multiple regions.

You need to create an analytical data store that will ingest and analyze the data.

What should you use?