Courseiva

CCNA Configure and manage automation of tasks Questions

75 of 172 questions · Page 2/3 · Configure and manage automation of tasks · Answers revealed

Practice these questionsDomain overviewAll questions
76
MCQmedium

Refer to the exhibit. You run this KQL query in Azure Monitor Log Analytics for an Azure SQL Database. What type of events does the query return?

A.Failed logins
B.Schema changes
C.Audit log modifications
D.Data manipulation statements
AnswerC

AUSC indicates audit change events.

Why this answer

Option C is correct because action_id_s == 'AUSC' corresponds to AUDIT_CHANGE events in SQL Server audit logs. Option A is wrong because 'AUSC' is not for schema changes. Option B is wrong because it is not for logins.

Option D is wrong because it is not for data modifications.

Practice this question →
77
Multi-Selectmedium

You are implementing automation for an Azure SQL Database. Which TWO scenarios are appropriate for using elastic database jobs? (Choose two.)

Select 2 answers
A.Scaling up a database when CPU usage is high
B.Checking data consistency across multiple databases
C.Creating logins and users across multiple databases
D.Rebuilding indexes across all databases in an elastic pool
E.Performing a full database backup
AnswersB, D

Data consistency checks can be run across databases.

Why this answer

Elastic jobs are designed for executing administrative tasks across multiple databases. Index maintenance and data consistency checks are common use cases. Option C is wrong because scaling is better done with other automation.

Option D is wrong because backup is automatically managed. Option E is wrong because user management across databases is better done with contained users or Entra ID.

Practice this question →
78
Multi-Selectmedium

You need to automate the backup strategy for an Azure SQL Database to meet a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 1 hour. Which THREE features should you combine? (Choose three.)

Select 3 answers
A.Long-term retention (LTR) backup policy.
B.Active geo-replication.
C.Azure Backup service.
D.Auto-failover group.
E.Point-in-time restore (PITR).
AnswersA, B, D

LTR provides archival backups beyond the PITR retention.

Why this answer

Options A, C, and D are correct. Active geo-replication provides automatic failover with low RPO, long-term retention for archival, and auto-failover groups for automated failover. Option B is wrong because point-in-time restore does not provide automated failover.

Option E is wrong because Azure Backup service is not used for Azure SQL Database.

Practice this question →
79
MCQmedium

Your company uses Azure SQL Managed Instance and wants to automate the creation of new databases for each development sprint. Each database must be a copy of a template database with specific schema and data. You need to recommend an automation solution that minimizes manual steps and integrates with your CI/CD pipeline. What should you use?

A.Deploy an Azure Logic App with a SQL connector that triggers on a schedule.
B.Use the Azure portal's 'Create database from backup' feature.
C.Create an Elastic Database Job that runs CREATE DATABASE AS COPY OF...
D.Use an Azure DevOps pipeline with a PowerShell task that runs the 'az sql db copy' command or the Restore-AzSqlDatabase cmdlet.
AnswerD

Azure DevOps integrates with Azure CLI or PowerShell to automate database copy, and can be triggered by commits, fitting CI/CD needs.

Why this answer

Azure SQL Managed Instance supports database copy via T-SQL, which can be automated with Elastic Jobs or DevOps pipelines. However, for CI/CD integration, Azure DevOps with the SQL Server database project (DACPAC) and Azure CLI is the most standard approach. Option C is correct.

Option A is unsupported. Option B is for Azure SQL Database. Option D requires more custom scripting.

Practice this question →
80
MCQeasy

You need to automate the backup of an Azure SQL Database to a storage account in a different region for disaster recovery. What should you configure?

A.Azure Backup for SQL Server in Azure VM
B.Configure geo-redundant backup storage
C.Configure long-term retention (LTR) in the same region
D.Elastic Database Job to export to BACPAC
AnswerB

Azure SQL Database offers geo-redundant storage by default.

Why this answer

Option D is correct because Azure SQL Database automatically provides geo-redundant backup storage (RA-GRS) which replicates to a paired region. Option A is wrong because Azure Backup is for VMs, not Azure SQL Database. Option B is wrong because it only copies to a single region.

Option C is wrong because Elastic Jobs can copy but not automatically.

Practice this question →
81
MCQmedium

You need to automate the creation of a new Azure SQL Database whenever a new customer signs up. The solution should use infrastructure as code and integrate with your CI/CD pipeline. What should you use?

A.Create an Azure Automation runbook that calls New-AzureRmSqlDatabase and trigger it from your CI/CD pipeline.
B.Create an ARM template that defines the database and deploy it from your CI/CD pipeline.
C.Set up an Elastic Database Job that runs a CREATE DATABASE statement.
D.Configure a SQL Server Agent job on the logical server to run a CREATE DATABASE statement.
AnswerB

ARM templates are the recommended way to provision Azure resources declaratively and can be deployed via Azure DevOps.

Why this answer

B is correct because ARM (Azure Resource Manager) templates are the recommended infrastructure-as-code approach for defining and deploying Azure SQL Databases in a repeatable, declarative manner. Integrating ARM template deployment into a CI/CD pipeline ensures consistent, version-controlled database creation as part of automated workflows, aligning with DevOps best practices.

Exam trap

The trap here is that candidates may confuse operational automation (e.g., runbooks, SQL Agent jobs) with infrastructure-as-code provisioning, mistakenly choosing a scripting or T-SQL approach instead of the declarative ARM template method that natively integrates with CI/CD pipelines.

How to eliminate wrong answers

Option A is wrong because Azure Automation runbooks using the deprecated New-AzureRmSqlDatabase cmdlet (AzureRM module) are not infrastructure as code; they rely on imperative scripting, lack declarative state management, and the AzureRM module is being replaced by Az PowerShell, making this approach outdated and less reliable for CI/CD integration. Option C is wrong because Elastic Database Jobs are designed for executing T-SQL scripts across multiple databases (e.g., schema maintenance, data updates), not for provisioning new databases; they cannot create a new database as part of a CI/CD pipeline. Option D is wrong because SQL Server Agent jobs run within the context of a single logical server and are not designed for infrastructure-as-code automation; they lack integration with CI/CD pipelines, version control, and declarative deployment, and are intended for administrative tasks like maintenance, not provisioning new databases from external triggers.

Practice this question →
82
MCQhard

You are a database administrator for a SaaS company that uses Azure SQL Database with elastic pools. The company has hundreds of databases (one per tenant). You need to automate the deployment of schema changes (e.g., adding new columns, creating indexes) across all tenant databases. The changes must be deployed in a rolling fashion to avoid affecting all tenants at once. The automation must track which databases have been updated and allow for rollback of individual tenant databases if needed. Additionally, the solution must integrate with Azure DevOps CI/CD pipelines. What should you do?

A.Use Azure Data Factory with a ForEach activity to execute stored procedures in each database.
B.Create an Azure Automation runbook that connects to each database sequentially and runs ALTER TABLE statements.
C.Configure SQL Agent jobs on each database to run the schema changes.
D.Develop an Azure SQL Database project in Visual Studio, generate a DACPAC, and use Elastic Database Jobs with a custom tracking table to apply the DACPAC to each tenant database in batches. Integrate with Azure DevOps to trigger the job after build.
AnswerD

DACPAC provides version-controlled schema deployment, and Elastic Jobs allows rolling out to specific databases with tracking.

Why this answer

Option D is correct. Using a combination of Azure SQL Database project (DACPAC) for schema definition and Elastic Database Jobs for targeted deployment allows rolling updates per tenant. Azure DevOps can trigger the jobs.

Option A is incorrect because Azure Automation is not designed for multi-tenant schema deployment. Option B is incorrect because Data Factory is for data movement, not schema deployment. Option C is incorrect because SQL Agent is not available in Azure SQL Database.

Practice this question →
83
MCQeasy

You need to automate the deployment of an Azure SQL Database along with its firewall rules and performance tier using infrastructure as code. Which technology should you use?

A.Bicep templates
B.SQL Server Data Tools (SSDT) database projects
C.T-SQL scripts
D.PowerShell scripts
AnswerA

Bicep is the native Azure IaC language for deploying Azure resources including SQL Database, firewall rules, and performance settings.

Why this answer

Bicep is a domain-specific language for deploying Azure resources declaratively. It is the recommended infrastructure as code tool for Azure. Option B is correct.

Option A is for SQL Server deployments only. Option C is a scripting language, not IaC. Option D is for database schema changes, not resource deployment.

Practice this question →
84
MCQmedium

You are managing an Azure SQL Database that requires automated index maintenance. You want to use a solution that minimizes administrative overhead and leverages built-in Azure capabilities. Which approach should you recommend?

A.Enable automatic tuning for the database and configure the 'CREATE INDEX' and 'DROP INDEX' recommendations.
B.Deploy a third-party maintenance solution and connect it to the Azure SQL Database.
C.Create a custom PowerShell script and run it via Azure Automation Runbook on a schedule.
D.Schedule a SQL Agent job to rebuild indexes using a T-SQL script.
AnswerA

Automatic tuning handles index management automatically based on workload patterns.

Why this answer

Option C is correct because Azure SQL Database's automatic tuning can automatically create and drop indexes based on workload patterns, minimizing manual overhead. Option A is wrong because Elastic Database Jobs require custom scripting and are not fully automated. Option B is wrong because it still requires manual scheduling and maintenance.

Option D is wrong because it is a third-party tool and not built-in.

Practice this question →
85
MCQhard

Refer to the exhibit. You are configuring an Azure Automation schedule for a runbook that backs up Azure SQL Databases. The runbook should run daily at midnight. However, the runbook runs twice a day. What is the most likely cause?

A.The startTime is set to a past date
B.The schedule does not specify a time zone
C.Both interval and schedule.interval are defined, causing two triggers per day
D.The intervalUnit is set to Minutes instead of Days
AnswerC

Duplicate interval definitions cause the schedule to fire twice.

Why this answer

Option C is correct because the configuration has both 'interval' (1440 minutes = 1 day) and 'schedule.interval' (P1D = 1 day), causing the runbook to trigger twice daily. Option A is wrong because time zone doesn't cause double firing. Option B is wrong because the start time is set.

Option D is wrong because the interval unit is minutes, not days.

Practice this question →
86
MCQhard

You are the database administrator for a large e-commerce company. The company uses Azure SQL Database for its product catalog, which is updated frequently during business hours. To maintain query performance, you have automated index maintenance using Elastic Database Jobs. The job runs every night at 2:00 AM and rebuilds indexes with a fill factor of 80. However, you notice that the job is taking longer than expected, often running until 6:00 AM, and sometimes it fails due to timeouts. You also observe that index fragmentation is still high after the job completes. The database is in the General Purpose service tier with 100 DTUs. Which action should you take to improve the situation?

A.Create a second Elastic Database Job to run at 4:00 AM to rebuild indexes that failed.
B.Change the fill factor to 70 to reduce future fragmentation.
C.Modify the job to reorganize indexes instead of rebuilding them, and use a lower degree of parallelism.
D.Increase the DTU level of the database to 200 DTUs to speed up the index rebuild.
AnswerC

Reorganizing indexes is an online operation that uses fewer resources and can complete faster; reducing parallelism further reduces resource contention, and the job is less likely to timeout.

Why this answer

Option C is correct because reorganizing indexes is a less resource-intensive operation than rebuilding, which reduces the job duration and avoids timeouts. Additionally, using a lower degree of parallelism (MAXDOP) prevents excessive resource contention, which is critical for a General Purpose database with only 100 DTUs. Reorganizing also addresses fragmentation without the overhead of a full rebuild, making it more suitable for the limited resources and nightly maintenance window.

Exam trap

The trap here is that candidates assume rebuilding indexes is always the best maintenance strategy, but for resource-constrained databases with frequent updates, reorganizing with controlled parallelism is more efficient and avoids timeouts.

How to eliminate wrong answers

Option A is wrong because creating a second job to rebuild failed indexes does not address the root cause of timeouts or high fragmentation; it only adds another maintenance window that may also fail under the same resource constraints. Option B is wrong because lowering the fill factor to 70 increases page splitting and fragmentation over time, exacerbating the problem rather than solving it; fill factor should be set based on update patterns, not as a fragmentation fix. Option D is wrong because increasing DTUs to 200 would speed up the rebuild but does not resolve the underlying issue of the job taking too long and failing; it also incurs additional cost without addressing the fragmentation persistence or the job's timeout configuration.

Practice this question →
87
MCQhard

Your company has a policy to automatically pause Azure SQL Databases during non-business hours to save costs. You need to implement this with minimal administrative overhead. What should you use?

A.Elastic Database Job that pauses the database
B.Serverless compute tier with auto-pause enabled
C.Azure Logic Apps with SQL connector to execute pause/resume
D.Azure Automation runbook with a schedule to pause/resume
AnswerB

Serverless automatically pauses during inactivity, meeting the requirement with no overhead.

Why this answer

Option A is correct because the serverless compute tier can be configured to auto-pause after a period of inactivity. Option B is wrong because Elastic Jobs require creating a job. Option C is wrong because Azure Automation runbooks require scripting and maintenance.

Option D is wrong because Logic Apps add complexity.

Practice this question →
88
MCQhard

You manage an Azure SQL Managed Instance that hosts several databases. You need to automate the process of patching the operating system and SQL Server engine with minimal downtime. What should you use?

A.Configure the maintenance window for the Managed Instance.
B.Use an Elastic Job agent to run a script that applies updates.
C.Schedule a manual patching using the Azure portal.
D.Use Azure Update Manager to schedule patching.
AnswerA

Managed Instance automatically applies updates during the configured maintenance window.

Why this answer

Option A is correct because Managed Instance automatically handles patching during the configured maintenance window. Option B is wrong because Azure Update Manager is not applicable to Managed Instance. Option C is wrong because manual patching is not automated.

Option D is wrong because elastic jobs are for database-level tasks, not patching.

Practice this question →
89
Multi-Selectmedium

You need to automate the monitoring of Azure SQL Database performance and receive alerts when certain conditions are met. Which TWO Azure services can be used together to achieve this?

Select 2 answers
A.Azure Sentinel
B.Log Analytics Workspace
C.Azure Monitor Alerts
D.Application Insights
E.Azure Advisor
AnswersB, C

Stores and queries diagnostic logs from SQL Database.

Why this answer

Options B and D are correct because Azure Monitor collects metrics and logs from Azure SQL Database, and Log Analytics can analyze the data; Azure Monitor Alerts can trigger actions. Option A (Application Insights) is for application-level monitoring. Option C (Azure Sentinel) is for security.

Option E (Azure Advisor) provides recommendations but not real-time alerts.

Practice this question →
90
MCQeasy

You are tasked with automating index maintenance for an Azure SQL Database. Which Azure service should you use to run T-SQL scripts on a recurring schedule?

A.SQL Server Agent
B.Elastic Database Jobs
C.Azure Automation Runbook
D.Azure Logic Apps
AnswerB

Elastic Database Jobs are specifically designed to run T-SQL scripts on a schedule across one or more Azure SQL databases.

Why this answer

Elastic Database Jobs (B) is the correct service for automating T-SQL script execution across Azure SQL Database on a recurring schedule. It is specifically designed for Azure SQL Database and Azure SQL Managed Instance, providing a job scheduler that can run T-SQL scripts against multiple databases, handle retries, and manage job history. SQL Server Agent is not available in Azure SQL Database (only in SQL Server on-premises or Azure SQL Managed Instance), making Elastic Database Jobs the appropriate choice for this PaaS scenario.

Exam trap

The trap here is that candidates confuse SQL Server Agent (available in Azure SQL Managed Instance) with Azure SQL Database (single database/elastic pool), mistakenly assuming Agent is available for all Azure SQL offerings, when in fact Elastic Database Jobs is the correct scheduler for the PaaS Azure SQL Database service.

How to eliminate wrong answers

Option A is wrong because SQL Server Agent is not available in Azure SQL Database (single database or elastic pool); it is only supported in SQL Server on-premises, Azure SQL Managed Instance, and SQL Server on Azure VMs. Option C is wrong because Azure Automation Runbooks are designed for PowerShell or Python workflows, not for direct T-SQL execution against Azure SQL Database; they would require additional modules and connection management, making them less suitable for simple recurring T-SQL scripts. Option D is wrong because Azure Logic Apps are orchestration services for integrating apps and data, not a native T-SQL scheduler; they can execute SQL queries via connectors but lack the built-in job scheduling, retry policies, and database-targeting features of Elastic Database Jobs.

Practice this question →
91
MCQeasy

Your organization uses Azure SQL Database and needs to automate email notifications when a database reaches 80% storage usage. Which native Azure feature can you use?

A.Create an Azure Monitor alert rule on the 'storage_percent' metric with an email action group.
B.Create a SQL Agent alert that fires when the storage is above 80% and sends an email.
C.Configure Database Mail to send alerts automatically.
D.Create an Elastic Database Job that checks storage and sends email via sp_send_dbmail.
AnswerA

Azure Monitor alerts are the standard way to send notifications based on metrics.

Why this answer

Option A is correct because Azure Alert Rules can monitor metrics like storage percent and trigger email actions. Option B is wrong because SQL Agent is not available in Azure SQL Database. Option C is wrong because Elastic Jobs execute T-SQL, not send email directly.

Option D is wrong because Database Mail is not available in Azure SQL Database.

Practice this question →
92
MCQmedium

You need to automate the creation of an Azure SQL Database using Azure CLI in a CI/CD pipeline. The database name must be unique and include the build ID. How should you specify the database name in the Azure CLI command?

A.Use the $RANDOM variable in Bash
B.Use the $(uuid) function in Azure CLI
C.Use a hardcoded name like 'mydb'
D.Use an environment variable $(Build.BuildId) set by the pipeline
AnswerD

Azure DevOps provides unique build IDs that can be referenced as environment variables.

Why this answer

Option C is correct because Azure CLI can use environment variables set by the pipeline, combined with a static prefix. Option A uses a fixed name, which fails on rebuilds. Option B is not standard.

Option D is for Bash, not cross-platform.

Practice this question →
93
MCQeasy

You need to automate the deployment of an Azure SQL Database using Infrastructure as Code. The deployment should include the database, firewall rules, and threat detection settings. Which tool should you use?

A.Azure CLI scripts
B.Azure Automation runbooks
C.Azure Policy
D.Azure Resource Manager templates
AnswerD

ARM templates define resources declaratively and can deploy database, firewall, and settings.

Why this answer

Azure Resource Manager (ARM) templates are the native IaC for Azure. Azure Automation runbooks can deploy but are not declarative. Azure CLI can script deployments but is imperative.

Azure Policy is for governance, not deployment.

Practice this question →
94
MCQmedium

You are a database administrator for an Azure SQL Managed Instance. You need to automate the deployment of schema changes across multiple databases in an elastic pool. Which Azure service should you use to orchestrate these deployments?

A.Azure Functions
B.Azure Automation
C.Azure DevOps
D.Azure Logic Apps
AnswerC

Azure DevOps provides release pipelines for deploying schema changes across multiple databases.

Why this answer

Azure DevOps with its release pipelines can manage the deployment of schema changes across multiple databases. Option A is wrong because Azure Automation primarily manages infrastructure tasks, not database schema deployments. Option B is wrong because Azure Logic Apps is for workflow integration, not database schema deployment.

Option D is wrong because Azure Functions is for event-driven code, not orchestrated deployments.

Practice this question →
95
MCQhard

Refer to the exhibit. An Azure SQL Database has the above ARM template for long-term retention (LTR) backup policy. Which statement is true about the retention duration?

A.Monthly backups are retained for 12 months.
B.Yearly backups are retained for 10 years.
C.Yearly backups are retained for 5 years.
D.Weekly backups are retained for 1 week.
AnswerC

YearlyRetention is P5Y, which equals 5 years.

Why this answer

Option D is correct. The yearlyRetention is P5Y (5 years), weeklyRetention is P2W (2 weeks), monthlyRetention is P6M (6 months). Option A is wrong because weeklyRetention is 2 weeks, not 1 week.

Option B is wrong because monthlyRetention is 6 months. Option C is wrong because yearlyRetention is 5 years.

Practice this question →
96
MCQeasy

You are designing an automated backup retention policy for an Azure SQL Database. The business requirement is to retain daily backups for 30 days, weekly backups for 12 weeks, monthly backups for 12 months, and yearly backups for 7 years. Which backup retention type should you configure?

A.Point-in-time restore (PITR) retention
B.Backup vault with Azure Backup
C.Long-term retention (LTR) policy
D.Automated backup policy
AnswerC

LTR allows you to retain full backups for up to 10 years with configurable weekly, monthly, and yearly cycles.

Why this answer

Long-term retention (LTR) is specifically designed to retain backups beyond the point-in-time restore (PITR) window, supporting daily, weekly, monthly, and yearly retention periods. Option B is correct. Option A is too short.

Option C is not a feature. Option D is a feature of Azure SQL Managed Instance, not Azure SQL Database.

Practice this question →
97
MCQhard

Refer to the exhibit. You are monitoring index fragmentation in an Azure SQL Database. You need to automate the rebuild of this index when fragmentation exceeds 50%. The rebuild must be online to minimize downtime. Which T-SQL statement should you include in your automated maintenance job?

A.ALTER INDEX Orders ON Orders REBUILD;
B.ALTER INDEX ALL ON Orders REBUILD WITH (ONLINE = ON);
C.ALTER INDEX ALL ON Orders REORGANIZE;
D.ALTER INDEX ALL ON Orders REBUILD WITH (ONLINE = OFF);
AnswerB

Online rebuild minimizes downtime.

Why this answer

Option B is correct because it uses the `ALTER INDEX ALL ON Orders REBUILD WITH (ONLINE = ON)` statement, which rebuilds all indexes on the table online, allowing concurrent user access and minimizing downtime. This meets the requirement to automate the rebuild when fragmentation exceeds 50%, as online rebuilds are supported in Azure SQL Database for this purpose.

Exam trap

The trap here is that candidates often confuse `REORGANIZE` with `REBUILD` for high fragmentation, or they overlook the `ONLINE = ON` option, assuming all rebuilds are online by default in Azure SQL Database.

How to eliminate wrong answers

Option A is wrong because it only rebuilds the index named 'Orders' (which is likely the table name, not an index name) and defaults to offline mode, causing downtime. Option C is wrong because `REORGANIZE` is used for defragmentation below 30% and does not rebuild the index, so it is ineffective for fragmentation above 50%. Option D is wrong because it specifies `ONLINE = OFF`, which performs an offline rebuild, blocking user access and violating the requirement to minimize downtime.

Practice this question →
98
MCQeasy

You need to automate the deployment of schema changes to multiple Azure SQL Databases in different regions. The solution must support rollback and version control. Which technology should you use?

A.Use Azure Data Factory to run stored procedures for schema changes.
B.Use SQL Server Agent jobs to run deployment scripts on schedule.
C.Use Azure DevOps with a database project and release pipelines.
D.Use Azure Automation with PowerShell scripts to execute T-SQL scripts.
AnswerC

Provides CI/CD, version control, and ability to roll back changes.

Why this answer

Azure DevOps with a database project and release pipelines is the correct choice because it provides source control for schema changes, automated deployment across multiple environments, and built-in rollback capabilities through pipeline versioning and deployment history. This approach aligns with infrastructure-as-code principles, enabling consistent, repeatable, and auditable schema deployments to Azure SQL Databases in different regions.

Exam trap

The trap here is that candidates often confuse Azure Data Factory or Azure Automation as valid automation tools for schema changes, overlooking that they lack the version control and rollback capabilities that are explicitly required by the question.

How to eliminate wrong answers

Option A is wrong because Azure Data Factory is an ETL and data orchestration service, not a schema deployment tool; it lacks native version control for schema changes and cannot perform rollback of DDL operations. Option B is wrong because SQL Server Agent jobs run on a single SQL Server instance and cannot be centrally managed for multi-region Azure SQL Databases; they also lack version control and rollback support. Option D is wrong because Azure Automation with PowerShell scripts executes ad-hoc or scheduled scripts but does not provide integrated version control, release pipeline gating, or automated rollback mechanisms for schema changes across multiple databases.

Practice this question →
99
MCQeasy

Refer to the exhibit. The ARM template snippet configures auditing for an Azure SQL Database. Based on the configuration, which events are audited?

A.All data modification statements (DML).
B.Successful and failed database authentication attempts.
C.Only failed authentication attempts.
D.All database schema changes (DDL).
AnswerB

The groups are for authentication events.

Why this answer

Option B is correct. The auditActionsAndGroups include SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP and FAILED_DATABASE_AUTHENTICATION_GROUP, which audit successful and failed logins respectively. Option A is wrong because DDL changes are not included.

Option C is wrong because data modifications are not included. Option D is wrong because only authentication events are listed.

Practice this question →
100
MCQhard

Your company uses Azure SQL Managed Instance with transactional replication. You need to automate the monitoring of replication latency and send an alert if latency exceeds 5 minutes. You want to use Azure Monitoring capabilities. What is the most efficient solution?

A.Use Elastic Database Jobs to run a query on the distributor and log results to a table, then set up a logic app to check the table.
B.Monitor the 'Replication: Dist Delivery Latency' performance counter.
C.Create a SQL Agent job on the publisher that checks sys.dm_repl_sync_status and sends an email.
D.Create an Azure Monitor metric alert on the 'Log Send Queue Size' metric with a threshold of 300000 KB (approximately 5 minutes).
AnswerD

This metric directly reflects replication latency and can trigger alerts.

Why this answer

Option A is correct because Azure SQL Managed Instance exposes replication metrics like Log Send Queue Size and Transaction Delay in Azure Monitor, which can be used to create alerts. Options B and C require custom scripting and are less efficient. Option D uses a deprecated metric.

Practice this question →
101
MCQeasy

You need to automatically send an email notification when an Azure SQL Database reaches 80% storage usage. What should you configure?

A.Azure Monitor alert with action group
B.Change Data Capture (CDC) with Logic Apps
C.Elastic Database Job with sp_send_dbmail
D.SQL Agent Mail
AnswerA

Azure Monitor can alert on storage metrics and trigger email notifications.

Why this answer

Option C is correct because Azure Monitor alerts can trigger actions like email based on metrics such as storage percent. Option A is wrong because SQL Agent Mail is not available in Azure SQL Database. Option B is wrong because Elastic Database Jobs are for executing scripts.

Option D is wrong because it is for data-level changes, not monitoring.

Practice this question →
102
MCQmedium

You have an Azure SQL Database that stores sensitive data. You need to automatically classify and apply sensitivity labels to new columns as they are added. What should you use?

A.Microsoft Purview Information Protection
B.Azure Policy with custom policy definition
C.Dynamic Data Masking
D.Azure Automation with PowerShell script to run sp_addsensitivityclassification
AnswerA

Purview can automatically scan and classify sensitive data.

Why this answer

Option C is correct because Microsoft Purview Information Protection can automatically classify and label sensitive data in Azure SQL Database. Option A is wrong because Azure Policy can enforce policies but not auto-classify. Option B is wrong because Dynamic Data Masking masks data but does not classify.

Option D is wrong because Azure Automation is not designed for classification.

Practice this question →
103
MCQmedium

Your company has a policy that all Azure SQL Databases must have their performance data (DTU/CPU, memory, IO) monitored and analyzed weekly. You need to automate the generation of a weekly report summarizing the top 10 queries by average CPU time. What should you use?

A.Configure a Power BI dashboard that connects directly to Azure SQL Database Query Store.
B.Create an Azure Monitor Workbook that queries the Query Store.
C.Set up a SQL Agent job to run queries against sys.dm_exec_query_stats and email the results.
D.Use the Query Performance Insight blade in the Azure portal and schedule an export to a storage account.
AnswerD

Query Performance Insight has built-in export capabilities for scheduled reports.

Why this answer

Option B is correct because Query Performance Insight is built into Azure SQL Database and provides query-level performance data. Option A is wrong because Azure Monitor Workbooks can visualize data but require a data source; they do not query Query Store directly. Option C is wrong because SQL Agent jobs can run queries but do not have built-in reporting capabilities.

Option D is wrong because Power BI requires an export mechanism.

Practice this question →
104
MCQeasy

You need to automate the execution of a T-SQL script against an Azure SQL Database every hour. Which Azure service should you use?

A.Azure Data Factory
B.Elastic Database Jobs
C.Azure Logic Apps
D.Azure Automation
AnswerD

Azure Automation with a runbook can schedule and execute T-SQL scripts.

Why this answer

Azure Automation with a runbook can run PowerShell or Python scripts that execute T-SQL against a database. Option A is wrong because Azure Logic Apps can also run SQL, but it is more suited for integration workflows. Option B is wrong because elastic jobs are for scheduling jobs across multiple databases, but they require a job agent.

Option D is wrong because Azure Data Factory is for data movement and transformation, not simple T-SQL execution.

Practice this question →
105
MCQmedium

You have an Azure SQL Database that needs to be backed up daily using Azure Automation runbooks. The runbook must trigger an export of the database to a storage account. How should you configure the runbook to authenticate securely to Azure?

A.Use a shared access signature (SAS) token stored in the runbook
B.Use Automation Account credential assets
C.Enable a system-assigned managed identity for the Automation account
D.Store the SQL admin credentials as variables in the runbook
AnswerC

Managed identities provide secure authentication without storing credentials.

Why this answer

Option C is correct because Managed Identity (system-assigned or user-assigned) is the recommended secure authentication method for Azure Automation runbooks, avoiding stored credentials. Option A uses credentials stored in the runbook, which is less secure. Option B uses automation account credentials, which still requires key management.

Option D is not a valid type.

Practice this question →
106
MCQmedium

You are a database administrator for a healthcare company that uses Azure SQL Database with Hyperscale tier. The database contains patient records and is critical for operations. You need to automate the process of refreshing the staging database from the production database every night. The refresh process must occur during a maintenance window from 2:00 AM to 4:00 AM. The solution must use point-in-time restore to ensure consistency and must minimize the storage costs. Additionally, the automation must notify the operations team if the refresh fails. What should you do?

A.Use Elastic Database Jobs to run a T-SQL script that uses RESTORE DATABASE from a backup file.
B.Create an Azure Automation runbook that performs a point-in-time restore of the production database to a new database, then renames the databases to swap staging. Schedule the runbook during the maintenance window and configure alerts for failure.
C.Use Azure Data Factory to copy data from production to staging using a copy activity.
D.Use Azure SQL Database export to BACPAC from production and import to staging using Azure Automation.
AnswerB

Point-in-time restore ensures consistency, and Azure Automation can handle scheduling and alerting.

Why this answer

Option C is correct. Azure Automation runbooks can schedule a point-in-time restore of the production database to a new database, then swap the names to make it the staging database. This uses the Hyperscale tier's fast restore capabilities and minimizes storage by not keeping multiple copies.

Option A is incorrect because Elastic Database Jobs cannot perform restore operations. Option B is incorrect because Data Factory is for ETL, not database restore. Option D is incorrect because using export/import is slower and more expensive than PITR.

Practice this question →
107
Matchingmedium

Match each Azure SQL Database command to its function.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Sets database-level configuration options

Clears the procedure cache

Changes the recovery model of the database

Creates a database as a copy of another database

Why these pairings

These T-SQL commands are used for database management in Azure SQL Database.

Practice this question →
108
MCQeasy

You need to automatically notify the operations team when an Azure SQL Database reaches 80% storage usage. Which Azure service should you use to create the alert?

A.Azure Automation
B.Microsoft Sentinel
C.Azure Logic Apps
D.Azure Monitor
AnswerD

Azure Monitor can create metric alerts for storage usage.

Why this answer

Azure Monitor alerts can be configured to trigger based on metrics like storage percent. Option B is wrong because Azure Automation is for runbooks, not alerting. Option C is wrong because Microsoft Sentinel is a SIEM, not for simple metric alerts.

Option D is wrong because Azure Logic Apps can be triggered by alerts, but the alert itself is created in Azure Monitor.

Practice this question →
109
MCQmedium

Your team uses Azure DevOps to deploy database changes to Azure SQL Database. You need to automate the generation and deployment of database schema changes based on a Git branch merge. Which Azure service should you integrate?

A.Azure Automation Runbook triggered by a webhook from Azure DevOps.
B.Azure Pipelines with a release pipeline that uses the Azure SQL Database deployment task.
C.GitHub Actions with a workflow that runs on pull request merge, using the Azure SQL action.
D.Azure Logic Apps with an HTTP trigger from Azure DevOps, then use SQL connector to run scripts.
AnswerB

Azure Pipelines natively supports database deployments.

Why this answer

Option D is correct because Azure Pipelines (part of Azure DevOps) can be configured to run on branch merges and execute SQL scripts using the Azure SQL Database deployment task. Option A is wrong because GitHub Actions could be used but the team already uses Azure DevOps. Option B is wrong because Azure Automation Runbooks are not CI/CD focused.

Option C is wrong because Azure Logic Apps are not designed for CI/CD.

Practice this question →
110
Multi-Selecthard

Which THREE of the following are required to automate schema deployments to Azure SQL Database using Azure DevOps? (Select exactly three.)

Select 3 answers
A.A release pipeline with a 'Azure SQL Database deployment' task.
B.A SQL database project (.sqlproj) containing the schema.
C.A service connection to Azure with appropriate permissions.
D.A schema compare tool to generate deployment scripts.
E.A self-hosted build agent with SQL tools installed.
AnswersA, B, C

The deployment task executes the schema change.

Why this answer

Options A, C, and D are correct. A service connection is needed to authenticate to Azure; a database project is the source of schema; a release pipeline automates deployment. Option B is wrong because a self-hosted agent is optional; Microsoft-hosted agents can be used.

Option E is wrong because schema compare is a tool, not a requirement.

Practice this question →
111
MCQmedium

You manage an Azure SQL Database that supports a critical application. You need to automate the process of rebuilding indexes that have fragmentation above 30% on a weekly basis. The solution must use built-in database features and minimize performance impact. What should you do?

A.Create a SQL Agent job that runs ALTER INDEX REBUILD on all indexes with fragmentation >30%.
B.Use Azure Automation to run a PowerShell script that checks fragmentation and rebuilds indexes.
C.Enable automatic tuning and set the 'Force plan' and 'Create index' options.
D.Schedule a weekly job using elastic jobs to reorganize all indexes.
AnswerC

Automatic tuning automatically manages index creation and performance without manual intervention.

Why this answer

Option C is correct because Azure SQL Database's automatic tuning feature includes the 'Create index' option, which can automatically rebuild indexes with high fragmentation when enabled. This uses built-in database features without requiring external scripts or jobs, and it minimizes performance impact by leveraging the database engine's own intelligent scheduling and execution.

Exam trap

The trap here is that candidates often assume SQL Agent jobs or external automation are necessary for index maintenance, but Azure SQL Database's automatic tuning provides a built-in, low-impact solution that directly addresses fragmentation without requiring custom scripts or jobs.

How to eliminate wrong answers

Option A is wrong because SQL Agent jobs are not available in Azure SQL Database (only in SQL Server on VMs or Managed Instances), and ALTER INDEX REBUILD can be resource-intensive, potentially causing performance impact during execution. Option B is wrong because Azure Automation running PowerShell scripts is an external solution that does not use built-in database features, and it introduces additional complexity and latency compared to native database capabilities. Option D is wrong because elastic jobs are designed for executing T-SQL scripts across multiple databases, not for automating index maintenance within a single database, and reorganize (not rebuild) is less effective for fragmentation above 30%.

Practice this question →
112
MCQhard

You are reviewing an ARM template snippet that configures a Security Alert Policy for an Azure SQL Database. The policy is enabled, and email notifications are sent to the account admin and admin@contoso.com. However, you notice that SQL Injection alerts are disabled. What is the most likely reason for disabling SQL Injection alerts?

A.To reduce the number of false positives and save costs on alert processing.
B.Because the database is configured with a conflicting vulnerability assessment policy that overrides SQL injection detection.
C.Because SQL injection alerts are incompatible with the chosen storage account endpoint.
D.Because SQL injection detection is already handled by Microsoft Defender for SQL.
AnswerD

Microsoft Defender for SQL provides advanced threat protection, so the basic alert policy may be disabled to avoid duplication.

Why this answer

Option C is correct. SQL Injection alerts may be disabled if an alternative mechanism, such as Microsoft Defender for SQL, is used to detect SQL injection attacks. Option A is wrong because disabling alerts does not reduce cost; it reduces security.

Option B is wrong because there is no conflicting policy. Option D is wrong because there is no known compatibility issue.

Practice this question →
113
Multi-Selectmedium

Which TWO of the following are valid methods to automate backups for Azure SQL Managed Instance? (Select exactly two.)

Select 2 answers
A.Use Azure Backup to schedule full backups.
B.Schedule T-SQL BACKUP DATABASE TO URL statements via SQL Agent jobs.
C.Use Azure Site Recovery to replicate the instance.
D.Configure long-term retention (LTR) policies on the managed instance.
E.Use Azure VM backup by installing the backup extension.
AnswersB, D

SQL Agent jobs can automate copy-only backups to Azure Blob.

Why this answer

Options A and D are correct. Azure SQL Managed Instance supports automated backups via the service (PITR and LTR) and also allows manual copy-only backups to Azure Blob Storage via T-SQL. Option B is wrong because Azure Backup does not natively back up SQL Managed Instance.

Option C is wrong because Azure Site Recovery is for disaster recovery, not backups. Option E is wrong because VM backup is for IaaS VMs, not Managed Instance.

Practice this question →
114
Multi-Selecthard

You are designing an automation strategy for an Azure SQL Database that requires the following: 1) Automatically scale up the service tier when CPU usage exceeds 90% for 5 minutes. 2) Automatically scale down when CPU usage drops below 10% for 15 minutes. 3) The solution must be cost-effective and use built-in Azure features. Which TWO options should you combine? (Choose two.)

Select 2 answers
A.Elastic Database Jobs
B.Azure Monitor autoscale
C.Azure Functions
D.Azure Logic Apps with a metric trigger
E.Azure Automation runbook
AnswersD, E

Logic Apps can monitor metrics and trigger actions.

Why this answer

Azure Logic Apps can trigger scaling actions based on metrics, and Azure Automation runbooks can execute the scaling commands. Option B is wrong because elastic jobs are for scheduling database tasks, not scaling. Option D is wrong because autoscale rules are not directly available for Azure SQL Database; you need custom automation.

Option E is wrong because Azure Functions can also be used, but Logic Apps and Automation are the recommended combination.

Practice this question →
115
MCQhard

You have an Azure SQL Database that needs to be automatically scaled up during peak hours and scaled down during off-peak. The solution must use native Azure capabilities without custom code. What should you use?

A.Use Azure Functions with timer trigger and PowerShell to change the pricing tier.
B.Configure autoscale for the elastic pool that contains the database.
C.Configure autoscale settings on the Azure SQL Database server.
D.Create Elastic Database Jobs that run ALTER DATABASE to change the service objective at scheduled times.
AnswerD

Elastic Jobs can execute T-SQL to modify the database's service tier on a schedule.

Why this answer

Option B is correct because Elastic Database Jobs can be used to run ALTER DATABASE statements on a schedule. Option A is wrong because Autoscale is not supported for Azure SQL Database. Option C is wrong because Azure Functions would require custom code.

Option D is wrong because Elastic Pool autoscale only adjusts per-database DTUs, not the pool size itself.

Practice this question →
116
MCQmedium

You manage an Azure SQL Database that must run a maintenance task every Sunday at 2:00 AM UTC. The task must be resilient to failures and automatically retry if it fails. You need to configure this using Azure automation. What is the most appropriate solution?

A.Create an Azure Logic App with a recurrence trigger scheduled for Sunday at 2:00 AM UTC and configure a retry policy.
B.Create an Azure Automation Runbook and schedule it to run weekly. Add custom error handling for retries.
C.Use T-SQL Agent job in Azure SQL Database with a schedule and set up retry via Transact-SQL.
D.Create an Azure Function with a timer trigger and implement retry logic in code.
AnswerA

Logic Apps provide built-in scheduling and retry policies.

Why this answer

Option C is correct because Azure Logic Apps provides built-in retry policies and can be scheduled to run at specific times. Option A is wrong because Azure Automation Runbooks can be scheduled but require more custom error handling for retries. Option B is wrong because Azure Functions can be triggered by timer, but retry logic requires custom implementation.

Option D is wrong because T-SQL Agent jobs in Azure SQL Database are limited and do not support retry policies natively.

Practice this question →
117
MCQeasy

You need to automate the process of scaling an Azure SQL Database up during peak hours and down during off-peak hours to optimize cost. The solution must be serverless and not require any custom infrastructure. What should you use?

A.Create a SQL Agent job that runs ALTER DATABASE MODIFY (SERVICE_OBJECTIVE = ...).
B.Create a scheduled Azure Logic App that uses the Azure SQL Database REST API to update the service objective.
C.Use an Elastic Job agent to run a script that changes the service objective.
D.Enable autoscale on the Azure SQL Database.
AnswerB

Logic Apps can automate scaling without additional infrastructure.

Why this answer

Option D is correct because Azure Logic Apps can be scheduled to run PowerShell or CLI scripts to change the service tier. Option A is wrong because autoscale is not available for Azure SQL Database. Option B is wrong because SQL Agent cannot change the service tier.

Option C is wrong because elastic jobs are for executing scripts on multiple databases, not for scaling.

Practice this question →
118
MCQmedium

You have an Azure SQL Database that uses SQL Server Agent for automation tasks. You migrated the database to Azure SQL Managed Instance. After migration, some SQL Server Agent jobs fail because they reference a linked server that no longer exists. You need to automate the removal of all linked server references from the jobs. What should you do?

A.Use elastic jobs to remove the linked server references.
B.Create a T-SQL script that updates the job steps to remove linked server references, and execute it via Azure Automation runbook.
C.Use Azure CLI to remove the linked server references.
D.Use Azure Automation to run a PowerShell script that removes the linked server references.
AnswerB

A T-SQL script can modify SQL Agent jobs, and Azure Automation can execute it.

Why this answer

PowerShell with the 'Get-AzSqlInstanceDatabase' cmdlet can list databases, but to modify jobs, you need to use T-SQL or the SQL Agent cmdlets. Option A is wrong because Azure Automation does not directly modify SQL Agent jobs. Option B is wrong because elastic jobs are separate from SQL Agent.

Option D is wrong because Azure CLI does not have SQL Agent management cmdlets.

Practice this question →
119
Matchingmedium

Match each Azure SQL Database high availability feature to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Asynchronous replication to a secondary region

Group of databases that fail over together

Replicas across different availability zones

Data replicated within a single datacenter

Why these pairings

These features provide different levels of availability and disaster recovery for Azure SQL Database.

Practice this question →
120
MCQmedium

You are configuring automated backup retention for Azure SQL Managed Instance. The compliance policy requires that you be able to restore a database to any point within the last 90 days, and that you keep backups for a minimum of 7 years for auditing purposes. Which backup retention policy should you configure?

A.Set PITR retention to 35 days and configure a long-term retention (LTR) policy to keep weekly backups for 7 years.
B.Set point-in-time restore (PITR) retention to 90 days.
C.Set PITR retention to 90 days and configure geo-replication to achieve the 7-year retention.
D.Configure geo-redundant backup storage with a retention of 90 days.
AnswerA

PITR covers 35 days; LTR can retain backups for up to 10 years, satisfying the 7-year requirement.

Why this answer

Azure SQL Managed Instance's point-in-time restore (PITR) retention is capped at 35 days, so to meet the 90-day restore requirement, you must combine a 35-day PITR policy with a long-term retention (LTR) policy that keeps weekly full backups for 7 years. LTR allows you to restore to any point within the LTR window by using full, differential, and log backups, satisfying both the 90-day point-in-time restore and the 7-year auditing compliance.

Exam trap

The trap here is that candidates assume PITR retention can be extended to any value, but Azure SQL Managed Instance enforces a hard 35-day maximum, forcing you to combine PITR with LTR to meet longer retention requirements.

How to eliminate wrong answers

Option B is wrong because PITR retention in Azure SQL Managed Instance has a maximum of 35 days, not 90 days, so it cannot meet the 90-day restore requirement. Option C is wrong because PITR retention cannot be set to 90 days (max 35), and geo-replication does not provide backup retention; it provides disaster recovery but does not extend backup retention to 7 years. Option D is wrong because geo-redundant backup storage (RA-GRS) only affects storage redundancy, not retention duration; it still cannot exceed the 35-day PITR limit and does not address the 7-year auditing requirement.

Practice this question →
121
MCQhard

You are reviewing a PowerShell script that is part of an Azure Automation runbook. The script is intended to monitor resource usage of an Azure SQL Database and trigger an alert if DTU usage exceeds 80%. The script runs successfully but does not trigger the alert. What is the most likely reason?

A.The script must use the -OutputAs parameter to return results.
B.The script uses Out-GridView, which is not supported in Azure Automation.
C.The Invoke-SqlCmd cmdlet is not compatible with Azure SQL Database.
D.The query syntax is incorrect for Azure SQL Database.
AnswerB

Out-GridView requires an interactive session and does not work in Azure Automation runbooks.

Why this answer

The script uses 'Out-GridView', which displays results in a GUI window. In Azure Automation, there is no interactive desktop, so the command fails silently or does not output anything. The alert logic likely depends on the output.

Option B is wrong because 'Invoke-SqlCmd' works with Azure SQL Database if the credential has access. Option C is wrong because the 'Query' is valid. Option D is wrong because 'Out-GridView' does not block execution but prevents output from being captured.

Practice this question →
122
MCQhard

Refer to the exhibit. You are deploying an Azure SQL Database using this ARM template. After deployment, you need to automate the scaling of the database to a higher service tier when DTU consumption exceeds 80% for 5 minutes. Which Azure service should you use to trigger the scaling?

A.Azure SQL Analytics
B.Azure Automation Update Management
C.SQL Server Agent
D.Azure Monitor metric alert
AnswerD

Metric alerts can trigger runbooks to scale the database.

Why this answer

Option B is correct because Azure Monitor metric alerts can trigger an Automation runbook that scales the database. The exhibit shows a General Purpose database, which supports scaling. Option A is for SQL Agent.

Option C is for on-premises. Option D is for performance data, not triggering actions.

Practice this question →
123
MCQhard

Your company uses Azure SQL Managed Instance and needs to automate patching and maintenance. The compliance team requires that all maintenance windows be predefined and that no maintenance occurs outside these windows. What should you configure?

A.Configure a maintenance configuration for the virtual machine scale set
B.Set a maintenance window in the Azure SQL Database server settings
C.Use Azure Update Management to schedule patching
D.Assign a maintenance configuration to the SQL Managed Instance
AnswerD

Azure Maintenance Configurations allow you to define maintenance windows for SQL Managed Instance.

Why this answer

Option D is correct because Azure Maintenance Configurations allow you to schedule maintenance windows for Azure SQL Managed Instance, ensuring compliance. Option A is for Azure VMs, not SQL MI. Option B is for patching at the OS level, not applicable.

Option C is for Azure SQL Database, not Managed Instance.

Practice this question →
124
MCQmedium

Your Azure SQL Database is configured with active geo-replication. You need to automate the failover process in case of a regional outage. The solution should ensure minimal data loss and support testing without affecting the production environment. What should you use?

A.Configure an Azure Traffic Manager profile with endpoint monitoring and failover.
B.Use Azure Load Balancer with a health probe to redirect traffic.
C.Create an Azure Automation runbook that monitors health and executes a manual failover using PowerShell cmdlet Start-AzSqlDatabaseFailover.
D.Enable automatic failover for the geo-replication group.
AnswerC

Azure Automation can run a script to check health and trigger failover, providing automated response while allowing manual testing.

Why this answer

Azure SQL Database supports active geo-replication with manual or forced failover. To automate, you can use Azure Automation runbooks with the Start-AzSqlDatabaseFailover cmdlet. Option A is correct.

Option B is for virtual networks. Option C is for load balancing. Option D is incorrect because geo-replication does not have automatic failover.

Practice this question →
125
MCQeasy

You are reviewing an Azure CLI command that creates an elastic job step. The job step is intended to rebuild all indexes on the Sales.Orders table, but the job fails. What is the error in the JSON configuration?

A.The command is missing a semicolon at the end.
B.The target group should specify 'SqlServer' type instead of 'SqlDatabase'.
C.The command should be 'REBUILD INDEX' instead of 'ALTER INDEX'.
D.The job agent version is incompatible with the command.
AnswerA

T-SQL statements should end with a semicolon in elastic job steps.

Why this answer

The 'ALTER INDEX ALL' command should have a semicolon at the end. While not strictly required, the more likely issue is that the command is missing the semicolon. However, the real error is that the 'command' property should be a T-SQL script, and 'ALTER INDEX ALL ON Sales.Orders REBUILD' is missing the semicolon.

Option A is wrong because the syntax is mostly correct. Option C is wrong because the command is correct syntactically. Option D is wrong because the job agent does not require a specific version.

Practice this question →
126
Multi-Selecthard

Which TWO methods can be used to automate index maintenance in Azure SQL Database?

Select 2 answers
A.Azure Automation runbooks executing T-SQL scripts
B.SQL Server Agent jobs
C.Azure Data Factory pipelines
D.Elastic jobs with T-SQL steps
E.Automatic tuning
AnswersA, D

Runbooks can connect to Azure SQL Database and run maintenance scripts.

Why this answer

Option A is correct because Azure Automation runbooks can execute T-SQL scripts against Azure SQL Database using the Invoke-SqlCmd cmdlet or similar, enabling scheduled index maintenance tasks such as rebuilding or reorganizing indexes. This method is fully supported in Azure SQL Database, which lacks SQL Server Agent, and allows for flexible, cloud-native automation.

Exam trap

The trap here is that candidates often assume SQL Server Agent (Option B) is available in Azure SQL Database, but it is only supported in Azure SQL Managed Instance, not the single database or elastic pool service tiers.

Practice this question →
127
MCQmedium

Refer to the exhibit. You execute this PowerShell script to automate database configuration. The script runs without errors, but the database remains in the 'Standard' edition with S2 performance level. What is the most likely reason?

A.The elastic pool does not exist
B.The -RequestedServiceObjectiveName parameter is misspelled
C.The database is being moved into an elastic pool, which overrides the edition and SLO
D.The script requires administrative privileges that the user does not have
AnswerC

When specifying ElasticPoolName, the database inherits the pool's service tier.

Why this answer

Option D is correct because when ElasticPoolName is specified, the database is moved to the elastic pool and the edition and service objective are ignored; the pool's tier determines the performance. Option A is wrong because the command succeeded. Option B is wrong because the parameters are correct syntactically.

Option C is wrong because the pool already exists.

Practice this question →
128
MCQhard

Your company uses Azure SQL Managed Instance for a critical OLTP workload. You need to automate index maintenance for all databases in the instance without downtime. The solution must minimize performance impact during business hours. Which approach should you use?

A.Use Elastic Database Jobs to run index maintenance scripts on all databases during off-peak hours, with parallel execution throttled.
B.Use Azure Logic Apps with a SQL connector to run index maintenance on each database, with retry policies.
C.Create an Azure Automation Runbook that connects to each database and runs index maintenance sequentially.
D.Deploy Ola Hallengren’s IndexOptimize stored procedure in each database and schedule it via SQL Server Agent.
AnswerA

Elastic Database Jobs can run T-SQL scripts across databases with scheduling and throttling.

Why this answer

Option A is correct because Elastic Database Jobs can run index maintenance scripts across all databases with configurable schedules and throttling. Option B is wrong because Azure Automation Runbooks can be used but require more setup for multi-database execution and may not have built-in throttling. Option C is wrong because Ola Hallengren scripts are a best practice, but they need a scheduling mechanism; Elastic Database Jobs provide that.

Option D is wrong because Azure Logic Apps are not designed for running T-SQL scripts across multiple databases.

Practice this question →
129
Multi-Selecteasy

Which TWO Azure services can be used to automate the execution of T-SQL scripts on a schedule against Azure SQL Database?

Select 2 answers
A.Azure Logic Apps with SQL connector to execute stored procedures.
B.Azure Automation Hybrid Runbook Worker with PowerShell Invoke-SqlCmd.
C.Azure Functions with timer trigger and SqlConnection.
D.Elastic Database Jobs with T-SQL script execution.
E.Azure Data Factory with a SQL Server Stored Procedure activity.
AnswersB, D

Hybrid Runbook Worker can run scripts on schedule.

Why this answer

Options A and D are correct. Azure Automation Hybrid Runbook Worker can run T-SQL scripts on-premises or in Azure. Elastic Database Jobs are designed to run T-SQL scripts on schedules across databases.

Option B is wrong because Azure Logic Apps can run SQL queries but not T-SQL scripts in a batch. Option C is wrong because Azure Data Factory is for data movement, not script execution. Option E is wrong because Azure Functions are for code execution, but not specifically for scheduled T-SQL.

Practice this question →
130
Multi-Selectmedium

You are designing an automation solution to deploy Azure SQL Database schema changes using CI/CD pipelines. The solution must support rollback if a deployment fails and must integrate with Azure DevOps. Which two components should you include in your pipeline?

Select 2 answers
A.Azure Automation runbook to execute T-SQL scripts.
B.Azure Data Factory pipeline to copy schema changes.
C.A PowerShell script that uses Invoke-SqlCmd to deploy to Azure SQL Managed Instance.
D.Azure SQL Database project with DACPAC deployment.
E.Azure SQL Database deployment task in Azure Pipelines.
AnswersD, E

DACPAC is the standard for schema deployment and supports rollback.

Why this answer

Option B is correct because Azure SQL Database deployment task in Azure DevOps can execute schema scripts. Option E is correct because using Azure SQL Database projects with DACPAC allows version-controlled schema deployment. Option A is incorrect because Azure Automation runbooks are more for operational tasks, not CI/CD.

Option C is incorrect because Azure SQL Managed Instance is a different service. Option D is incorrect because Data Factory is for ETL, not schema deployment.

Practice this question →
131
Multi-Selectmedium

You have an Azure SQL Database that runs a critical workload. You need to automate the monitoring of performance anomalies and receive notifications when certain thresholds are exceeded. Which TWO actions should you implement? (Choose two.)

Select 2 answers
A.Create a Power BI report that refreshes every minute.
B.Enable Query Store and set up email notifications for high query duration.
C.Configure a SQL Agent alert on performance counters.
D.Enable SQL Insights (preview) for intelligent performance monitoring.
E.Create an Azure Monitor alert rule on DTU/CPU and storage metrics.
AnswersD, E

SQL Insights provides advanced monitoring and anomaly detection.

Why this answer

Options A and D are correct. Azure Monitor alerts can be configured on performance metrics, and SQL Insights provides intelligent monitoring. Option B is wrong because SQL Agent does not monitor metrics.

Option C is wrong because email notifications are not native to Query Store. Option E is wrong because Power BI is for reporting, not real-time alerting.

Practice this question →
132
MCQhard

You are a database administrator for a financial services company. The company has multiple Azure SQL Managed Instances in different regions for disaster recovery. Each Managed Instance hosts several databases. You need to automate the process of backing up all databases and copying the backup files to a central Azure Blob Storage account for long-term retention. The backup must be taken daily at 10 PM local time for each region. The solution must be resilient to regional outages and must not use native backup retention more than 7 days. Additionally, you must ensure that backup files are encrypted at rest and in transit. What should you do?

A.Configure a SQL Agent job on each Managed Instance to perform backups to the central storage account directly using BACKUP TO URL.
B.Create an Azure Automation account in each region with a PowerShell runbook that connects to the local Managed Instance, performs a full database backup to a local blob container, and then copies the backup file to the central storage account using AzCopy. Schedule the runbook to run daily at 10 PM local time.
C.Use Elastic Database Jobs to schedule backups across all databases in all Managed Instances.
D.Enable Azure Backup for SQL Server in Azure Backup vault and configure backup policies for each Managed Instance.
AnswerB

Azure Automation runbooks can be scheduled per region and provide resiliency.

Why this answer

Option A is correct. Azure Automation runbooks with PowerShell can schedule backup commands using the BACKUP TO URL command (which supports native SQL Server backup to Azure Blob Storage). This allows you to copy backups to a central storage account.

Using Azure Automation ensures resiliency and can be scheduled per region. Option B is incorrect because SQL Agent is available on Managed Instance, but it would require managing schedules across instances. Option C is incorrect because Elastic Database Jobs is not available for Managed Instance.

Option D is incorrect because Azure Backup for SQL Server is for IaaS VMs, not Managed Instance.

Practice this question →
133
MCQeasy

You need to run a complex T-SQL script on an Azure SQL Database every hour. The script performs data transformations that must be logged for auditing. Which native Azure service should you use?

A.SQL Agent job on the Azure SQL Database.
B.Elastic Database Jobs with a T-SQL job step.
C.Azure Data Factory with a stored procedure activity.
D.Azure Automation Account with a PowerShell runbook that uses Invoke-SqlCmd.
AnswerB

Elastic Jobs are purpose-built for scheduled T-SQL execution on Azure SQL DB with logging.

Why this answer

Option D is correct because Elastic Database Jobs are designed for scheduled T-SQL script execution across databases with logging. Option A is wrong because SQL Agent is not available in Azure SQL Database single database. Option B is wrong because Data Factory is for ETL, not simple script execution.

Option C is wrong because Automation Runbooks are for PowerShell, not T-SQL directly.

Practice this question →
134
MCQeasy

You need to automate the deployment of database schema changes across multiple Azure SQL Databases in a development environment. Which Azure service is designed for this purpose?

A.Azure DevOps using database projects and release pipelines.
B.SQL Agent jobs on each database.
C.Azure Automation Account with PowerShell runbooks.
D.Azure Data Factory with a copy activity.
AnswerA

Azure DevOps provides CI/CD capabilities specifically for database deployments.

Why this answer

Option A is correct because Azure DevOps with database projects and pipelines is the standard tool for automating schema deployments. Option B is wrong because Data Factory focuses on data movement, not schema changes. Option C is wrong because Automation Account is for runbooks, not CI/CD pipelines.

Option D is wrong because SQL Agent is for job scheduling, not deployment automation.

Practice this question →
135
MCQmedium

You manage an Azure SQL Database that supports a critical financial application. The database is in the General Purpose tier and uses active geo-replication for disaster recovery. You need to automate the process of failing over to the secondary region in case of a regional outage, but only after confirming that the primary is unreachable for more than 5 minutes. Additionally, you need to send an alert to the operations team when the failover occurs. The solution should use Azure services and minimize manual steps. What should you implement?

A.Use Azure Logic Apps with a timer trigger to check the database status every minute and initiate failover if unreachable.
B.Schedule a SQL Agent job on the secondary to run a script that checks connectivity and fails over.
C.Configure Azure Site Recovery for the SQL database.
D.Configure an Azure Monitor metric alert on the 'Deadlock count' metric (or custom metric) with a threshold of 0 for 5 minutes, then use an action group to trigger an Azure Automation runbook that runs the failover PowerShell cmdlet.
AnswerD

Monitor can detect unavailability and trigger automated failover via runbook.

Why this answer

Option A is correct because Azure Monitor can detect the primary database unavailability (e.g., through heartbeat metrics) and trigger an alert that invokes an Azure Automation runbook to perform the failover. Options B and C require manual intervention. Option D (Azure Site Recovery) is not designed for SQL Database geo-replication failover.

Practice this question →
136
Multi-Selectmedium

You are a database administrator for a company that uses Azure SQL Managed Instance. You need to automate the process of patching the operating system and SQL Server engine for all managed instances in a specific region. The automation must minimize downtime and ensure high availability. Which two actions should you include in your automation strategy?

Select 2 answers
A.Use Azure Policy to automatically scale up the instance before patching.
B.Create an Azure Automation runbook to manually apply OS and SQL patches.
C.Configure a maintenance window using Azure Portal or PowerShell.
D.Deploy a failover group to another region and enable read-scale replicas.
E.Enable Azure Update Manager for the managed instances.
AnswersC, D

Allows scheduling updates during off-peak hours.

Why this answer

Option A is correct because Azure SQL Managed Instance automatically applies updates, but you can configure a maintenance window to control the timing. Option C is correct because using a failover group with read-scale replicas ensures that during patching, traffic can be redirected to a secondary replica, minimizing downtime. Option B is incorrect because manual patching is not supported for Azure SQL Managed Instance; Microsoft manages patching.

Option D is incorrect because scaling up is not related to patching automation. Option E is incorrect because enabling Azure Update Manager is not applicable to Azure SQL Managed Instance; it's for IaaS VMs.

Practice this question →
137
MCQmedium

You have an Azure SQL Database that must be automatically restarted every night to clear the procedure cache. You plan to use elastic jobs in Azure SQL Database. What should you create first?

A.A job database
B.An elastic job agent
C.A target group
D.A job credential
AnswerB

The job agent is required before creating jobs, targets, and credentials.

Why this answer

Option A is correct because an elastic job agent is the top-level resource that orchestrates jobs. The job database stores job definitions and history. Option B is created after the agent.

Option C is a target group, not first. Option D is a credential, but the agent must exist first.

Practice this question →
138
MCQhard

A company uses Azure SQL Managed Instance. They want to automate backups to a storage account for long-term retention beyond the default 35 days. What should they use?

A.Configure a SQL Server Agent job on the Managed Instance to run a T-SQL BACKUP DATABASE TO URL statement.
B.Use Azure Backup to configure a backup policy for the Managed Instance.
C.Create an Elastic Database Job that runs a T-SQL BACKUP DATABASE TO URL statement.
D.Create an Azure Automation runbook that uses the Backup-SqlDatabase cmdlet with -BackupAction 'Database' -CopyOnly and schedule it.
AnswerD

The Backup-SqlDatabase cmdlet can perform COPY_ONLY backups to a URL when used with the -BackupContainer parameter, and Azure Automation can schedule it.

Why this answer

Option D is correct because Azure SQL Managed Instance does not support native T-SQL BACKUP DATABASE TO URL for automated long-term retention; instead, you must use the Azure Backup service, which leverages the Backup-SqlDatabase cmdlet with the -CopyOnly flag to perform copy-only backups that do not disrupt the backup chain. This method integrates with Azure Backup policies to store backups in a Recovery Services vault for retention beyond 35 days.

Exam trap

The trap here is that candidates mistakenly think they can use T-SQL BACKUP DATABASE TO URL or Elastic Database Jobs on Managed Instance, but Managed Instance does not support user-initiated T-SQL backups—only Azure Backup with the Backup-SqlDatabase cmdlet is valid for custom long-term retention.

How to eliminate wrong answers

Option A is wrong because SQL Server Agent jobs on Managed Instance cannot execute T-SQL BACKUP DATABASE TO URL; Managed Instance does not support backing up to URL via T-SQL—backups are managed by Azure internally. Option B is wrong because Azure Backup does not directly support configuring a backup policy for Managed Instance; it requires the use of the Backup-SqlDatabase cmdlet in a runbook or similar automation to orchestrate backups. Option C is wrong because Elastic Database Jobs are designed for executing T-SQL scripts across multiple databases in Azure SQL Database, not for backing up Managed Instance databases, and they cannot run BACKUP DATABASE TO URL on Managed Instance.

Practice this question →
139
Multi-Selectmedium

Which TWO options are valid services for scheduling automated tasks for Azure SQL Database? (Choose two.)

Select 2 answers
A.SQL Server Agent
B.Azure Functions
C.Azure Automation
D.Azure Logic Apps
E.Elastic Database Jobs
AnswersC, E

Azure Automation can run PowerShell or Python runbooks on a schedule to perform database tasks.

Why this answer

Azure Automation is correct because it provides a cloud-based automation and configuration service that supports scheduling PowerShell or Python runbooks to execute tasks against Azure SQL Database, such as running T-SQL scripts or performing maintenance operations. It integrates natively with Azure SQL via the Az module and can be triggered on a recurring schedule, making it a valid service for scheduling automated tasks.

Exam trap

The trap here is that candidates often confuse SQL Server Agent (available in SQL Server and Azure SQL Managed Instance) with Elastic Database Jobs (the equivalent for Azure SQL Database), or they assume Azure Functions or Logic Apps are the correct scheduling services when the question specifically asks for services designed for scheduling automated tasks for Azure SQL Database.

Practice this question →
140
MCQmedium

You are managing an Azure SQL Database that runs a critical business application. The database experiences a predictable surge in read-only queries every night at 2:00 AM. You need to configure automatic scaling to handle this surge without manual intervention. What should you do?

A.Create a read replica and redirect read queries to it during the surge.
B.Manually scale up the database service tier before 2:00 AM each day.
C.Move the database to an Elastic Database Pool and rely on its built-in autoscaling.
D.Configure autoscale settings on the Azure SQL Database using Azure Automation runbooks triggered by a metric alert.
AnswerD

This enables automatic scaling based on load.

Why this answer

Option D is correct because Azure SQL Database does not natively support automatic scaling based on load. To achieve this, you must use Azure Automation runbooks triggered by a metric alert (e.g., DTU or CPU percentage) to programmatically scale the database's service tier up or down. This approach allows you to handle the predictable nightly surge without manual intervention, as the runbook can be scheduled or triggered by a threshold alert.

Exam trap

The trap here is that candidates often assume Azure SQL Database has built-in autoscaling like Azure SQL Database serverless (which only pauses/resumes, not scales), or they confuse elastic pool autoscaling with per-database scaling, leading them to select option C incorrectly.

How to eliminate wrong answers

Option A is wrong because creating a read replica and redirecting read queries does not scale the primary database; it only offloads read traffic, and the replica itself is not automatically scaled to handle the surge. Option B is wrong because manually scaling the database before 2:00 AM each day requires ongoing manual intervention, which contradicts the requirement to configure automatic scaling without manual intervention. Option C is wrong because Elastic Database Pools provide resource sharing and autoscaling at the pool level (adding/removing eDTUs), but they do not automatically scale individual databases within the pool; the pool's autoscaling is based on aggregate pool metrics, not per-database surge patterns.

Practice this question →
141
MCQeasy

You need to automate the process of scaling an Azure SQL Database to a higher service tier when CPU usage exceeds 80% for 5 consecutive minutes. Which Azure service is best suited for this automation?

A.Azure Logic App triggered by an Azure Monitor metric alert, calling the Azure SQL Database REST API to update the tier.
B.Elastic Database Job that monitors sys.dm_db_resource_stats and executes ALTER DATABASE.
C.Azure Automation Runbook triggered by an Azure Monitor alert, using PowerShell to scale the database.
D.Azure Function triggered by an Azure Monitor alert, using the Azure SDK to scale.
AnswerA

Logic Apps have native integration with Azure Monitor alerts and REST APIs.

Why this answer

Option B is correct because Azure Logic Apps can be triggered by metrics alerts and can call the REST API to update the database tier. Option A is wrong because Azure Automation Runbooks can be triggered by alerts but require more setup. Option C is wrong because Azure Functions can work but Logic Apps are simpler.

Option D is wrong because Elastic Database Jobs cannot scale databases.

Practice this question →
142
MCQmedium

You are managing an Azure SQL Managed Instance that hosts a critical database. You need to automate the export of daily backups to a storage account for long-term retention. The solution must minimize administrative overhead and support point-in-time restore within the retention period. What should you use?

A.Configure a long-term retention (LTR) backup policy for the Managed Instance.
B.Configure an Azure Backup policy for the Managed Instance.
C.Schedule a BACPAC export of the database to the storage account.
D.Create a SQL Agent job to perform backups using BACKUP DATABASE TO URL.
AnswerA

LTR policies automate backup exports to storage accounts and support point-in-time restore.

Why this answer

Option B is correct because Managed Instance automated backups can be configured with long-term retention (LTR) policies that store backups in a geo-redundant storage account. Option A is wrong because Azure Backup requires additional configuration and is not the native backup solution for Managed Instance. Option C is wrong because SQL Agent jobs require manual setup and maintenance.

Option D is wrong because BACPAC export is not a backup solution and does not support point-in-time restore.

Practice this question →
143
MCQhard

You have an Azure SQL Database that uses a SQL Agent job to run a critical ETL process every night. The job recently started failing intermittently. You need to automate the monitoring and alerting of job failures, and automatically retry the job twice with a 10-minute interval between retries. What should you configure?

A.Modify the job to use a T-SQL loop that checks job history and re-runs the job step.
B.Use Microsoft Power Automate to poll the job history and re-run the job if failed.
C.Create an Azure Monitor alert on the job failure event and use a webhook to trigger a PowerShell script that retries the job.
D.Configure the job step's 'Retry attempts' and 'Retry interval (minutes)' settings in the SQL Agent job step properties.
AnswerD

SQL Agent job steps have built-in retry configuration.

Why this answer

Option C is correct because SQL Agent jobs have built-in retry settings in the job step properties. Option A is wrong because Azure Monitor alerts can notify but do not automatically retry the job. Option B is wrong because it would require custom logic.

Option D is wrong because Power Automate can trigger retries but requires additional setup and is not native to SQL Agent.

Practice this question →
144
MCQhard

You have an Azure SQL Database configured with active geo-replication. You need to automate the failover process in the event of a regional outage, ensuring minimal data loss and automatic failback when the primary region recovers. What should you implement?

A.Configure an auto-failover group with a grace period of 1 hour.
B.Set up a PowerShell script that checks primary database health and initiates failover.
C.Use a ScheduledExecutorService in a Java application to monitor and failover.
D.Enable geo-replication and manually trigger failover when needed.
AnswerA

Auto-failover groups automate failover and failback, and the grace period allows for data loss tolerance.

Why this answer

Option A is correct because Azure SQL Database auto-failover groups provide automated failover and failback with a grace period for data loss tolerance. Option B is wrong because it does not automate failover. Option C is wrong because manual failover does not provide automatic failback.

Option D is wrong because ScheduledExecutorService is a manual workaround that does not integrate with Azure failover groups.

Practice this question →
145
Multi-Selecthard

Which THREE components are required to run Elastic Database Jobs for Azure SQL Database? (Choose three.)

Select 3 answers
A.A job database
B.Target databases (members of the job group)
C.A job agent
D.SQL Agent
E.Azure Automation account
AnswersA, B, C

Stores job definitions and execution history.

Why this answer

Elastic Database Jobs require a job database to store metadata, a job agent to orchestrate, and target databases. SQL Agent is not required. Elastic pool is optional.

Azure Automation is not required.

Practice this question →
146
MCQhard

You manage a critical Azure SQL Database that requires automated index maintenance. You need to ensure that index rebuilds only occur during low-usage periods defined in a schedule, while index reorganizations run more frequently. What is the most efficient way to implement this using Azure Automation?

A.Create an Elastic Database Job that runs a T-SQL script to rebuild and reorganize indexes based on fragmentation thresholds, scheduled via job schedule.
B.Configure SQL Agent on the Azure SQL Database logical server to run index maintenance jobs.
C.Use Azure Automation runbooks with the Invoke-Sqlcmd cmdlet to run index maintenance scripts on a schedule.
D.Deploy an Azure Function with a timer trigger that connects to the database and runs index maintenance commands.
AnswerA

Elastic Database Jobs are the recommended service for automating T-SQL tasks across one or many Azure SQL databases, with built-in scheduling and retry.

Why this answer

Azure Automation runbooks can execute T-SQL scripts, but they require maintaining a schedule and handling errors manually. Elastic Database Jobs are purpose-built for scheduling T-SQL against Azure SQL Databases, providing simple scheduling, retry logic, and built-in monitoring. Option A is correct.

Option B is less efficient because it requires more manual setup. Option C is not designed for this. Option D lacks scheduling.

Practice this question →
147
Multi-Selecthard

Which TWO actions are required to automate the export of an Azure SQL Database to a BACPAC file on a monthly basis? (Choose two.)

Select 2 answers
A.Configure long-term retention (LTR) policy for the database.
B.Use Azure Automation or a scheduled Azure Function to call the Export-AzSqlDatabase cmdlet.
C.Deploy a SQL Server on Azure VM to run the export command.
D.Install SQL Server Integration Services (SSIS) on a virtual machine.
E.Create an Azure Storage account with a container to store the BACPAC file.
AnswersB, E

Automation is needed to run the export on a recurring schedule.

Why this answer

To export a database to BACPAC, you need an Azure Storage account to store the file. The export is initiated via the Azure portal, PowerShell, Azure CLI, or REST API. No SQL Server on VM is required.

Option B and Option D are correct. Option A is not required as the export is done by Azure. Option C is for SQL Server on VM.

Option E is a feature for automated backups, not exports.

Practice this question →
148
MCQeasy

You need to automate the creation of an Azure SQL Database and a corresponding server-level firewall rule to allow access from a specific IP address. The deployment must be repeatable and version-controlled. What should you use?

A.Create an ARM template that defines both the server firewall rule and the database.
B.Write a PowerShell script that uses New-AzSqlDatabase and New-AzSqlServerFirewallRule.
C.Use the Azure portal to create the database and firewall rule.
D.Use SQL Server Management Studio to script the creation.
AnswerA

ARM templates are ideal for repeatable deployments and version control.

Why this answer

Option B is correct because ARM templates are declarative and version-controlled. Option A is wrong because the Azure portal is manual. Option C is wrong because SSMS is manual.

Option D is wrong because PowerShell is procedural, not the best for version-controlled repeatable deployments.

Practice this question →
149
MCQhard

You are a database administrator for a large e-commerce company that uses Azure SQL Database for its transactional systems. The environment consists of 50 databases across 10 logical servers, each with a mix of General Purpose and Business Critical service tiers. The company has a strict requirement to automatically scale databases based on workload patterns to optimize cost without manual intervention. Specifically, during Black Friday sales, one of the Business Critical databases (DB-Sales) experiences a surge in transactions, and you need to temporarily upgrade it to a higher service objective (S9 instead of S6) for 48 hours. After the sale, it should automatically revert to S6. Additionally, you need to ensure that all databases have automated backups with a 35-day point-in-time restore retention and that backup storage costs are minimized by using geo-redundant storage only for critical databases. You have been asked to design an automation solution using Azure native services. Which approach should you recommend?

A.Use Elastic Job agents to run a script that alters the service objective and configure backup retention using the Azure portal.
B.Enable autoscale on the database to automatically adjust service objective based on CPU usage.
C.Create a SQL Server Agent job that runs ALTER DATABASE MODIFY (SERVICE_OBJECTIVE = 'S9') and configure backup retention using T-SQL.
D.Use Azure Automation Runbooks scheduled to run before and after Black Friday to change the service objective, and set backup retention policies using Azure Policy.
AnswerD

Azure Automation Runbooks can be scheduled to change service objectives, and Azure Policy can enforce backup retention.

Why this answer

Option B is correct because Azure Automation Runbooks can be scheduled to change the service objective of a database, and policies for backup retention are set at the server level but can be overridden per database using ARM templates or PowerShell. Option A is wrong because elastic jobs are for executing scripts across databases, not for scheduling scaling. Option C is wrong because autoscale is not available for Azure SQL Database.

Option D is wrong because SQL Agent cannot change service objectives or set backup retention.

Practice this question →
150
MCQhard

You are responsible for automating backups of on-premises SQL Server databases to Azure Blob Storage. The solution must use the least administrative effort and provide point-in-time restore capability. What should you implement?

A.Configure SQL Server Managed Backup to Microsoft Azure.
B.Install Azure Backup Server on-premises and configure backup of SQL Server databases.
C.Use SQL Server Agent jobs to perform full, differential, and log backups to an Azure Blob Storage URL.
D.Use Azure Data Factory to copy database backups to Blob Storage.
AnswerA

Managed Backup automates backup scheduling and retention, and supports point-in-time restore.

Why this answer

SQL Server Managed Backup to Microsoft Azure (also known as Managed Backup) is the correct choice because it provides automated, policy-based backup management with minimal administrative effort. It natively supports point-in-time restore by automatically scheduling full, differential, and transaction log backups to Azure Blob Storage, and it handles backup retention and recovery point management without requiring custom scripts or additional infrastructure.

Exam trap

The trap here is that candidates often confuse Azure Backup Server (a general-purpose backup tool) with SQL Server Managed Backup, or they assume that manually scripting backups with SQL Server Agent jobs is the simplest approach, overlooking the built-in automation and point-in-time restore capabilities of Managed Backup.

How to eliminate wrong answers

Option B is wrong because Azure Backup Server requires installing and maintaining an on-premises server, which increases administrative effort and does not provide native point-in-time restore for SQL Server without additional configuration. Option C is wrong because using SQL Server Agent jobs to manually script full, differential, and log backups to Azure Blob Storage requires significant administrative effort to create, schedule, and maintain the jobs, and it does not offer the automated retention and recovery point management that Managed Backup provides. Option D is wrong because Azure Data Factory is an ETL and data orchestration service, not a backup solution; it cannot perform SQL Server transaction log backups or provide point-in-time restore capabilities.

Practice this question →
← PreviousPage 2 of 3 · 172 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Configure and manage automation of tasks questions.

Start 20-question session