DP-900 M2-M3

Which deployment requires the fewest changes when migrating an existing SQL Server on-premises solution?

• Azure SQL Database Managed Instance

• SQL Server running on a virtual machine

• Azure SQL Database Single Database

Which of the following statements is true about SQL Server running on a virtual machine?

• You must install and maintain the software for the database management system yourself, but backups are automated

• Software installation and maintenance are automated, but you must do your own backups

• You're responsible for all software installation and maintenance, and performing backups

Which of the following statement is true about Azure SQL Database?

• Scaling up doesn't take effect until you restart the database

• Scaling out doesn't take effect until you restart the database

• Scaling up or out will take effect without restarting the SQL database

When using an Azure SQL Database managed instance, what is the simplest way to implement backups?

• Manual Configuration of the SQL server

• Create a scheduled task to back up

• Backups are automatically handled

What is the best way to transfer the data in a PostgreSQL database running on-premises into a database running Azure Database for PostgreSQL service?

• Export the data from the on-premises database and import it manually into the database running in Azure

• Upload a PostgreSQL database backup file to the database running in Azure

• Use the Azure Database Migration Services

What are the elements of an Azure Table storage key?

• Table name and column name

• Partition key and row key

• Row number

When should you use a block blob, and when should you use a page blob?

• Use a block blob for unstructured data that requires random access to perform reads and writes. Use a page blob for discrete objects that rarely change.

• Use a block blob for active data stored using the Hot data access tier, and a page blob for data stored using the Cool or Archive data access tiers.

• Use a page block for blobs that require random read and write access. Use a block blob for discrete objects that change infrequently.

Why might you use Azure File storage?

• To share files that are stored on-premises with users located at other sites.

• To enable users at different sites to share files.

• To store large binary data files containing images or other unstructured data.

You are building a system that monitors the temperature throughout a set of office blocks, and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country/region, and each building typically contains at least 100 air-conditioned rooms. What type of NoSQL data store is most appropriate for capturing the temperature data to enable it to be processed quickly?

• Send the data to an Azure Cosmos DB database and use Azure Functions to process the data.

• Store the data in a file stored in a share created using Azure File Storage.

• Write the temperatures to a blob in Azure Blob storage.

What is provisioning?

• The act of running series of tasks that a service provider performs to create and configure a service.

• Providing other users access to an existing service.

• Tuning a service to improve performance.