AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Azure SQL Managed Instance is a fully functional azure video

Question 1 Be Honest
« Back   Next dp-300-database-admin-assoc Question »
Answer

Full Certification Question

Azure SQL Managed Instance is a fully functional SQL Server instance that is almost 100% compatible with your on-premises ecosystem. It includes features like SQL Agent, access to tempdb, cross-database query and common language runtime (CLR). The service uses the same infrastructure as Azure SQL Database and all the benefits of the PaaS service such as automatic backups, automatic patching, and built-in high availability. Automatic backups are also automatically configured for Azure SQL Managed Instance. By default, the databases in a managed instance are encrypted using Transparent Data Encryption (TDE) with a Microsoft managed key. True or False: In order to take a user-initiated copy only backup, you must turn off TDE for the specific database. If a database is encrypted, you can restore it, however, you'll need to ensure that you have access to either the certificate or asymmetric key that was used to encrypt the database. If you don't have either of those two items, you won't be able to restore the database to a SQL Managed Instance.