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 71–80 of 150

Q71

A company needs to restrict external access to their Azure SQL Database. Which feature should they implement?

  • A Firewall rules
  • B Connection pooling
  • C Table partitioning
  • D Database snapshots
Explanation Firewall rules are used to limit access, while the other options do not restrict access.
Q72

You are configuring a managed instance in Azure SQL. What will happen if you set a high resource class for your application?

  • A Increased performance for all queries
  • B Higher costs with no performance gain
  • C Limited to specific SQL Server versions
  • D Guaranteed maximum CPU usage only
Explanation Setting a high resource class prioritizes resources, while other options either misrepresent resource management or imply restrictions.
Q73

Which service should you use for data analytics in Azure SQL Database?

  • A Azure Synapse Analytics
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure Virtual Machines
Explanation Azure Synapse Analytics is optimized for data analytics, unlike the other options.
Q74

A company needs to regularly backup their Azure SQL Database with point-in-time restore capabilities. What should they use?

  • A Long-term Retention
  • B Geo-Replication
  • C Automatic Backup
  • D Manual Snapshot
Explanation Automatic Backup provides point-in-time restores; others serve different purposes.
Q75

What happens when you remove a column that has a non-null constraint from an existing Azure SQL Database table?

  • A Table deletion occurs automatically
  • B Constraint violation error is returned
  • C Data is preserved in a different table
  • D Other columns will be deleted as well
Explanation Removing a non-null constrained column raises a constraint violation error.
Q76

Which service allows SQL databases to scale on-demand?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure App Service
Explanation Azure SQL Database provides scaling capabilities for databases, while others serve different purposes.
Q77

A company needs to implement high availability for its Azure SQL Database. What feature should they enable?

  • A Read Scale Group
  • B Geo-Replication
  • C Elastic Pools
  • D Availability Zones
Explanation Geo-Replication maintains high availability across regions, while others don’t ensure database failover.
Q78

You are configuring a SQL Server on Azure VM. What happens when you disable the firewall?

  • A Blocks all access
  • B Allows all IP addresses
  • C Only local access permitted
  • D Raises security risks
Explanation Disabling the firewall allows any IP to connect, posing potential security risks.
Q79

Which service should you use to automate database backups?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Key Vault
  • D Azure Virtual Machine
Explanation Azure SQL Database automatically manages backups, while other options do not.
Q80

A company needs to encrypt its SQL Database. Which feature should they implement?

  • A Always Encrypted
  • B Connection Encryption
  • C Transparent Data Encryption
  • D Application Layer Encryption
Explanation Transparent Data Encryption protects data at rest while the other options handle encryption differently.