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 61–70 of 150

Q61

Which service is primarily used to manage Azure SQL databases?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Table Storage
  • D Azure Data Lake
Explanation Azure SQL Database is specifically designed for SQL databases, unlike the others that serve different purposes.
Q62

A company needs to ensure high availability for its SQL Database. Which feature should they configure?

  • A Geo-replication
  • B SQL Elastic Pools
  • C Read Scale-Out
  • D Automated Backup
Explanation Geo-replication allows databases to remain highly available across regions, while others focus on performance or backup strategies.
Q63

You are configuring a long-running transaction in Azure SQL. What happens if there's a crash?

  • A All data is lost
  • B Transaction is automatically rolled back
  • C Data is saved at crash point
  • D Transaction remains to be completed
Explanation In Azure SQL, long-running transactions are rolled back on crash to ensure data consistency, versus other incorrect options that imply data loss or saving mid-transaction.
Q64

Which Azure service is designed for real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Data Factory
  • D Azure Synapse Analytics
Explanation Azure Stream Analytics handles real-time streaming data efficiently, while the others serve different purposes.
Q65

A company needs to securely store sensitive data in Azure SQL Database. Which feature should they enable?

  • A Transparent Data Encryption (TDE)
  • B Always On Availability Groups
  • C Geo-Replication
  • D Read Scale-Out
Explanation Transparent Data Encryption (TDE) is used for data protection through encryption; the other options serve different functionalities.
Q66

What happens when you set a database to autoscale in Azure SQL Database?

  • A Charges increase based on usage
  • B Database size is permanently fixed
  • C Performance remains static
  • D Data is automatically deleted
Explanation Autoscaling adjusts resources and costs based on performance needs, whereas the other options do not align with autoscale functionality.
Q67

Which Azure service is used for building data pipelines?

  • A Azure Data Factory
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Virtual Machines
Explanation Azure Data Factory is specifically designed for data pipelines; the others serve different purposes.
Q68

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

  • A Geo-Replication
  • B Backup and Restore
  • C Read Scale Out
  • D Auto-Scaling
Explanation Geo-Replication ensures high availability; other options are not primarily for HA.
Q69

What happens when you set a SQL Database to serverless tier?

  • A Decreased performance during usage.
  • B Billing only during active usage.
  • C Automatic scaling of compute resources.
  • D No data backups are taken.
Explanation Billing occurs only when the database is active, while the others describe incorrect outcomes.
Q70

Which service provides high availability for Azure SQL databases?

  • A Azure SQL Database Geo-replication
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Virtual Machines
Explanation Geo-replication ensures high availability while other options do not provide direct high availability for SQL databases.