Download Administering Relational Databases on Microsoft Azure.examboost.DP-300.2021-03-15.1e.56q.vcex

Azure Database Migration service  
Box 1: Premium 4-VCore 
Scenario: 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 VPN gateway 
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.  
Reference: 
https://azure.microsoft.com/pricing/details/database-migration/ 
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online

Scenario: Authenticate database users by using Active Directory credentials. 
The configuration steps include the following procedures to configure and use Azure Active Directory  authentication.  
Create and populate Azure AD.  
Optional: Associate or change the active directory that is currently associated with your Azure Subscription.  
Create an Azure Active Directory administrator. (Step 1)   
Configure your client computers.  
Create contained database users in your database mapped to Azure AD identities. (Step 2)  
Connect to your database by using Azure AD identities. (Step 3)  
Reference: 
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

Box 1: The server, the elastic pool, and the database 
Senario:  
SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool.  
Litware technical requirements include: 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.  
Box 2: Azure Event hubs 
Scenario: Migrate ManufacturingSQLDb1 to the Azure virtual machine platform. 
Event hubs are able to handle custom metrics.  
Incorrect Answers:  
Azure Log Analytics  
Azure metric and log data are sent to Azure Monitor Logs, previously known as Azure Log Analytics, directly by Azure. Azure SQL Analytics is a cloud only monitoring solution supporting streaming of diagnostics telemetry for all of your Azure SQL databases.   
However, because Azure SQL Analytics does not use agents to connect to Azure Monitor, it does not support monitoring of SQL Server hosted on-premises or in virtual machines.

SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.  
A: Use sys.dm_pdw_nodes_tran_locks instead of sys.dm_tran_locks from Azure Synapse Analytics (SQL Data Warehouse) or Parallel Data Warehouse.   
E: Example: 
The following query will show blocking information.  
SELECT     
        t1.resource_type,    
        t1.resource_database_id,    
        t1.resource_associated_entity_id,    
        t1.request_mode,    
        t1.request_session_id,    
        t2.blocking_session_id    
    FROM sys.dm_tran_locks as t1    
    INNER JOIN sys.dm_os_waiting_tasks as t2    
        ON t1.lock_owner_address = t2.resource_address;    
Note: Depending on the system you’re working with you can access these wait statistics from one of three locations: 
sys.dm_os_wait_stats: for SQL Server 
sys.dm_db_wait_stats: for Azure SQL Database 
sys.dm_pdw_nodes_os_wait_stats: for Azure SQL Data Warehouse 
Incorrect Answers: 
F: sys.dm_tran_locks returns information about currently active lock manager resources in SQL Server 2019 (15.x). Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.  
Instead use sys.dm_pdw_nodes_tran_locks.  
Reference: 
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql

Scenario: Authenticate database users by using Active Directory credentials. 
(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)  
Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user: 
CREATE USER [[email protected]] FROM EXTERNAL PROVIDER;  
Reference: 
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql 

Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the size of columnstore data by configuring an additional compression called archival compression.  
Note: Columnstore — The columnstore index is also logically organized as a table with rows and columns, but the data is physically stored in a column-wise data format.  
Incorrect Answers: 
B: Rowstore — The rowstore index is the traditional style that has been around since the initial release of SQL Server.  
For rowstore tables and indexes, use the data compression feature to help reduce the size of the database.  
Reference: 
https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.  
Note: SQL Managed Instance supports the following database migration options (currently these are the only supported migration methods): 
Azure Database Migration Service - migration with near-zero downtime.  
Native RESTORE DATABASE FROM URL - uses native backups from SQL Server and requires some downtime.  
Reference: 
https://docs.microsoft.com/en-us/sql/dma/dma-overview 

Box 1: Full and log backups only 
Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full backup and log backups to separate backup files.  
Box 2: WITH CHECKSUM 
Azure Database Migration Service uses the backup and restore method to migrate your on-premises databases to SQL Managed Instance. Azure Database Migration Service only supports backups created using checksum.  
Incorrect Answers: 
NOINIT Indicates that the backup set is appended to the specified media set, preserving existing backup sets. If a media password is defined for the media set, the password must be supplied. NOINIT is the default.  
UNLOAD  
Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default when a session begins.  
Reference: 
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online