Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Introduction to Azure database administration Microsoft Quiz Answers
Get Introduction to Azure database administration Microsoft Quiz Answers
Microsoft Azure provides a set of seamless capabilities for SQL databases. Explore the different database offerings, and services available to help you get started.
This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions.
Prerequisites:
- Familiarity with on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks.
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Module 1: Prepare to maintain SQL databases on Azure
Explore the role of a database administrator on Azure. Describe SQL Server-based offerings on Azure.
Learning objectives:
At the end of this module, you will be able to:
- Understand the role of Azure Database Administrator as it fits in with other data platform roles.
- Describe the key differences between the SQL Server-based database options in Azure.
- Describe other features for Azure SQL platforms available.
Prerequisites:
- Ability to navigate the Azure the portal.
- Understanding of the traditional Database Administration role.
- Experience with T-SQL programing language at a basic level.
Quiz 1: Knowledge check
Q1. What Azure storage is recommended for production data files that requires maximum throughput?
- Premium SSD
- Ultra SSD
- Standard SSD
Q2. What option should you select to change the auto-pause setting of a serverless SQL Database?
- The auto-pause setting can’t be changed, and it’s fixed at one hour
- Ensure that there are no active transactions in the database, as the auto-pause change will result in a disconnection
- The Azure portal allows you to change the auto-pause setting at any time
Q3. Which SQL Server PaaS offering should you choose if you want to restore an on-premises database backup to Azure?
- Azure SQL Managed Instance
- Azure SQL Database
- You can use both Azure SQL Database and Azure SQL Managed Instance.
Conclusion:
I hope this Introduction to Azure database administration 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!
More Coding Solutions >>
