View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.

 

Question 201

Which Azure service provides a fully managed relational database based on the SQL Server database engine?

1. Azure Storage
2. Azure SQL Database
3. Azure Cosmos DB
4. Azure Cache for Redis

Correct Answer: 2

Explanation

Azure SQL Database is a fully managed relational database service based on the Microsoft SQL Server database engine. Microsoft manages tasks such as underlying infrastructure, patching, backups, and much of the high-availability configuration. Administrators can focus primarily on databases, security, performance, and application connectivity. Azure SQL Database supports several purchasing and service options, allowing organizations to select resources according to workload requirements, performance needs, availability requirements, and cost considerations.

Question 202

Which Azure service provides a managed SQL Server instance with support for many instance-level features?

1. Azure SQL Database
2. Azure Table Storage
3. Azure SQL Managed Instance
4. Azure Blob Storage

Correct Answer: 3

Explanation

Azure SQL Managed Instance provides a managed SQL Server environment with broad compatibility for SQL Server workloads. It supports many instance-level features that are not available in a single Azure SQL Database. Microsoft manages the underlying infrastructure, while administrators can continue using many familiar SQL Server capabilities. Managed Instance is often suitable when an organization wants to migrate existing SQL Server applications to Azure with fewer changes while still benefiting from a managed cloud database platform.

Question 203

Which Azure option provides an Azure virtual machine where the administrator has operating system-level control over SQL Server?

1. Azure SQL Database
2. SQL Server on Azure Virtual Machines
3. Azure SQL Managed Instance
4. Azure Synapse serverless SQL pool

Correct Answer: 2

Explanation

SQL Server on Azure Virtual Machines is an infrastructure-as-a-service option. The administrator has control over the virtual machine operating system, SQL Server installation, files, services, and many configuration settings. This provides more control than fully managed database services but also creates more administrative responsibility. The administrator must handle tasks such as operating system maintenance and many SQL Server management activities. This option is useful when applications require capabilities or configurations that managed Azure SQL services do not provide.

Question 204

Which Azure SQL Database component provides the logical management boundary and connection endpoint for databases?

1. Logical server
2. Storage account
3. Resource group
4. Availability set

Correct Answer: 1

Explanation

An Azure SQL logical server acts as a management boundary for Azure SQL Databases and provides the server endpoint used by clients to connect. It can contain multiple databases and provides settings such as firewall rules and authentication configuration. The logical server does not represent a traditional physical SQL Server machine. Microsoft manages the underlying infrastructure. Understanding this distinction helps administrators correctly configure connectivity, security, database organization, and Azure resource permissions.

Question 205

Which authentication method allows users to connect to Azure SQL Database using Microsoft Entra identities?

1. SQL authentication only
2. Microsoft Entra authentication
3. Windows local account authentication
4. FTP authentication

Correct Answer: 2

Explanation

Microsoft Entra authentication allows users and applications to authenticate to supported Azure SQL services using Microsoft Entra identities. It can reduce dependence on SQL usernames and passwords and supports centralized identity management. Administrators can configure Microsoft Entra administrators and create database users based on appropriate identities. This approach is especially useful in cloud environments where identity-based access, centralized management, and integration with other Azure services are important security requirements.

Question 206

What is the main purpose of a contained database user in SQL Server?

1. To create an operating system account
2. To create a database-scoped user without requiring a traditional server login
3. To configure a firewall rule
4. To create a backup device

Correct Answer: 2

Explanation

A contained database user is associated directly with a database rather than depending on a traditional server-level login. This can simplify database movement between SQL Server instances because authentication information can remain within the database. Contained users are useful in environments where database portability and separation of database-level security are important. Administrators should still assign only the permissions required by the user and should carefully manage authentication and authorization.

Question 207

Which Azure SQL connectivity option allows clients to access a database through a private IP address in an Azure virtual network?

1. Public IP only
2. Private Endpoint
3. Internet Gateway
4. Storage endpoint

Correct Answer: 2

Explanation

An Azure Private Endpoint provides a private IP address within an Azure virtual network for supported Azure services. For Azure SQL, this allows applications to connect privately instead of relying on a publicly accessible endpoint. Private connectivity can reduce exposure to the public internet and support network isolation requirements. Administrators must also configure DNS and appropriate network rules so that clients can correctly resolve and reach the private endpoint.

Question 208

Which Azure SQL Database feature can restrict connections based on client IP addresses?

1. Firewall rules
2. Query Store
3. Transparent Data Encryption
4. Database snapshots

Correct Answer: 1

Explanation

Azure SQL Database firewall rules control which IP addresses or ranges can connect through the public endpoint. Administrators can configure server-level firewall rules and, where supported, database-level firewall rules to limit network access. Firewall rules are an important security control but should not be considered the only protection. Organizations may also use Microsoft Entra authentication, private endpoints, network controls, and least-privilege database permissions to create a stronger overall security design.

Question 209

What is the primary purpose of geo-redundant backups in Azure SQL Database?

1. To improve query execution speed
2. To provide backup copies in another Azure region
3. To increase database indexes
4. To disable automated backups

Correct Answer: 2

Explanation

Geo-redundant backups maintain backup copies in a secondary Azure region. This provides additional protection against a regional outage affecting the primary region. Depending on the service and configuration, these backups can support recovery operations in another region. Geo-redundant backup is different from high availability within the same region because it focuses on regional disaster recovery. Administrators should select backup redundancy based on recovery requirements, data residency considerations, and business continuity objectives.

Question 210

An Azure SQL Database is accidentally deleted. Which recovery option can help restore it if it is still within the supported retention period?

1. Point-in-time restore
2. Query Store
3. Index rebuild
4. Database trigger

Correct Answer: 1

Explanation

Point-in-time restore can be used to recover an Azure SQL Database to a selected time within the available backup retention period. It can also help recover a deleted database when the required backup information remains available. The restored database is typically created as a new database rather than simply making the deleted database reappear. Administrators should understand retention settings and recovery requirements in advance so that accidental deletion does not result in permanent data loss.

Question 211

Which backup type contains all data required to create a baseline for subsequent differential backups?

1. Differential backup
2. Full backup
3. Transaction log backup
4. Copy-only log backup

Correct Answer: 2

Explanation

A full database backup contains the database data needed to establish the baseline used by subsequent differential backups. A differential backup stores changes made since the relevant full backup, while transaction log backups contain transaction log records needed for point-in-time recovery. Administrators should understand the relationship between these backup types when designing a restore strategy. A typical recovery sequence can involve restoring a full backup, the latest differential backup, and then required transaction log backups.

Question 212

Which SQL Server backup type contains only changes made since the most recent full backup?

1. Transaction log backup
2. Full backup
3. Differential backup
4. Copy-only backup

Correct Answer: 3

Explanation

A differential backup contains data changes made since the base full backup. As more changes occur, differential backups can become larger because they continue accumulating changes from that full backup. During restoration, only the latest required differential backup normally needs to be restored after the full backup before applying subsequent transaction log backups. Differential backups can reduce restore time compared with restoring a long sequence of individual transaction log backups.

Question 213

Which backup type records transaction log changes and is essential for point-in-time recovery under the full recovery model?

1. Full backup
2. Differential backup
3. Transaction log backup
4. BACPAC

Correct Answer: 3

Explanation

Transaction log backups capture transaction log records that have not yet been backed up. Under the full recovery model, they are essential for maintaining a transaction log backup chain and supporting point-in-time recovery. Administrators can restore a full backup, an appropriate differential backup, and then a sequence of transaction log backups up to the required recovery point. Regular log backups also help prevent uncontrolled growth of the transaction log.

Question 214

What is the purpose of a copy-only full backup in SQL Server?

1. It changes the differential backup base
2. It creates an independent backup without affecting the normal backup sequence
3. It removes transaction logs
4. It disables automated backups

Correct Answer: 2

Explanation

A copy-only full backup is an independent full backup that does not affect the normal differential backup base. This makes it useful when an administrator needs an additional full backup for a special purpose without changing the regular backup strategy. For example, a copy-only backup can be created for testing or another administrative task while allowing scheduled differential backups to continue using their original full backup as the base.

Question 215

Which backup should be considered before restoring a database after a failure when recent transactions may not yet exist in a previous log backup?

1. Tail-log backup
2. Differential backup
3. Copy-only backup
4. BACPAC export

Correct Answer: 1

Explanation

A tail-log backup captures transaction log records that have not yet been backed up, when the SQL Server recovery situation allows such a backup. It can help preserve the most recent transactions before a restore operation. This is particularly important when minimizing data loss is a priority. Administrators should determine whether the transaction log is accessible and whether the database recovery scenario supports taking a tail-log backup before beginning the restore sequence.

Question 216

Which SQL Server option helps detect corruption in backup data by checking backup pages during backup or restore operations?

1. CHECKSUM
2. TOP
3. OFFSET
4. NOLOCK

Correct Answer: 1

Explanation

The CHECKSUM option can be used with SQL Server backup operations to generate and validate backup checksums. These checksums help detect certain forms of corruption in backup data and provide an additional integrity check. Administrators should understand that checksums do not guarantee that every type of corruption will be detected. Backup verification, regular restore testing, and appropriate monitoring should also be part of a reliable backup and disaster recovery strategy.

Question 217

Which Azure SQL Database feature can automatically apply certain performance recommendations, such as creating or removing indexes?

1. Automatic tuning
2. Database Mail
3. SQL Server Agent
4. Resource Governor

Correct Answer: 1

Explanation

Azure SQL Database automatic tuning can monitor workloads and apply supported performance recommendations automatically when configured to do so. Depending on the available recommendation, automatic tuning can help manage indexes or correct certain query performance issues. Administrators can choose whether recommendations are automatically applied or only monitored. Automatic tuning can reduce manual performance-management effort, but administrators should still monitor workload behavior and validate that automated changes produce the expected results.

Question 218

Which Azure SQL capability uses intelligent analysis to detect database performance issues and provide diagnostic information?

1. Intelligent Insights
2. Azure DNS
3. Azure Storage Explorer
4. Microsoft Defender Antivirus

Correct Answer: 1

Explanation

Intelligent Insights uses intelligent analysis to identify database performance issues in supported Azure SQL environments. It can provide information about detected problems and help administrators understand unusual workload behavior. This can reduce the time required to identify performance issues compared with manually reviewing large amounts of monitoring data. Administrators can use the information alongside Query Store, Azure Monitor, and other diagnostic tools to investigate the underlying cause and determine appropriate corrective actions.

Question 219

Which Azure SQL feature helps identify queries that consume significant amounts of database resources?

1. Query Performance Insight
2. Azure Firewall
3. Private Endpoint
4. Azure Key Vault

Correct Answer: 1

Explanation

Query Performance Insight helps administrators analyze query performance and identify queries that consume significant database resources. It can provide useful information about resource-intensive queries, helping administrators focus optimization efforts where they are most needed. This information can be combined with Query Store data and execution plans for deeper investigation. Administrators can then review indexes, statistics, query design, and other factors that may contribute to excessive CPU, data I/O, or duration.

Question 220

Which Azure SQL Database metric is commonly used to determine how much of the configured DTU capacity is currently being consumed?

1. DTU percentage
2. Storage account percentage
3. Network security percentage
4. DNS percentage

Correct Answer: 3

Explanation

DTU percentage indicates the percentage of the configured DTU capacity currently being consumed by an Azure SQL Database. DTUs combine CPU, memory, and data I/O resources into a single performance measure. Monitoring DTU percentage can help administrators identify whether a database is approaching its selected service-tier capacity. If sustained usage is high, administrators can investigate query performance, indexing, workload patterns, or consider scaling the database to a higher service level.