Microsoft Azure DP-900 | Exam Prep

Which data service provides a fully managed database with close to 100% feature parity with Microsoft SQL Server?

• Azure SQL Managed Instance

• Azure SQL Database

• SQL Server on Azure Virtual Machines

• Azure Synapse Analytics

Which (3) open-source databases are available as platform as a service (PaaS) in Azure?

• MariaDB

• MySQL

• PostgreSQL

• CockroachDB

• CouchDB

Which data service allows you to use every feature of Microsoft SQL Server in the cloud?

• Azure SQL Database

• Azure SQL Managed Instance

• SQL Server on an Azure Virtual Machine running on Windows

• SQL Server on an Azure Virtual Machine running on Linux

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

• SQL Server on Azure Virtual Machines

• Azure SQL Database

• Azure SQL Managed Instance

Which open-source database has a built-in support for temporal data?

• MySQL

• MariaDB

• PostgreSQL

• Oracle Database

Which SQL engine is optimized for IoT scenarios?

• SQL Server on Azure Virtual Machines

• Azure SQL Database

• Azure SQL Edge

• Azure SQL Managed Instance

Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?

• Append Blobs

• Block Blobs

• Page Blobs

• Azure Files

Which type of Azure Storage is used to store large amounts of data that must be processed by services such as Azure Databricks, Azure Synapse Analytics, and Azure HDInsight?

• Azure Files

• Azure Data Lake Storage Gen2

• Azure Storage Page Blobs

• Azure Tables Storage

Which Azure Blob storage access tier should you use for data that will be used once per year and can have access time that takes more than an hour?

• Hot

• Archive

• Cold

Which (2) storage solutions can be mounted in Azure Synapse Analytics and is used to process large volumes of data?

• Azure Blob Storage

• Azure Data Lake Storage

• Azure Files

• Azure Table Storage