Download Provisioning SQL Databases.70-765.ActualTests.2018-12-01.98q.vcex

For a database size of 500 GB the Premium tier is required. Both P1 and P2 are adequate. P1 is preferred as it is cheaper. Note:    Incorrect Answers:A, C: Maximum database size is 250 GB for the Standard pricing tier.References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers

In SQL Database, the relative measure of a database's ability to handle resource demands is expressed in Database Transaction Units (DTUs) for single databases and elastic DTUs (eDTUs) for databases in an elastic pool. A pool is given a set number of eDTUs, for a set price. Within the pool, individual databases are given the flexibility to auto-scale within set parameters. Under heavy load, a database can consume more eDTUs to meet demand. Additional eDTUs can be added to an existing pool with no database downtime. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-transact-sql#add-secondary-database

Data Entry: Geo-replicated database onlyFrom Contoso scenario: Each location database for the data entry application may have an unpredictable amount of activity. Data must be replicated to secondarydatabases in Azure datacenters in different regions. Business intelligence: Elastic database pools onlyFrom Contoso scenario: For the business intelligence application, corporate executives must be able to view all data in near real-time with low network latency.SQL DB elastic pools provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage patterns. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

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

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/