Free DP-300 Questions for Microsoft Administering Relational Databases on Microsoft Azure DP-300 Exam as PDF & Practice Test Engine
Drag and Drop Question
You create an Azure SQL managed instance and a job that performs backups.
You need to configure the job to notify a distribution group by email when the job fails. The solution must minimize administrative effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You create an Azure SQL managed instance and a job that performs backups.
You need to configure the job to notify a distribution group by email when the job fails. The solution must minimize administrative effort.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Correct Answer:
Explanation:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql
You have an Azure subscription that contains a Microsoft SQL Server 2022 on Windows Server
2022 virtual machine named Server1. Server1 contains a database named DB1.
You need to back up DB1. The solution must meet the following requirements:
- Minimize how long it takes to perform the backup.
- Minimize the performance impact on Server1.
Which T-SQL statement should you run?
2022 virtual machine named Server1. Server1 contains a database named DB1.
You need to back up DB1. The solution must meet the following requirements:
- Minimize how long it takes to perform the backup.
- Minimize the performance impact on Server1.
Which T-SQL statement should you run?
Correct Answer: C
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
Drag and Drop Question
You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed.
You have an Azure subscription that contains an Azure SQL managed instance named Ml1. Ml1 contains a database named DB2.
You need to create a copy of DB2 on Server1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed.
You have an Azure subscription that contains an Azure SQL managed instance named Ml1. Ml1 contains a database named DB2.
You need to create a copy of DB2 on Server1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
Explanation:
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-database-to-sql-server
Case Study 1 - Litware, Inc
Overview
Litware, Inc. is a renewable energy company that has a main office in Boston. The main office hosts a sales department and the primary datacenter for the company.
Physical Locations
Existing Environment
Litware has a manufacturing office and a research office is separate locations near Boston. Each office has its own datacenter and internet connection.
The manufacturing and research datacenters connect to the primary datacenter by using a VPN.
Network Environment
The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet.
Identity Environment
Litware has a hybrid Azure Active Directory (Azure AD) deployment that uses a domain named litwareinc.com. All Azure subscriptions are associated to the litwareinc.com Azure AD tenant.
Database Environment
The sales department has the following database workload:
* An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1- TB databases.
* A logical server named SalesSrv01A contains a geo-replicated Azure SQL database named SalesSQLDb1. SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. SalesSQLDb1 uses database firewall rules and contained database users.
* An application named SalesSQLDb1App1 uses SalesSQLDb1.
The manufacturing office contains two on-premises SQL Server 2016 servers named SERVER2 and SERVER3. The servers are nodes in the same Always On availability group. The availability group contains a database named ManufacturingSQLDb1 Database administrators have two Azure virtual machines in HubVnet named VM1 and VM2 that run Windows Server 2019 and are used to manage all the Azure databases.
Licensing Agreement
Litware is a Microsoft Volume Licensing customer that has License Mobility through Software Assurance.
Current Problems
SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.
Requirements
Planned Changes
Litware plans to implement the following changes:
* Implement 30 new databases in Azure, which will be used by time-sensitive manufacturing apps that have varying usage patterns. Each database will be approximately 20 GB.
* Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01. ResearchDB1 will contain Personally Identifiable Information (PII) data.
* Develop an app named ResearchApp1 that will be used by the research department to populate and access ResearchDB1.
* Migrate ManufacturingSQLDb1 to the Azure virtual machine platform.
* Migrate the SERVER1 databases to the Azure SQL Database platform.
Technical Requirements
Litware identifies the following technical requirements:
* Maintenance tasks must be automated.
* The 30 new databases must scale automatically.
* The use of an on-premises infrastructure must be minimized.
* Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments.
* All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.
Security and Compliance Requirements
Litware identifies the following security and compliance requirements:
* Store encryption keys in Azure Key Vault.
* Retain backups of the PII data for two months.
* Encrypt the PII data at rest, in transit, and in use.
* Use the principle of least privilege whenever possible.
* Authenticate database users by using Active Directory credentials.
* Protect Azure SQL Database instances by using database-level firewall rules.
* Ensure that all databases hosted in Azure are accessible from VM1 and VM2 without relying on public endpoints.
Business Requirements
Litware identifies the following business requirements:
* Meet an SLA of 99.99% availability for all Azure deployments.
* Minimize downtime during the migration of the SERVER1 databases.
* Use the Azure Hybrid Use Benefits when migrating workloads to Azure.
* Once all requirements are met, minimize costs whenever possible.
Hotspot Question
You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.
What should you include in the migration plan? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Overview
Litware, Inc. is a renewable energy company that has a main office in Boston. The main office hosts a sales department and the primary datacenter for the company.
Physical Locations
Existing Environment
Litware has a manufacturing office and a research office is separate locations near Boston. Each office has its own datacenter and internet connection.
The manufacturing and research datacenters connect to the primary datacenter by using a VPN.
Network Environment
The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet.
Identity Environment
Litware has a hybrid Azure Active Directory (Azure AD) deployment that uses a domain named litwareinc.com. All Azure subscriptions are associated to the litwareinc.com Azure AD tenant.
Database Environment
The sales department has the following database workload:
* An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1- TB databases.
* A logical server named SalesSrv01A contains a geo-replicated Azure SQL database named SalesSQLDb1. SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. SalesSQLDb1 uses database firewall rules and contained database users.
* An application named SalesSQLDb1App1 uses SalesSQLDb1.
The manufacturing office contains two on-premises SQL Server 2016 servers named SERVER2 and SERVER3. The servers are nodes in the same Always On availability group. The availability group contains a database named ManufacturingSQLDb1 Database administrators have two Azure virtual machines in HubVnet named VM1 and VM2 that run Windows Server 2019 and are used to manage all the Azure databases.
Licensing Agreement
Litware is a Microsoft Volume Licensing customer that has License Mobility through Software Assurance.
Current Problems
SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.
Requirements
Planned Changes
Litware plans to implement the following changes:
* Implement 30 new databases in Azure, which will be used by time-sensitive manufacturing apps that have varying usage patterns. Each database will be approximately 20 GB.
* Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01. ResearchDB1 will contain Personally Identifiable Information (PII) data.
* Develop an app named ResearchApp1 that will be used by the research department to populate and access ResearchDB1.
* Migrate ManufacturingSQLDb1 to the Azure virtual machine platform.
* Migrate the SERVER1 databases to the Azure SQL Database platform.
Technical Requirements
Litware identifies the following technical requirements:
* Maintenance tasks must be automated.
* The 30 new databases must scale automatically.
* The use of an on-premises infrastructure must be minimized.
* Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments.
* All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.
Security and Compliance Requirements
Litware identifies the following security and compliance requirements:
* Store encryption keys in Azure Key Vault.
* Retain backups of the PII data for two months.
* Encrypt the PII data at rest, in transit, and in use.
* Use the principle of least privilege whenever possible.
* Authenticate database users by using Active Directory credentials.
* Protect Azure SQL Database instances by using database-level firewall rules.
* Ensure that all databases hosted in Azure are accessible from VM1 and VM2 without relying on public endpoints.
Business Requirements
Litware identifies the following business requirements:
* Meet an SLA of 99.99% availability for all Azure deployments.
* Minimize downtime during the migration of the SERVER1 databases.
* Use the Azure Hybrid Use Benefits when migrating workloads to Azure.
* Once all requirements are met, minimize costs whenever possible.
Hotspot Question
You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.
What should you include in the migration plan? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: Premium 4-VCore
Scenario:
An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases.
Migrate the SERVER1 databases to the Azure SQL Database platform.
Minimize downtime during the migration of the SERVER1 databases.
Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.
Incorrect Answers:
The Standard pricing tier suits most small- to medium- business workloads, but it supports offline migration only.
Box 2: A virtual network that has service endpoints
Scenario: The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering.
You need to create a Microsoft Azure Virtual Network for the Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.
Note: During virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned:
Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on) Storage endpoint Service bus endpoint This configuration is necessary because Azure Database Migration Service lacks internet connectivity.
Reference:
https://azure.microsoft.com/pricing/details/database-migration/
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online
You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
Correct Answer: C
Vote an answer
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
- Ensure that VM1 cannot connect to any Azure SQL Server other than
SqlSrv1.
- Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
- Ensure that VM1 cannot connect to any Azure SQL Server other than
SqlSrv1.
- Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
Correct Answer: D
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
Hotspot Question
You have an Azure subscription.
You deploy resources by using the following Bicep template.
For each of the following statements, select Yes if the statement is true, otherwise select No.
You have an Azure subscription.
You deploy resources by using the following Bicep template.
For each of the following statements, select Yes if the statement is true, otherwise select No.
Correct Answer:
Explanation:
Box 1: Yes
The azureADOnlyAuthentication (bool) property is not present.
If set to true then Azure Active Directory only Authentication enabled.
Mixed authentication will be supported.
Box 2: No
We see sku tier is Standard.
Azure SQL databases with the Standard tier do not support autoscale. Autoscale is a feature available in the Serverless compute tier of Azure SQL Database, where resources scale automatically based on workload demands. The Standard tier, part of the provisioned compute model, requires manual scaling or the use of Elastic Pools for resource sharing and scaling.
Box 3: No
The first line of the BICEP template would have to be like:
resource managedInstance 'Microsoft.Sql/managedInstances@2021-11-01-preview' = { Reference:
https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/managedinstances?pivots=deployment-language-bicep
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-bicep-quickstart
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.
Does this meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
You have five instances of SQL Server on Azure Virtual Machines.
You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort.
What should you use?
You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort.
What should you use?
Correct Answer: B
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
SIMULATION
You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Correct Answer:
Create a CPU status alert for a SQL Server on Azure
Create a metric alert with dynamic thresholds (Create an alert when a CPU exceeds an average) Step 1: In the search bar at the top of the Azure portal, type SQL, and select SQL databases.
Select the AdventureWorksLT database name listed.[Here db1]
Step 2: On the main blade for the database, navigate down to the monitoring section. Select Alerts.
Step 3: Select Create alert rule.
Step 4: In the Select a signal slide out, select CPU percentage.
Step 5: In the Configure signal slide out, select Dynamic for the Threshold property
Step 6: Then check that the Operator property is Greater than, the Aggregation type is Average.
Select Done.
(There is no Threshold value)
Step 7: Select the Actions tab.
Step 8: In the Actions tab, select Create action group.
Step 9: On the Action Group screen, type emailgroup in the Action group name field, and then select Next: Notifications.
Step 10: On the Notifications tab, enter the following information:
Notification type: Email/SMS message/Push/Voice
Note: When you select this option, a Email/SMS message/Push/Voice flyout will appear. Check the Email property and type: [[email protected]]
Step 11: Select Review + create, then select Create.
Note: Dynamic thresholds apply advanced machine learning and use a set of algorithms and methods to:
Learn the historical behavior of metrics
Analyze metrics over time and identify patterns such as hourly, daily or weekly patterns Recognize anomalies that indicate possible service issues Calculate the most appropriate threshold for the metric When you use dynamic thresholds, you don't have to know the "right" threshold for each metric, because dynamic thresholds calculate the most appropriate thresholds for you.
Reference:
https://microsoftlearning.github.io/dp-300-database-administrator/Instructions/Labs/12-create-cpu-status-alert.html
https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-dynamic-thresholds
Create a metric alert with dynamic thresholds (Create an alert when a CPU exceeds an average) Step 1: In the search bar at the top of the Azure portal, type SQL, and select SQL databases.
Select the AdventureWorksLT database name listed.[Here db1]
Step 2: On the main blade for the database, navigate down to the monitoring section. Select Alerts.
Step 3: Select Create alert rule.
Step 4: In the Select a signal slide out, select CPU percentage.
Step 5: In the Configure signal slide out, select Dynamic for the Threshold property
Step 6: Then check that the Operator property is Greater than, the Aggregation type is Average.
Select Done.
(There is no Threshold value)
Step 7: Select the Actions tab.
Step 8: In the Actions tab, select Create action group.
Step 9: On the Action Group screen, type emailgroup in the Action group name field, and then select Next: Notifications.
Step 10: On the Notifications tab, enter the following information:
Notification type: Email/SMS message/Push/Voice
Note: When you select this option, a Email/SMS message/Push/Voice flyout will appear. Check the Email property and type: [[email protected]]
Step 11: Select Review + create, then select Create.
Note: Dynamic thresholds apply advanced machine learning and use a set of algorithms and methods to:
Learn the historical behavior of metrics
Analyze metrics over time and identify patterns such as hourly, daily or weekly patterns Recognize anomalies that indicate possible service issues Calculate the most appropriate threshold for the metric When you use dynamic thresholds, you don't have to know the "right" threshold for each metric, because dynamic thresholds calculate the most appropriate thresholds for you.
Reference:
https://microsoftlearning.github.io/dp-300-database-administrator/Instructions/Labs/12-create-cpu-status-alert.html
https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-dynamic-thresholds
You have an on-premises Microsoft SQL Server 2022 instance named SQL1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
Correct Answer: D
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have the on-premises networks shown in the following table.
You have an Azure subscription that contains an Azure SQL Database server named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to configure access to DB1 and DB2. The solution must meet the following requirements:
- Ensure that DB1 can be accessed only by users in Branch1.
- Ensure that DB2 can be accessed only by users in Branch2.
Solution: You connect to DB1 and run the following command.
EXECUTE sp_set_firewall_rule 'Deny db1 users', '131.107.11.0',
'131.107.11.255'
You connect to DB2 and run the following command.
EXECUTE sp_set_database_firewall_rule 'Deny db2 users', '131.107.10.0',
'131.107.10.255'
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have the on-premises networks shown in the following table.
You have an Azure subscription that contains an Azure SQL Database server named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to configure access to DB1 and DB2. The solution must meet the following requirements:
- Ensure that DB1 can be accessed only by users in Branch1.
- Ensure that DB2 can be accessed only by users in Branch2.
Solution: You connect to DB1 and run the following command.
EXECUTE sp_set_firewall_rule 'Deny db1 users', '131.107.11.0',
'131.107.11.255'
You connect to DB2 and run the following command.
EXECUTE sp_set_database_firewall_rule 'Deny db2 users', '131.107.10.0',
'131.107.10.255'
Does this meet the goal?
Correct Answer: B
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
Hotspot Question
You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: sys.resource_stats
sys.resource_stats returns CPU usage and storage data for an Azure SQL Database. It has database_name and start_time columns.
Box 2: DateAdd
The following example returns all databases that are averaging at least 80% of compute utilization over the last one week.
DECLARE @s datetime;
DECLARE @e datetime;
SET @s= DateAdd(d,-7,GetUTCDate());
SET @e= GETUTCDATE();
SELECT database_name, AVG(avg_cpu_percent) AS Average_Compute_Utilization FROM sys.resource_stats WHERE start_time BETWEEN @s AND @e GROUP BY database_name HAVING AVG(avg_cpu_percent) >= 80 Incorrect Answers:
sys.dm_exec_requests:
sys.dm_exec_requests returns information about each request that is executing in SQL Server. It does not have a column named database_name.
sys.dm_db_resource_stats:
sys.dm_db_resource_stats does not have any start_time column.
Note: sys.dm_db_resource_stats returns CPU, I/O, and memory consumption for an Azure SQL Database database. One row exists for every 15 seconds, even if there is no activity in the database. Historical data is maintained for approximately one hour.
Sys.dm_user_db_resource_governance returns actual configuration and capacity settings used by resource governance mechanisms in the current database or elastic pool. It does not have any start_time column.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-resource-stats-azure-sql-database
SIMULATION
You need to classify the StandardCost and ListPrice columns of the SalesLT.Product table in db1. The columns must have the following configurations:
- An information type of Financial
- A sensitivity label of Confidential
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to classify the StandardCost and ListPrice columns of the SalesLT.Product table in db1. The columns must have the following configurations:
- An information type of Financial
- A sensitivity label of Confidential
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Correct Answer:
To classify your SQL Server database:
Step 1: In SQL Server Management Studio (SSMS), connect to the SQL Server.
Step 2: In the SSMS Object Explorer, select the database [Here db1] that you would like to classify and choose Tasks > Data Discovery and Classification > Classify Data....
Step 3: The classification engine scans your database for columns containing potentially sensitive data and provides a list of recommended column classifications:
Step 4: You can change the recommended Information Type and Sensitivity Label using the drop- down boxes.
Step 5: Select columns StandardCost and ListPrice. Unselect other columns if necessary. For StandardCost and ListPrice columns select information type of Financial, and sensitivity label of Confidential.
Step 6: To apply the selected recommendations, select the Save selected recommendations button.
Step 7: To display the classified columns, select appropriate schema and corresponding table from the drop-down, then select Load Columns.
Step 8: You can also manually classify columns as an alternative, or in addition, to the recommendation-based classification:
Select Add classification in the top menu of the window.
Step 9: If you want to add classification for all the unclassified columns for a specific table in a single attempt, then select All Unclassified in the Column drop down of Add Classification page.
Step 10: To complete your classification and persistently label (tag) the database columns with the new classification metadata, select the Save button on the top menu of the window.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification
Step 1: In SQL Server Management Studio (SSMS), connect to the SQL Server.
Step 2: In the SSMS Object Explorer, select the database [Here db1] that you would like to classify and choose Tasks > Data Discovery and Classification > Classify Data....
Step 3: The classification engine scans your database for columns containing potentially sensitive data and provides a list of recommended column classifications:
Step 4: You can change the recommended Information Type and Sensitivity Label using the drop- down boxes.
Step 5: Select columns StandardCost and ListPrice. Unselect other columns if necessary. For StandardCost and ListPrice columns select information type of Financial, and sensitivity label of Confidential.
Step 6: To apply the selected recommendations, select the Save selected recommendations button.
Step 7: To display the classified columns, select appropriate schema and corresponding table from the drop-down, then select Load Columns.
Step 8: You can also manually classify columns as an alternative, or in addition, to the recommendation-based classification:
Select Add classification in the top menu of the window.
Step 9: If you want to add classification for all the unclassified columns for a specific table in a single attempt, then select All Unclassified in the Column drop down of Add Classification page.
Step 10: To complete your classification and persistently label (tag) the database columns with the new classification metadata, select the Save button on the top menu of the window.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification
Drag and Drop Question
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
Correct Answer:
0
0
0
10