Download Administering Relational Databases on Microsoft Azure.dump4pass.DP-300.2021-11-27.6e.117q.vcex

Reference: 
https://docs.microsoft.com/en-us/azure/dms/dms-overview 

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 
YouneedtocreateaMicrosoftAzureVirtualNetworkfortheAzureDatabaseMigrationServicebyusingtheAzureResourceManagerdeploymentmodel,which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute orVPN.    
Reference: 
https://azure.microsoft.com/pricing/details/database-migration/   
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-onlinecorrected

CE: Estimate the vCores needed for the pool as follows: 
For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB)  
A: Estimate the storage space needed for the pool by adding the number of bytes needed for all the databases in the pool. 
Reference: 
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overviewconfirmed

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—Thecolumnstoreindexisalsologicallyorganizedasatablewithrowsandcolumns,butthedataisphysicallystoredinacolumn-wisedata 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

This table lists the key features for PolyBase and the products in which they're available.  
  
      

Incorrect Answers: 
C: Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. It applies to both Azure SQL Database and SQL Server.    
D: Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.    
Reference: 
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

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-onlineconfimred

confirmed

Box 1: blob 
The following example creates an external data source for Azure Data Lake Gen2  
CREATE EXTERNAL DATA SOURCE YellowTaxi  
WITH ( LOCATION = 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/', 
TYPE = HADOOP)    
Box 2: HADOOP   
Reference: 
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tablescorrected

Box 1: .partitionBy 
Example: 
df.write.partitionBy("y","m","d")    
.mode(SaveMode.Append)    
.parquet("/data/hive/warehouse/db_name.db/" +  
tableName) Box 2: ("Year","Month","Day","Hour","StoreID") 
Box 3: .parquet("/Purchases")   
Reference: 
https://intellipaat.com/community/11744/how-to-partition-and-write-dataframe-in-spark-without-deleting-partitions-with-no-new-data