70-765 Azure Practice Questions
The free 70-765: Provisioning SQL Databases questions that deal with azure, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #1
You are tasked with provisioning a SQL database on Azure. Which Azure service will you choose?
Correct answer: C
Explanation
Azure SQL Database is a fully managed database service that allows for easy provisioning and scaling in Azure.
Question #3
What is the primary purpose of Elastic Pools in Azure SQL Database?
Correct answer: D
Explanation
Elastic Pools allow for the management of resource allocation for multiple databases, optimizing performance and cost in Azure SQL Database deployments.
Question #5
To secure Azure SQL Database, which feature provides the ability to enforce security policies?
Correct answer: C
Explanation
Advanced Data Security provides a unified package of security features including vulnerability assessment and security policy enforcement to enhance database security in Azure.
Question #6
You're tasked with setting up automatic backups for Azure SQL Database. Which service do you utilize?
Correct answer: B
Explanation
Azure Backup provides a reliable and simple way to create automatic backups for Azure SQL Database, ensuring data availability and compliance.
Question #8
For the best performance of a read-heavy Azure SQL Database, what tier should you choose?
Correct answer: C
Explanation
The Premium tier is optimized for high-performance workloads and is ideal for read-heavy databases as it offers superior IOPS and throughput.
Question #9
What type of backup is automatically created by Azure SQL Database every week?
Correct answer: C
Explanation
Azure SQL Database automatically performs a full backup weekly to ensure point-in-time restore capabilities for your database.
Question #10
You need to manage SQL Database configurations across multiple Azure subscriptions. What feature would you use?
Correct answer: C
Explanation
Azure Policy can enforce rules and effects over the resources in multiple subscriptions, ensuring compliance and governance across your SQL databases.
Continue with 70-765: Provisioning SQL Databases
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 70-765: Provisioning SQL Databases, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.