Microsoft Azure

Administering Microsoft Azure SQL Solutions

DP-300

Become proficient in Azure SQL with the DP-300 exam focused on administration.

150 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 101–110 of 150

Q101

A company needs to limit database access to only specific users and maintain an audit trail. What is the best approach?

  • A Use Azure Firewall rules
  • B Implement Azure SQL Database Auditing
  • C Restrict access with IP whitelisting
  • D Use Managed Identity for all users
Explanation Implementing Azure SQL Database Auditing tracks access and actions, while the others do not provide comprehensive auditing features.
Q102

You are configuring geo-replication for an Azure SQL Database. What happens if the primary region goes down?

  • A Data loss occurs
  • B The database automatically fails over
  • C The replication stops temporarily
  • D Only read operations are allowed
Explanation Automatic failover to the secondary database ensures high availability, while the other options either do not describe the process accurately or misrepresent the behavior.
Q103

Which service provides automated backups for SQL databases?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Synapse Analytics
  • D Azure Functions
Explanation Azure SQL Database includes automated backup features; the others do not offer SQL database backup services.
Q104

A company needs to store large amounts of structured data efficiently and perform complex queries. Which Azure service is best suited for this task?

  • A Azure Table Storage
  • B Azure Cosmos DB
  • C Azure SQL Database
  • D Azure Blob Storage
Explanation Azure SQL Database is optimized for structured data queries; others do not support complex querying of structured data effectively.
Q105

What happens when you delete a database in Azure SQL Database?

  • A All data in the database is lost.
  • B The database is moved to archive.
  • C It is stored as a backup.
  • D The deletion can be undone later.
Explanation Deletion of a database results in the permanent loss of data; the other options imply recoverability which does not occur.
Q106

Which service is best for managing relational databases on Azure?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Table Storage
  • D Azure Cosmos DB
Explanation Azure SQL Database specifically manages relational databases, while others focus on different data types or storage paradigms.
Q107

A company needs to ensure high availability of their Azure SQL Database. What should they implement?

  • A Standard edition
  • B Geo-replication
  • C Azure Backup
  • D Data encryption
Explanation Geo-replication provides high availability and disaster recovery, whereas the other options address backup or security but not availability.
Q108

You are configuring Azure SQL Database for automatic data backup. What happens if a backup fails?

  • A Backup operation is retried automatically
  • B Database becomes unavailable
  • C No backups will be attempted again
  • D Only the latest backup is kept
Explanation Azure automatically retries failed backup operations, ensuring that data remains protected; the other options misrepresent backup failure behavior.
Q109

Which service is best for automated SQL backups?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure SQL Database provides built-in automated backup options, while others are not designed for SQL backup.
Q110

A company needs to improve SQL query performance by retrieving frequently accessed data. What should they implement?

  • A Table partitioning
  • B Dynamic Data Masking
  • C Data Compression
  • D Indexed views
Explanation Indexed views optimize performance for frequently accessed data, while the others serve different purposes.