DP-900 Online Practice Questions and Answers

Correct Answer:

Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

Correct Answer:

Box 1: Yes

Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.

Box 2: No

SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.

Instead use Azure Data Studio to create SQL notebook.

Box 3: Yes

You can use the Azure Data Studio to restore databases.

Reference:https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

Correct Answer:

With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Correct Answer:

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

Correct Answer:

Correct Answer:

Correct Answer: A

Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Correct Answer: D

You must create a separate account for each API.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

Correct Answer: D

Reference: https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Correct Answer: B

A key/value store associates each data value with a unique key.

An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview