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 141–150 of 150

Q141

What happens when Azure SQL Automatic Tuning is enabled?

  • A Query performance is always guaranteed.
  • B Automatic index creation and tuning occurs.
  • C It disables manual tuning options.
  • D It requires user intervention at all times.
Explanation Automatic tuning optimizes query performance with automatic index management; other options suggest incorrect behaviors.
Q142

A company needs to ensure high availability for their Azure SQL Database. Which feature should they enable?

  • A Geo-replication
  • B Auto-scaling
  • C Read replicas
  • D Database backups
Explanation Geo-replication provides high availability by syncing data across regions, while the others do not ensure availability during downtime.
Q143

You are configuring Azure SQL Database auditing. What happens when you set the storage type to 'Log Analytics'?

  • A Logs are stored in Blob Storage
  • B Audits are directly sent to Log Analytics
  • C No audits will be recorded
  • D Alerts are created for anomalies
Explanation When set to 'Log Analytics', audits are directly sent to Log Analytics for analysis; the other options are incorrect regarding storage locations or outcomes.
Q144

Which Azure service can be used to automatically scale an Azure SQL Database based on usage?

  • A Azure Automation
  • B Azure Logic Apps
  • C Elastic Pool
  • D Data Factory
Explanation An Elastic Pool allows for automatic scaling of resources among databases based on demand, while the others do not provide this functionality.
Q145

Which service allows you to run queries against data in Azure without needing to load it?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Data Lake Storage
  • D Azure Functions
Explanation Azure Synapse Analytics can query data directly using serverless SQL pools, while others are storage solutions.
Q146

A company needs to ensure their Azure SQL Database is highly available. What Azure feature should they implement?

  • A Active Geo-Replication
  • B Read Replicas
  • C Partitioning
  • D SQL Database Auditing
Explanation Active Geo-Replication provides high availability with failover capabilities; others do not ensure availability.
Q147

You are configuring auditing for your Azure SQL Database. What format do audit logs support for external storage?

  • A JSON
  • B XML
  • C CSV
  • D PDF
Explanation Audit logs can be stored in CSV format for better analytical compatibility; others are not supported formats.
Q148

Which service is used to create a logical SQL database in Azure?

  • A Azure SQL Database
  • B Blob Storage
  • C Azure Functions
  • D Azure Data Lake
Explanation Azure SQL Database is specifically designed for creating relational databases, while others serve different purposes.
Q149

A company needs to ensure continuous availability of their Azure SQL Database during regional outages. What should they configure?

  • A Geo-Replication
  • B Elastic Pools
  • C Backup Retention
  • D Point-in-Time Restore
Explanation Geo-Replication provides copy databases in different regions to enhance availability, while the others address different needs.
Q150

You are configuring auditing for an Azure SQL Database. What happens if the auditing settings are not applied correctly?

  • A Audit logs are stored correctly
  • B Auditing features are disabled
  • C Data remains unmonitored
  • D Only security events are logged
Explanation If auditing is not configured, there will be no monitoring of database activities, while other options cannot occur if settings are not applied.