Validity and reliability anchor the Microsoft Provisioning SQL Databases bank at CertkingdomPDF — 070-765 content refined against the live exam outline, answers verified by IT specialists, and daily checks that keep everything current.
Microsoft 070-765 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Deploy and Migrate Applications / Manage Storage | - Manage SQL Storage and perform database maintenance - Deploy applications to Azure SQL Database or SQL Server on Azure VM - Migrate on-premises SQL Server databases to Azure |
| Manage Databases and Instances | - Manage SQL Server instances - Configure SQL Server performance settings - Configure secure access to Azure SQL Databases |
| Implement SQL in Azure | - Deploy SQL Server instances - Plan SQL Server installation - Deploy Microsoft Azure SQL Database - Deploy SQL Server databases to Azure VMs |
Preparing for 070-765 on a Busy Schedule
- Deploy and Migrate Applications / Manage Storage ()
- Manage Databases and Instances ()
- Implement SQL in Azure ()
Microsoft Provisioning SQL Databases Sample Questions:
You are building the database platform for a multi-tenant application. The application will have one database per tenant and there will be 30 tenants. The application will require at least 10 GB of In-Memory OLTP per tenant database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory#additional-resources
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
A company plans to run Microsoft SQL Server on Linux-based servers.
You need to ensure that performance tuning settings are automatically configured during installation.
Which Linux platform should you recommend?
- A. SUSE
- B. Kali Linux
- C. RHEL
- D. Ubuntu Server
Correct Answer: C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You use Resource Manager to deploy a new Microsoft SQL Server instance in a Microsoft Azure virtual machine (VM) that uses Premium storage. The combined initial size of the SQL Server user database files is expected to be over 200 gigabytes (GB). You must maximize performance for the database files and the log file.
You add the following additional drive volumes to the VM:
You have the following requirements:
Maximize performance of the SQL Server instance.
Use Premium storage when possible.
You need to deploy the SQL instance.
In the table below, identify the drive where you must store each SQL Server file type.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Correct Answer:
Explanation:
Enable read caching on the disk(s) hosting the data files and TempDB.
Do not enable caching on disk(s) hosting the log file. Host caching is not used for log files.
Incorrect Answers:
C, D: Avoid using operating system or temporary disks for database storage or logging.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
A company uses several Microsoft Azure elastic pools with Azure SQL Database instances.
You have two pools named Pool1 and Pool2. Pool2 is near maximum capacity and cannot accommodate the database move.
You need to move the database from Pool1 to Pool2.
Which PowerShell cmdlets should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
References:
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/set-azurermsqlelasticpool?view=azurermps-6.12.0
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/set-azurermsqldatabase?view=azurermps-6.12.0
You administer a Microsoft SQL Server 2014 database that contains a table named OrderDetail.
You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline.
Which Transact-SQL batch should you use?
- A. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD
- B. ALTER INDEX ALL ON OrderDetail REBUILD
- C. CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
- D. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
Correct Answer: D 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
Viewing page 1 out of 54 pages.
Viewing questions 1-5 out of 268 questions.
Ferdinand 
Maxine 
Hiram 
Jeremy 
Jean 
Asa 
Merry 
Shirley 
Abbott 
Jonathan 
Lewis 
Francis 
Rosemary 
Cora 
Geraldine 
Jonathan 
Atwood 
Augustine 
Regan 
