Configure and manage automation of tasks Questions
Practice questions for Configure and manage automation of tasks topic in Microsoft Certified: Azure Database Administrator Associate. 34 questions covering this domain.
A DBA creates an elastic job schedule with a start time in the past and later enables the job. What should the DBA expect?
Which Azure SQL feature lets you schedule Transact-SQL jobs across one or many Azure SQL databases?
A job target group in elastic jobs includes an Azure SQL logical server. What happens at runtime?
What is the recommended authentication method for connecting an elastic job agent to target Azure SQL databases?
Why do many teams choose Bicep for Azure SQL infrastructure deployment automation?
A failover moves the region hosting an elastic jobs environment. What must be done before scheduled jobs resume in the new region?
Which automation option is available in Azure SQL Managed Instance but not in Azure SQL Database as a built-in Windows service feature?
An elastic job agent uses private endpoints to reach target servers. Which connection still does not use those private endpoints?
Which Azure service can trigger an automated workflow when an Azure SQL Database alert fires (e.g., DTU > 90%) and call into other systems?
A team uses Azure DevOps to run nightly maintenance scripts against multiple Azure SQL databases without storing passwords in pipelines. What is the r...
On Azure SQL Managed Instance, which SQL Server Agent job step types are supported?
Which Azure service provides PowerShell or Python runbooks on a schedule to automate Azure SQL administrative tasks?
A team wants to deploy database schema and seed data via CI/CD as part of an Azure DevOps pipeline targeting Azure SQL Database. Which artifact and ta...
An elastic jobs solution must execute T-SQL across 200 databases in parallel with reasonable concurrency control. Which configuration setting governs ...
An elastic job is configured to write its output to a destination database. Where is the output table written?
A DBA wants to deploy an Azure SQL Database with a database-level configuration like server name, SKU, and firewall rules using declarative JSON. Whic...
A SQL Server Agent alert is configured to fire when error 1205 (deadlock victim) occurs. The DBA also wants the alert to capture the deadlock graph fo...
A team's elastic job uses a managed identity to connect to target Azure SQL databases. The job fails with a login error on a recently added target dat...
A DBA troubleshoots a SQL Server Agent job that fails intermittently. Which SQL Server system table or view should they query to review the job histor...
A DBA uses Azure PowerShell to automate the restore of an Azure SQL Database to a point in time in a CI/CD pipeline. Which Azure PowerShell cmdlet per...
Sign in to see all 34 questions
Create a free account to browse all questions — completely free during our launch phase.