DP-900_Modulo_2

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 back ups

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

Which of the following statements best describes the benefits of the elastic pool option when it comes to Azure SQL Database

• With the elastic option, the database automatically scales, and resources are allocated or deallocated as required

• With the elastic option, Microsoft manages the server, so all ou have to do is configure the database, create your tables, and populate them with your data

• With the elastic option, multiple, databases can share the same resources, such as memory, data storage space, and processing power

• With the elastic option, you can manually scale the database if you need additnal storage space, memory or processing power

Which of the Azure SQL Database options listed below would be the best choice if a company wanted to lift-and-shift an on-premises SQL server instance into the cloud without the management overhead of a virtual machine?

• Single Database

• Managed Instance

• Elastic Pool

• PostgreSQL

Which o the folloing relational database management systems is defined as a,'hybrid relational-object database'?

• MySQL

• MariaDB

• PostgreSQL

• Oracle Database

Which approach for provisioning an SQL Database ensures consistency across the development lifecycle?

• The azure Portal

• The Azure command-line interface

• Azure PowerShell

• Azure Resources Manager Templates

Which of the following statements best describes how, by default, applications outside Azure connect to an Azure SQL Database?

• Connections have a connection policy of Proxy. A policy of Proxy means the connection is established via the gateway, and all subsequent requests flow through the gateway.

• Connections have a connection policy of Proxy. A policy of Proxy means the connection is established via the gateway, and all subsequent requests flow through the gateway.

• Connections go directly to the node hosting the Database and do not pass through a gateway at all.

• None of the alternatives

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