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 91–100 of 150

Q91

What happens when you enable Transparent Data Encryption (TDE) on an Azure SQL Database?

  • A Data is encrypted at rest.
  • B Backups become unencrypted.
  • C Performance decreases significantly.
  • D Data is only encrypted in transit.
Explanation TDE encrypts data at rest to enhance security, while backups remain encrypted as well.
Q92

A company needs its Azure SQL Database to automatically scale resources based on workload. Which service should they use?

  • A SQL Database Hyperscale Tier
  • B Elastic Pools
  • C SQL Server on VMs
  • D Business Critical Tier
Explanation Elastic Pools allow automatic scaling and resource sharing among databases, making them ideal for varying workloads.
Q93

You are configuring a SQL Database to use Managed Identity. Which of the following actions can you perform?

  • A Access other Azure resources securely.
  • B Connect to on-premises SQL Server.
  • C Automatically backup databases to Blob.
  • D Use it as a replacement for encryption.
Explanation Managed Identity enables secure access to other Azure resources without credentials; the others are incorrect uses.
Q94

Which service is used for data re-import in Azure SQL database?

  • A Azure Data Factory
  • B Azure Logic Apps
  • C Azure Data Lake
  • D Azure Blob Storage
Explanation Azure Data Factory is designed for data integration and transformation tasks.
Q95

A company needs to ensure that its SQL database regions are failover ready. What should they implement?

  • A Geo-replication
  • B Elastic Pools
  • C Always On Availability Groups
  • D Backups to Blob Storage
Explanation Geo-replication provides failover capabilities to keep the database available across different regions.
Q96

You are configuring a SQL Server Managed Instance. What happens when you set the service tier to 'General Purpose'?

  • A Increased IOPS per storage unit
  • B Higher compute resources charges
  • C Limited to one region only
  • D Optimized for transactional workloads
Explanation General Purpose is suitable for workloads with virtualized storage optimized for transactions.
Q97

Which service can you use to manage SQL database backups in Azure?

  • A Azure Backup
  • B Azure Site Recovery
  • C Azure Blob Storage
  • D SQL Server Management Studio
Explanation Azure Backup is specifically designed for managing backups, while the others serve different purposes.
Q98

A company needs to scale out a resource-intensive application hosted on Azure SQL Database. What option should they consider?

  • A Use Read Scale-Out feature
  • B Increase the max DTUs
  • C Use Azure Functions
  • D Switch to SQL Managed Instance
Explanation Read Scale-Out allows distributing read-only traffic, which is essential for scaling out without affecting performance.
Q99

What happens when you set up Geo-replication for your Azure SQL Database?

  • A Databases sync bi-directionally
  • B Databases create multiple copies
  • C Databases become read-only
  • D Databases replicate to a different region
Explanation Geo-replication allows databases to replicate to other Azure regions for disaster recovery purposes.
Q100

Which service allows for automated backup and restore of Azure SQL databases?

  • A Azure SQL Database
  • B SQL Server on VMs
  • C Azure Blob Storage
  • D Azure Synapse Analytics
Explanation Azure SQL Database provides built-in automated backups, while the others are not specifically designed for automated database backup.