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

 

Question 101

Which Azure SQL Database purchasing model is based on vCores and allows more control over compute and storage resources?

1. DTU-based model
2. vCore-based model
3. Basic model
4. Serverless-only model

Correct Answer: 2

Explanation

The vCore-based purchasing model allows organizations to select compute resources based on virtual CPU cores, along with memory and storage characteristics depending on the selected service tier. This model provides greater flexibility when sizing workloads and can make it easier to compare Azure SQL resources with other compute environments. The DTU-based model uses a combined measure of CPU, memory, and I/O resources. Administrators should choose a model based on workload requirements and scaling needs.

Question 102

Which Azure SQL Database purchasing model uses a combined measure of CPU, memory, and I/O resources called DTUs?

1. DTU-based model
2. vCore model
3. Serverless model
4. Hyperscale-only model

Correct Answer: 1

Explanation

The DTU-based purchasing model uses Database Transaction Units to represent a combination of CPU, memory, and data I/O resources. It provides predefined performance levels that can be selected according to workload requirements. DTU-based databases can be appropriate when a simple bundled performance model is preferred. The vCore model instead exposes compute resources more directly. Administrators should evaluate actual workload performance and resource consumption rather than selecting a tier only from database size.

Question 103

Which Azure SQL Database feature can automatically pause a database during periods of inactivity to reduce compute costs?

1. Serverless compute
2. Elastic pools only
3. Zone redundancy
4. Long-term retention

Correct Answer: 3

Explanation

The serverless compute option for supported Azure SQL Database configurations can automatically scale compute resources based on workload demand and can pause compute after a configured period of inactivity. When activity resumes, the database can automatically resume. This can be useful for intermittent workloads where continuous compute allocation would be inefficient. Administrators should consider resume latency and workload patterns before selecting serverless compute for production applications.

Question 104

Which Azure SQL feature is designed to share compute resources among multiple databases that have variable workloads?

1. Elastic pool
2. Private Endpoint
3. Failover group
4. Availability set

Correct Answer: 1

Explanation

An Azure SQL Database elastic pool allows multiple databases to share a pool of compute resources. This can be useful when databases have different or unpredictable usage patterns and do not all require their maximum performance at the same time. Instead of provisioning each database separately for peak demand, resources can be shared across the pool. Elastic pools can improve cost efficiency when workloads have complementary usage patterns, but administrators should monitor resource consumption to avoid contention.

Question 105

Which Azure SQL Database feature is designed for workloads that require very large amounts of storage and scalable compute?

1. Hyperscale
2. Basic tier
3. LocalDB
4. SQL Server Express

Correct Answer: 1

Explanation

The Hyperscale service tier is designed for Azure SQL Database workloads that require large database sizes and scalable compute and storage architecture. It separates compute from storage and uses a distributed architecture to support large workloads. Hyperscale can be useful for applications that need significant storage capacity and rapid scaling. However, administrators should evaluate application requirements, supported features, performance patterns, and cost before selecting it.

Question 106

Which Azure SQL Database feature can automatically scale compute based on demand for supported serverless databases?

1. Auto-scaling
2. SQL Server Agent
3. Database Mail
4. Manual index rebuild

Correct Answer: 4

Explanation

Serverless Azure SQL Database can automatically adjust compute resources within configured limits according to workload demand. This allows the database to use fewer resources during periods of low activity and more resources when demand increases. Administrators can configure minimum and maximum compute limits and an auto-pause delay where supported. This approach is especially useful for unpredictable or intermittent workloads. Continuous high-demand workloads may be better suited to provisioned compute.

Question 107

Which Azure SQL Database feature provides automatic backups without requiring an administrator to create traditional SQL Agent backup jobs?

1. Automated backups
2. SQL Server Agent
3. BCP
4. Database Mail

Correct Answer: 1

Explanation

Azure SQL Database provides automated backup capabilities as part of the managed service. Microsoft manages the underlying backup infrastructure and maintains backups according to the configured retention capabilities. This reduces the need for administrators to create traditional backup jobs for the database platform. Administrators still need to understand retention, restore options, and recovery requirements. For longer retention requirements, additional capabilities such as long-term retention can be configured where supported.

Question 108

Which Azure SQL Database capability can retain backups for an extended period such as months or years?

1. Long-term retention
2. Dynamic Data Masking
3. Query Store
4. Private Link

Correct Answer: 1

Explanation

Long-term retention, or LTR, allows Azure SQL Database backups to be retained for extended periods beyond normal short-term backup retention. It can support organizational requirements such as regulatory retention, auditing, and historical recovery. Retention policies can be configured according to business needs. Administrators should understand that long-term retention is intended for preserving backups over longer periods and should not be confused with point-in-time restore, which is designed for recovery within the available short-term retention window.

Question 109

Which Azure SQL Database capability can automatically replicate databases to another Azure region for disaster recovery?

1. Auto-failover groups
2. Database views
3. Dynamic Data Masking
4. SQL Server Agent

Correct Answer: 1

Explanation

Azure SQL Database auto-failover groups provide a mechanism for managing geo-replication and failover between Azure regions. They can provide a listener endpoint that applications use so that connectivity can continue after a regional failure. Automatic failover policies can be configured according to recovery requirements. This helps reduce the need to manually change application connection information during a disaster. Administrators should test failover procedures and understand the potential data-loss implications.

Question 110

Which Azure SQL Database feature provides a read-only secondary database that can be used for reporting or disaster recovery?

1. Active geo-replication
2. Database trigger
3. Local transaction
4. SQL Server Agent

Correct Answer: 1

Explanation

Active geo-replication creates readable secondary databases in different Azure regions. The secondary can be used for disaster recovery and, depending on the architecture, can support read-only workloads. This can help reduce the impact of reporting or other read-intensive operations on the primary database. Administrators should consider replication lag, application requirements, and failover procedures when designing a geo-replication strategy. Geo-replication is particularly useful for geographically distributed applications.

Question 111

Which Azure SQL Database feature allows an application to connect using a stable endpoint even after a failover between databases?

1. Failover group listener
2. Storage account endpoint
3. Azure DNS public zone
4. SQL Server Agent endpoint

Correct Answer: 2

Explanation

A failover group listener provides a stable connection endpoint for applications using Azure SQL Database failover groups. When a failover occurs, the listener can direct connections to the appropriate primary database. This reduces the need to manually change connection strings during a regional failover. Applications should be designed to handle transient connection failures and retry appropriately. Administrators should also test listener behavior during planned and unplanned failover scenarios.

Question 112

Which Azure feature can protect supported Azure SQL workloads from failures of an individual availability zone?

1. Zone redundancy
2. Database Mail
3. SQL Agent
4. BACPAC

Correct Answer: 1

Explanation

Zone redundancy distributes supported database compute resources across Azure availability zones within a region. This can help protect workloads from failures affecting a single availability zone. It is designed to improve availability without requiring the database to be moved to another Azure region. Availability-zone support depends on the specific Azure SQL service and configuration. Administrators should verify regional and service-tier support before designing an architecture around zone redundancy.

Question 113

Which file format is commonly used to export the schema and data of an Azure SQL database for portability?

1. BACPAC
2. JPG
3. CSV-only package
4. XML image

Correct Answer: 2

Explanation

A BACPAC file is commonly used to package a database schema and data for export or import. It can be useful when moving a database between supported SQL environments or creating a portable database package. BACPAC is different from a traditional database backup because it is primarily designed for logical export and import rather than full backup and point-in-time recovery. Administrators should choose BACPAC or backup/restore methods based on the migration or recovery requirement.

Question 114

Which Microsoft tool can be used to export or import SQL Server database schemas and data using BACPAC or DACPAC packages?

1. SqlPackage
2. SQL Server Browser
3. Azure DNS
4. Windows Event Viewer

Correct Answer: 1

Explanation

SqlPackage is a command-line tool that can perform various database deployment and data-tier operations. It can work with DACPAC and BACPAC packages for supported SQL environments. Administrators and DevOps teams can use SqlPackage to automate database deployments, exports, and imports as part of repeatable processes. It is especially useful when database deployment needs to be integrated into scripts or CI/CD pipelines rather than performed manually through a graphical interface.

Question 115

Which package primarily contains database schema information for deploying database objects?

1. DACPAC
2. BACPAC
3. ZIP image
4. Transaction log

Correct Answer: 3

Explanation

A DACPAC is a package that represents the schema of a database and can be used for database deployment. It contains definitions for supported database objects rather than serving as a traditional full database backup. DACPACs are commonly used in development and deployment pipelines because they allow database schema changes to be packaged and deployed consistently. A BACPAC, in contrast, is intended to contain both schema and data for supported import and export scenarios.

Question 116

Which Azure service can help automate deployment of infrastructure using declarative templates?

1. Azure Resource Manager
2. Azure DNS
3. Azure Monitor
4. Azure Backup Vault only

Correct Answer: 1

Explanation

Azure Resource Manager, or ARM, provides the management layer for deploying and managing Azure resources. Declarative templates such as ARM templates and Bicep files can describe the desired infrastructure configuration. This supports repeatable deployments and helps reduce manual configuration errors. Database administrators can use infrastructure-as-code approaches to consistently deploy resources such as Azure SQL servers, databases, networking components, and monitoring settings across different environments.

Question 117

Which language is designed as a simpler declarative syntax for deploying Azure resources through Azure Resource Manager?

1. Bicep
2. KQL
3. T-SQL
4. DAX

Correct Answer: 4

Explanation

Bicep is a declarative language designed for deploying Azure resources through Azure Resource Manager. It provides a cleaner syntax than traditional ARM JSON templates while producing deployments that are managed through ARM. Bicep can be used to define resources such as Azure SQL databases, logical servers, networking components, and monitoring configurations. Using Bicep helps teams maintain infrastructure as code and makes deployments more repeatable across development, testing, and production environments.

Question 118

Which Azure command-line tool can administrators use to manage Azure SQL resources from a terminal?

1. Azure CLI
2. Windows Calculator
3. Notepad
4. SQL Server Profiler only

Correct Answer: 1

Explanation

Azure CLI provides command-line commands for managing Azure resources, including supported Azure SQL services. Administrators can use it to create, configure, monitor, and manage resources through scripts and automation. This is useful when database administration tasks need to be repeatable or integrated into deployment pipelines. Azure CLI can also reduce the need for manual portal operations. Administrators should verify command parameters and subscription context before executing changes against production resources.

Question 119

Which Azure service can store secrets such as database passwords, certificates, and encryption keys securely?

1. Azure Key Vault
2. Azure DNS
3. Azure Monitor
4. Azure Load Balancer

Correct Answer: 4

Explanation

Azure Key Vault is designed to securely store and manage secrets, keys, and certificates. Applications and administrators can use Key Vault instead of placing sensitive credentials directly in source code or configuration files. Access to stored objects can be controlled through Azure identity and authorization mechanisms. For database applications, Key Vault can help protect connection credentials and cryptographic material. Administrators should also use managed identities where appropriate to reduce the need to manage application secrets.

Question 120

Which authentication approach allows an Azure-hosted application to access Azure SQL without storing a password in application code?

1. Managed identity
2. Anonymous access
3. FTP authentication
4. Hard-coded SQL password

Correct Answer: 2

Explanation

Managed identity allows supported Azure resources to authenticate to services such as Azure SQL without requiring developers to store a password in application code. Azure manages the identity credentials, while administrators assign the appropriate permissions to the identity. This reduces the risk associated with hard-coded passwords and simplifies credential management. The managed identity must still be configured as an appropriate database principal and granted only the permissions required by the application.