MCP 70-473 Designing and Implementing Cloud Data Platform Solutions 過去問から参考URL整理

#メモ
過去問を丸暗記しても合格できるが、せっかくなので読んでおいた。

##Azure SQL Database のエラスティック クエリの概要
https://docs.microsoft.com/ja-jp/azure/sql-database/sql-database-elastic-query-overview


##SQL Server データベースのクラウド内の SQL Database への移行
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-migration-wizard/


##Azure の Windows 仮想マシンのサイズ
https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-windows-sizes/
https://docs.microsoft.com/ja-jp/azure/virtual-machines/virtual-machines-windows-sizes?toc=%2fazure%2fvirtual-machines%2fwindows%2ftoc.json

##Row-Level Security
https://msdn.microsoft.com/en-us/library/dn765131.aspx

##Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server
https://blogs.msdn.microsoft.com/buckwoody/2013/01/08/microsoft-windows-azure-disaster-recovery-options-for-on-premises-sql-server/


##監査 How to set up and use SQL Server Audit
http://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/


##Azure SQL Database Query Performance Insight
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-query-performance/


##SQL Database options and performance: Understand what's available in each service tier
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/


##Manage compute power in Azure SQL Data Warehouse
https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-manage-compute-overview/


##Write SQL Server Audit Events to the Security Log
https://msdn.microsoft.com/en-us/library/cc645889.aspx


##Monitoring Azure SQL Database using dynamic management views
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/


##Azure Portal を使用したエラスティック プールの作成と管理
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-pool-create-portal/


##Azure Monitorでの Azure サービス メトリック アラートの作成 - Azure Portal
http://msdn.microsoft.com/en-us/library/azure/dn306639.aspx

##System Dynamic Management Views
https://msdn.microsoft.com/en-us/library/ms188754.aspx

##Always Encrypted: Protect sensitive data in SQL Database and store your encryption keys in the Windows certificate store
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-always-encrypted/


##Back up an Azure VM using Microsoft Azure Automation
https://blogs.technet.microsoft.com/cbernier/2014/04/28/back-up-an-azure-vm-using-microsoft-azure-automation/

##Azure SQL Database elastic query overview
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-query-overview/


##What is Azure SQL Data Warehouse?
https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-what-is/

##New-​Azure​Sql​Database
https://msdn.microsoft.com/en-us/library/dn546722.aspx


##SQL Server Backup to URL
https://msdn.microsoft.com/en-us/library/dn435916.aspx

##Performance recommendations
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/

##Stop-​Azure​VM
https://msdn.microsoft.com/en-us/library/azure/dn495269.aspx

##How to enable TDE Encryption on a database in an Availability Group
https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-availability-group/

##Configuring the Azure SQL Database Firewall
http://azure.patrickkeisler.com/2015/11/configuring-the-azure-sql-database-firewall/
https://msdn.microsoft.com/en-gb/library/dn270010.aspx

##Connection Pooling for the SQL Server DBA
https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/10/08/connection-pooling-for-the-sql-server-dba/

##Azure SQL Database DTU Calculator
http://dtucalculator.azurewebsites.net/