DP-900 Online Practice Questions and Answers

Correct Answer: C

Azure SQL Database is relational database and a managed service.

Incorrect Answers:

A, B: Cosmos DB, HDInsight are non-relational databases.

D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing

Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

Correct Answer: B

Reference: https://azure.microsoft.com/en-us/services/sql-database/#features

Correct Answer: B

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Correct Answer: D

Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

BULK INSERT DELETE INSERT SELECT UPDATE MERGE

Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Correct Answer:

ETL https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Fact table https://www.techtarget.com/searchdatamanagement/definition/facttable#:~:text=A%20fact%20table%20stores%20quantitative,fact%20table%20can%20be%20analyzed.

DW https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

Correct Answer:

Box 1: No

Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.

Box 2: Yes

SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.

Box 3: No

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Correct Answer:

Correct Answer:

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

Correct Answer:

SQL Server on Azure VM SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure. The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

Correct Answer: