Azure SQL Managed Instance DBA Fundamentals

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

Public endpoint

VNet integration

Shared infrastructure

Hybrid connection only

2. 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

3. 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

4. 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

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

No encryption

Customer-managed keys only

Service-managed encryption

Manual encryption required

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

100 databases

500 databases

1000 databases

Unlimited

7. 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

8. 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

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

SQL authentication

Azure AD authentication

Windows authentication

Certificate-based auth

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

Manual patching only

OS and SQL Server patching

Hardware replacement planning

User account management

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

General Purpose

Business Critical

Hyperscale

Standard

12. 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

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

2 vCores

4 vCores

8 vCores

16 vCores

14. 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

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

Replication

Linked servers

SQL Server Agent

Service Broker

16. 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

17. 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

18. 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

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

Azure Data Studio only

Data Migration Assistant (DMA)