Download Provisioning SQL Databases.70-765.PracticeTest.2019-02-01.107q.tqb

Always On availability groups supports two availability modes—asynchronous-commit mode and synchronous-commit mode Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency. References: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups#SyncCommitAvMode

To set up a readable secondary replica, you first create an availability group. Then you add replicas. You can choose either Yes or Read-intent only options.   References: http://msdn.microsoft.com/en-us/library/jj542414.aspx

You would need to use either the SQL Server Management Studio or Transact-SQL. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. B: In the contained database user model, the login in the master database is not present. Instead, the authentication process occurs at the user database, and the database user in the user database does not have an associated login in the master database.SQL Database and SQL Data Warehouse support Azure Active Directory identities as contained database users. D: The contained database feature is currently available only in a partially contained state. A partially contained database is a contained database that allows the use of uncontained features.References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases

Incorrect Answers:A, D: Express edition has severe limitations.C: SQL Server 2012 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.References: https://msdn.microsoft.com/en-us/library/ms144275(v=sql.110).aspx

Incorrect Answers:A, C: The awefeature will be removed in newer version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.B: Automatic soft-NUMA is disabled by default, and this setting is not relevant here.References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server

There are two high-level categories of key stores to consider - Local Key Stores, and Centralized Key Stores. Centralized Key Stores - serve applications on multiple computers. An example of a centralized key store is Azure Key Vault. Local Key Stores References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/create-and-store-column-master-keys-always-encrypted

P10 has 500 IOPS per disk, which provides for more than 1 million IOPS per month. Note: 3600*30* 500 is 54 million IOPS/month.References: https://azure.microsoft.com/en-us/pricing/details/managed-disks/

SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources (elastic Database Transaction Units (eDTUs)) at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

The New-AzureRmSqlDatabaseCopy command creates a copy of a SQL Database that uses the snapshot at the current time. References: https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabasecopy?view=azurermps-5.1.1