Important link for Certification No 70-473 -Designing and Implementing Cloud Data Platform Solutions

Performance recommendations for SQL Database

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-advisor

For more information about automatic tuning of database indexes and query execution plans, see Azure SQL Database automatic tuning.

For more information about automatically monitoring database performance with automated diagnostics and root cause analysis of performance issues, see Azure SQL Intelligent Insights.

For more information about how to use performance recommendations in the Azure portal, see Performance recommendations in the Azure portal.

See Query Performance Insights to learn about and view the performance impact of your top queries.

A.Monitor Subscription Activity with the Azure Activity Log

 https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-overview-activity-logs

B.Use AzureRM.RecoveryServices.Backup cmdlets to back up virtual machines

  https://docs.microsoft.com/en-us/azure/backup/backup-azure-vms-automation

C.Monitoring Azure SQL Database using dynamic management views

  https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs

D.Artificial Intelligence tunes Azure SQL Databases

  https://azure.microsoft.com/en-us/blog/artificial-intelligence-tunes-azure-sql-databases/

E.Write SQL Server Audit Events to the Security Log

  https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/write-sql-server-audit-events-to-the-security-log

F.Always Encrypted (Database Engine)

  https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine

G.SQL Server Audit feature – Introduction

 https://solutioncenter.apexsql.com/sql-server-audit-feature-introduction/

H.How to set up and use SQL Server Audit

 https://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/

I.Azure SQL Database elastic query overview (preview)

  https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview

J.Using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio to move to the Cloud

https://www.mssqltips.com/sqlservertip/3035/using-the-deploy-database-to-sql-azure-wizard-in-sql-server-management-studio-to-move-to-the-cloud/

K.Azure SQL Database Query Performance Insight

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-query-performance

L.Monitoring Azure SQL Database using dynamic management views

  https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs

M.Troubleshoot Azure SQL Database performance issues with Intelligent Insights

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-intelligent-insights-troubleshoot-performance

N.Elastic pools help you manage and scale multiple Azure SQL databases

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

O.Always Encrypted: Protect sensitive data in SQL Database and store your encryption keys in the Windows certificate store

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted

P.Always Encrypted: Protect sensitive data in SQL Database and store your encryption keys in Azure Key Vault

 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted-azure-key-vault

Q.Data Warehouse Units (DWUs) and compute Data Warehouse Units (cDWUs)

 https://docs.microsoft.com/en-us/azure/sql-data-warehouse/what-is-a-data-warehouse-unit-dwu-cdwu

L.Migrate SQL Server database to SQL Database using Deploy Database to Microsoft Azure Database Wizard

 https://github.com/Huachao/azure-content/blob/master/articles/sql-database/sql-database-cloud-migrate-compatible-using-ssms-migration-wizard.md

M.Create,view, and manage alerts using Azure Monitor

 https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitor-alerts-unified-usage

N.What are Azure resource diagnostic logs &Collect and consume log data from your Azure resources

 https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-overview-of-diagnostic-logs