Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Implement a secure environment for a database service Microsoft Quiz Answers
Get Implement a secure environment for a database service Microsoft Quiz Answers
Implement SQL Server-based options for authentication and authorization, as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.
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
- Understanding of why security is a crucial part of database system planning
- 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: Configure database authentication and authorization
Contrast authentication using Azure Active Directory, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.
Learning objectives:
After completing this module, you will be able to:
- Learn about authentication options for Azure SQL Database
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication and authorization failures
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises or cloud-based
- Understanding of why security is a crucial part of database system planning
- 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. Which protocol is used by Azure Active Directory for Authorization?
- Kerberos
- LDAP
- OAuth
Q2. Which database stores the information about logins in SQL Server?
- master
- model
- msdb
Q3. Which role allows users to create users within a database?
- db_datareader
- db_accessadmin
- db_securityadmin
Q4. Which permission allows the user to perform any option against a database object?
- Control
- Delete
- View Definition
Q5. What feature allows a user to execute a stored procedure without having permission to access the tables referenced in the stored procedure?
- Ownership chaining
- Principle of least privilege
- Granular security
Module 2: Protect data in-transit and at rest
Explore encryption options available within Azure SQL, including firewall rules, Always Encrypted, and Transport Layer Security. Understand how SQL Injection works.
Learning objectives:
After completing this module, you will be able to:
- Understand the data encryption options available in the various platforms
- Implement object level encryption
- Understand the difference between database and server firewall rules for Azure SQL Database
- Explore Always Encrypted with secure enclaves
Prerequisites:
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises or cloud-based
- Understanding of why security is a crucial part of database system planning
- 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. Which security object is required in order to enable transparent data encryption?
- Credential
- Master Key
- User
Q2. Which feature prevents members of the sysadmin role from viewing the values of data in a table?
- Always Encrypted
- Dynamic Data Masking
- Transparent Data Encryption
Q3. Which TLS version offers the most secure option for encryption?
- TLS 1.1 version
- TLS 1.0 version
- TLS 1.2 version
Q4. Which feature provides a private IP address for an Azure SQL Database?
- Network Endpoints
- Private Link
- Database Firewall
Q5. Which technique can be used to create database firewall rules in Azure SQL Database?
- Running a PowerShell script
- Running an Azure CLI script
- Executing a T-SQL statement
Module 3: Implement compliance controls for sensitive data
Explore data classification capabilities and degrees of confidentiality. Implement security options to maintain private data safe, including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Azure SQL Database Ledger.
Learning objectives:
After completing this module, you will be able to:
- Plan and implement data classification in Azure SQL Database
- Understand and configure row-level security and dynamic data masking
- Understand the usage of Microsoft Defender for SQL
- Explore how Azure SQL Database Ledger works
Prerequisites:
- Ability to write code in the SQL language, particular 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. Where is the data from data classification stored in SQL Server 2019?
- In the extended properties for each object
- In the sys.sensitivity_classifications catalog view
- In the sys.all_columns catalog view
Q2. Which server-level action group audits queries and stored procedures executed against an Azure SQL Database?
- BATCH_STARTED_GROUP
- BATCH_COMPLETED_GROUP
- SENSITIVE_BATCH_COMPLETED_GROUP
Q3. Which block predicate prevents users from updating rows to values that violate its row-level security predicate?
- AFTER INSERT
- BEFORE UPDATE
- AFTER UPDATE
Q4. Which of the following features can be used to automate data discovery through the provision of data scanning and classification as a service?
- Database auditing
- Dynamic data masking
- Azure Purview
Conclusion:
I hope this Implement a secure environment for a database service 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 >>
