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 111–120 of 150

Q111

You are configuring permission for a user in Azure SQL Database. What would happen if you assign them both 'db_datawriter' and 'db_owner' roles?

  • A User can only write data
  • B User gains elevated permissions
  • C User is denied access
  • D User role automatically revoked
Explanation The user inherits elevated permissions from both roles, enhancing their access capabilities.
Q112

Which Azure service provides global scalability and low-latency access to data?

  • A Azure Cosmos DB
  • B Azure Blob Storage
  • C Azure Table Storage
  • D Azure File Storage
Explanation Azure Cosmos DB offers global distribution and low-latency access, whereas the others focus on specific storage types.
Q113

A company needs to deploy a scalable database solution for a web application. Which architecture is recommended?

  • A Single SQL database on VM
  • B Azure SQL Database with Auto-scaling
  • C Azure SQL Managed Instance
  • D On-premises SQL Server
Explanation Azure SQL Database with Auto-scaling provides scalability, while other options are less dynamic or not cloud services.
Q114

You are configuring a high availability solution for an Azure SQL Database. What happens if the primary database becomes unavailable?

  • A Database gets restored automatically
  • B Failover to secondary database occurs
  • C Service goes offline until manual fix
  • D No impact on connectivity
Explanation In a high availability configuration, failover to a secondary database ensures continuity, whereas the other options degrade service availability.
Q115

Which SQL feature allows for automatic scaling of the database based on demand?

  • A Auto Growth
  • B Elastic Pools
  • C Geo-Replication
  • D Indexing
Explanation Elastic Pools enable scaling based on demand, while the others do not focus on scaling dynamically.
Q116

A company needs to ensure that SQL Server functions as required upon certain database size limits. Which feature should they implement?

  • A Performance Metrics
  • B Alerts and Notifications
  • C Database Auditing
  • D Backup Automation
Explanation Alerts and Notifications can proactively inform of size limits, while others do not address size constraints.
Q117

What happens when a database's maximum size limit is reached in Azure SQL Database?

  • A Database crashes immediately
  • B No further data can be stored
  • C Service continues without interruption
  • D Automatic deletion of old records
Explanation When the maximum size limit is reached, no additional data can be stored; the service does not crash or delete data automatically.
Q118

Which feature allows automatic scaling of SQL databases in Azure?

  • A Elastic Pool
  • B Active Geo-Replication
  • C Azure AutoScale
  • D Deferred Backup
Explanation Elastic Pools manage multiple databases with shared resources; the others do not offer auto-scaling capabilities.
Q119

A company needs to maintain a high availability of SQL servers across two Azure regions. Which feature should they use?

  • A Zonal Redundancy
  • B Azure Traffic Manager
  • C Active Geo-Replication
  • D Data Encryption
Explanation Active Geo-Replication allows SQL databases to have failover in different regions, while others do not ensure availability directly.
Q120

What happens when you configure a read replica in Azure SQL Database?

  • A Increases transaction latency
  • B Disables database backups
  • C Reduces primary database load
  • D Enables data loss
Explanation Read replicas help offload read operations, thus reducing the load; the other options incorrectly describe the effects of configuring a read replica.