Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Automate database tasks for Azure SQL Microsoft Quiz Answers
Get Automate database tasks for Azure SQL Microsoft Quiz Answers
Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.
This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions.
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Experience creating and configuring resources using the Azure portal
Module 1: Automate deployment of database resources
Explore multiple deployment models available on Azure. Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources. Understand how to use PowerShell and Azure CLI for automation purposes.
Learning objectives:
After completing this module, you will be able to:
- Describe the deployment models available on Azure
- Deploy database resources using PowerShell and Azure CLI
- Deploy an Azure Resource Manager template and Bicep
- Understand the difference between multiple command-line options
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Experience creating and configuring resources using the Azure portal.
This module is part of these learning paths:
Quiz 1: Knowledge check
Q1. What language are Azure Resource Manager templates written in?
- JSON
- C#
- T-SQL
Q2. Which option should you include in your template when specifying the region for a resource group deployment?
- Parameter
- Variable
- Output
Q3. Which element of a template allows for you to build dependencies into resources?
- dependsOn
- concat
- apiVersion
Q4. Which Azure CLI command should you choose to create a SQL Database server?
- az sql db op
- az sql server create
- az sql db create
Module 2: Create and manage SQL Agent jobs
Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.
Learning objectives:
After completing this module, you will be able to:
- Schedule necessary maintenance activities for your databases.
- Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
- Configure alerts based on performance monitor values.
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL Server database, either on-premises or on cloud.
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Experience creating, and configuring resources using the Azure portal.
This module is part of these learning paths:
Quiz 1: Knowledge check
Q1. What has to be configured before the SQL Server Agent can send email?
- A mail profile
- An agent job
- An alert
Q2. Which system database stores SQL Server Agent jobs and their information?
- Msdb
- Master
- Model
Q3. Which operation recalculates the statistics on an index?
- Rebuild
- Reorganize
- Shrinking a file group
Q4. What built-in option removes old files related to maintenance plans?
- Cleanup history task
- Maintenance cleanup task
- Execute SQL Server agent job task
Module 3: Manage Azure PaaS tasks using automation
Explore automation for Azure SQL platform. Configure elastic jobs, explore Azure Automation, and evaluate different strategies for monitoring automation tasks.
Learning objectives:
After completing this module, you will be able to:
- Undersand the benefits of Azure policy
- Explore the capabilities of Azure Automation
- Configure elastic jobs
- Use Logic Apps for database workflow
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Experience creating and configuring resources using the Azure portal.
- Familiarly with Open Source database systems on Azure.
This module is part of these learning paths:
Quiz 1: Knowledge check
Q1. What is the unit of execution for your Azure Automation Account?
- Runbook
- Schedule
- Container
Q2. What scope can Azure Policy be deployed to?
- Tenant
- Subscription
- User
Q3. What is the name for the scope that you must define for a SQL Elastic Job?
- Target Group
- Management Group
- Resource Group
Conclusion:
I hope this Automate database tasks for Azure SQL Microsoft Quiz Answers would be useful for you to learn something new from this problem. If it helped you then don’t forget to bookmark our site for more Coding Solutions.
This Problem is intended for audiences of all experiences who are interested in learning about Data Science in a business context; there are no prerequisites.
Keep Learning!
