Correct Answer: Yes, it provides automated backups (full, differential, and log) that are stored for up to 35 days by default
The service handles backups automatically with no administrative intervention required....
Correct Answer
Yes, it provides automated backups (full, differential, and log) that are stored for up to 35 days by default
Why This Answer Is Correct
The service handles backups automatically with no administrative intervention required.
This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Administrator Associate (AZ-104). Understanding Azure SQL Database is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Which Azure SQL deployment option provides the highest degree of compatibility with an on-premises SQL Server and includes access to the underlying OS?
What are the two primary purchasing models for Azure SQL Database?
An administrator wants to manage a group of several Azure SQL Databases together to share a single set of resources (like CPU and RAM). Which feature should they use?
Which Azure SQL feature automatically scales compute based on workload demand and bills for compute used per second?