Azure SQL Managed Instance DBA Fundamentals

1. Azure SQL Managed Instance supports which type of backup encryption by default?

No encryption

Customer-managed keys only

Service-managed encryption

Manual encryption required

2. Which migration tool is specifically designed to migrate SQL Server databases to Managed Instance?

Azure Data Studio only

Data Migration Assistant (DMA)

SQL Server Management Studio only

Azure CLI exclusively

3. What does the instance-level collation in Managed Instance control?

Backup retention only

Character set and sorting rules for all databases

Network connectivity options

VCore allocation

4. Which Azure service integrates with Managed Instance for threat detection and vulnerability assessment?

Azure Defender for SQL

Azure Firewall only

Azure DDoS Protection

Azure Load Balancer

5. Azure SQL Managed Instance supports which type of user-initiated backups?

Full backups only

Full and differential backups

Full, differential, and transaction log backups

Copy-only backups

6. What is the purpose of network security groups (NSGs) for Managed Instance?

To encrypt data at rest

To control inbound and outbound network traffic

To manage backup schedules

To scale vCore capacity

7. How are high availability and disaster recovery handled in Business Critical tier?

Manual failover only

Always-On Availability Groups with automatic failover

No built-in redundancy

Read-only replicas only

8. Which SQL Server feature is NOT fully supported in Azure SQL Managed Instance?

Replication

Linked servers

SQL Server Agent

Service Broker

9. What is the network connectivity model for Azure SQL Managed Instance public endpoints?

Always accessible from internet

Accessible only from VNet

Restricted by Network Security Group rules

Requires VPN tunnel always

10. Which monitoring tool is recommended for tracking Managed Instance performance metrics?

SQL Server Management Studio only

Azure Monitor and Diagnostics

Local Event Viewer

Windows Performance Monitor

11. What is the primary advantage of Azure SQL Managed Instance over traditional SQL Server?

Reduced licensing costs only

Fully managed service with near 100% SQL Server compatibility

Faster network throughput guaranteed

No need for database backups

12. What is the maximum number of databases per Azure SQL Managed Instance?

100 databases

500 databases

1000 databases

Unlimited

13. Which feature allows you to restore a database to a specific point in time in Managed Instance?

Full backup only

Point-in-time restore (PITR)

Snapshot backup

Differential backup

14. What is the purpose of a subnet when deploying Azure SQL Managed Instance?

To reduce storage costs

To isolate and secure the managed instance

To improve query performance

To enable multi-region replication

15. Which authentication method is NOT supported by Azure SQL Managed Instance?

SQL authentication

Azure AD authentication

Windows authentication

Certificate-based auth

16. What is the minimum vCore count for a General Purpose Azure SQL Managed Instance?

2 vCores

4 vCores

8 vCores

16 vCores

17. Azure SQL Managed Instance automatically handles which maintenance task?

Manual patching only

OS and SQL Server patching

Hardware replacement planning

User account management

18. Which service tier provides unlimited storage for Azure SQL Managed Instance?

General Purpose

Business Critical

Hyperscale

Standard

19. What is the backup retention period for Azure SQL Managed Instance by default?

7 days

14 days

30 days

35 days

20. Which deployment model allows Azure SQL Managed Instance to run in your own virtual network?

Public endpoint

VNet integration

Shared infrastructure

Hybrid connection only

Azure DBA Azure SQL Managed Instance Basics Quiz