70-765 Provisioning SQL Databases Practice Questions
Prepare for 70-765 with more than an answer.
- 1
You have been tasked with migrating a database with a 500 GB size limit, to Microsoft Azure SQL Database. You have been informed that the fees relating to hosting the database should be reduced, but still be able to support fifty simultaneous logins. You need to make use of a suitable pricing tier when generating the database.
Solution: You choose the Premium P2 tier for the database.
Has the requirement been satisfied?
Show answer details
Correct answer: A
Explanation:
The Premium P2 tier is adequate, but pricey.
References: docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers - 2
You are developing a database application using Microsoft SQL Server 2012. You want to make use of an INNER JOIN to specify a computed column that references a lookup table.
Solution: You configure the use of stored procedure.
Has the requirement been satisfied?
Show answer details
Correct answer: A
A
- 3
You are preparing to provide support for a batch processing application by deploying 25 Microsoft Azure SQL Database instances to an elastic pool in Azure. You notice that two of the databases in the pool reach their peak workload threshold simultaneously on a daily basis, which results in erratic batch completion performance. You are required to make sure that all batches execute reliably.
Solution: You raise the pool’s storage limit.
Has the requirement been satisfied?
Show answer details
Correct answer: A
A
