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 121–130 of 150

Q121

Which service provides highly available managed relational databases?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Cognitive Services
Explanation Azure SQL Database offers managed relational databases, while the others serve different purposes.
Q122

You are configuring a backup strategy for an Azure SQL Database. What is the maximum retention period for Point-in-Time Restore?

  • A 1 day
  • B 14 days
  • C 35 days
  • D 1 year
Explanation Point-in-Time Restore can be configured for up to 35 days; shorter durations are not valid.
Q123

What happens when you try to connect to an Azure SQL Database with an incorrect IP address in firewall settings?

  • A Connection succeeds as local IPs are trusted
  • B Connection is denied
  • C Database resets the connection
  • D Application crashes unexpectedly
Explanation A connection is denied if the IP isn't allowed through the firewall, while others do not accurately describe the scenario.
Q124

Which SQL database service provides multi-region availability?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Table Storage
Explanation Azure SQL Database supports multi-region availability for disaster recovery, while others do not specifically offer this for databases.
Q125

A company needs to ensure their SQL databases are automatically backed up. What should they configure?

  • A Long-term retention
  • B Geo-replication
  • C Managed Instance Security
  • D Failover Groups
Explanation Long-term retention policies ensure automatic backups; other options pertain to high availability or security, not backups.
Q126

You are configuring auditing for an Azure SQL Database. What happens if you disable auditing?

  • A Auditing continues silently
  • B All previous audits are deleted
  • C No more audit records are created
  • D Existing audit logs are retained
Explanation Disabling auditing stops any new records from being created, but previous logs remain intact, unlike option B.
Q127

A database has poor performance due to slow queries. What should you check first?

  • A Index fragmentation
  • B Server hardware
  • C Network latency
  • D Virtual machine size
Explanation Index fragmentation can significantly slow down query performance, making it a primary check.
Q128

You are configuring a SQL database for high availability. Which feature should you implement?

  • A Geo-replication
  • B Elastic pools
  • C Active Geo-restore
  • D Failover groups
Explanation Failover groups provide automatic database failover for applications needing high availability.
Q129

What happens when you enable auditing on a SQL database?

  • A Performance is dramatically decreased
  • B Audit logs are generated
  • C All SQL queries are blocked
  • D Automatic backups are performed
Explanation Enabling auditing generates audit logs to track database activity for compliance.
Q130

Which Azure service is best for real-time analytics?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Virtual Machines
  • D Azure CDN
Explanation Azure Stream Analytics processes real-time data streams; others do not focus on real-time analytics.