QUESTION 167You plan to migrate a Microsoft SQL server instance between physical servers.You must migrate the metadata associated with the database instance.You need to ensure that the new instance retains the existing jobs and alerts.Solutions: You restore the master database.Does the solution meet the goal??

A. YesB. No

Answer: BExplanation:The master database does not handle alerts and jobs. It records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail.References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017

QUESTION 168You plan to migrate a Microsoft sql server instance between physical servers.You must migrate the metadata associated with the database instance. You need to ensure that the new instance retains the existing jobs and alerts.Solutions: You restore the model database.Does the solution meet the goal?

QUESTION 169You plan to migrate a Microsoft SQL server instance between physical servers.You must migrate the metadata associated with the database instance.You need to ensure that the new instance retains the existing jobs and alerts.Solutions: You restore the msdb database.Does the solution meet the goal?

QUESTION 170You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.You need to implement real-time encryption of the database and all backups.Solution: you enable Dynamic Data Masking on the primary replica.Does the solution meet the goal?

A. YesB. No

Answer: BExplanation:SQL Database dynamic data masking does not encrypt the data.Transparent Data Encryption (TDE) would provide a solution.Note: SQL Database dynamic data masking limits sensitive data exposure by masking it to non-privileged users.Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer.References: https://azure.microsoft.com/en-us/blog/how-to-configure-azure-sql-database-geo-dr-with-azure-key-vault/

QUESTION 171You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.You need to implement real-time encryption of the database and all backups.Solution: You enable Transparent Data Encryption (TDE) on the primary instance.Does the solution meet the goal?

A. YesB. No

Answer: AExplanation:Azure SQL Database and Data Warehouse offer encryption-at-rest by providing Transparent Data Encryption (TDE) for all data written to disk, including databases, log files and backups. This protects data in case of unauthorized access to hardware. TDE provides a TDE Protector that is used to encrypt the Database Encryption Key (DEK), which in turn is used to encrypt the data. With the TDE and Bring Your Own Key (BYOK) offering currently in preview, customers can take control of the TDE Protector in Azure Key Vault.Taking advantage of TDE with BYOK for databases that are geo-replicated to maintain high availability requires to configure and test the scenario carefully.References: https://azure.microsoft.com/en-us/blog/how-to-configure-azure-sql-database-geo-dr-with-azure-key-vault/

QUESTION 172You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.You need to implement real-time encryption of the database and all backups.Solution: You password protect all azure SQL backups and enable azure active directory authentication for all azure SQL server instances.Does the solution meet the goal?

QUESTION 173You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.You need to implement real-time encryption of the database and all backups.Solution: You use the always Encrypted wizard to encrypt all possible for the tables in the primary instance.Does the solution meet the goal?

QUESTION 174You manage a Microsoft SQL Server environment with several databases.You need to ensure that queries use statistical data and do not initialize values for local variables.Solution: you set the value of the MAXDOP parameter to 2.Does the solution meet the goal?

QUESTION 175You have Microsoft SQL Server on a Microsoft Azure virtual machine that has a database named DB1.You discover that DB1 experiences WRITE_LOG waits that are longer than 50 ms.You need to reduce the WRITE_LOG wait time.Solution: Add additional log files to DB1.Does this meet the goal?

QUESTION 176Settings ValueVM size D3Storage Location Drive EStorage type StandardTempdb location Drive CThe workload on this instance has of the tembdb load.You need to maximize the performance of the tempdb database.Solution: You use a D-Series VM and store the tempdb database on drive D.Does this meet the goal?

QUESTION 177Settings ValueVM size D3Storage Location Drive EStorage type StandardTempdb location Drive CThe workload on this instance has of the tembdb load.You need to maximize the performance of the tempdb database.Solution: You use an AB compute-intensive instance and store the tempdb database in Standard storage.Does this meet the goal?