All questions

Microsoft Certified: Azure Database Administrator Associate (DP-300) Practice Test

Browse all practice questions for the Microsoft Certified: Azure Database Administrator Associate (DP-300) Practice Test. Search by topic, open any question and review its full explanation, then test yourself in the practice quiz.

Start practice test Flash cards

Choosing Availability Zones for Effective Workload Distribution in AzureWhich option should you choose to spread workloads across data centers in a region?Choosing the Most Cost-effective Azure Database for Limited Daily UseYou're building a database for testing purposes that will be used less than 8 hours a day. It's expected to be 20 GB in size. What is your most cost-effective option?Choosing the Right Approach for Migrating Databases with Distributed TransactionsYou need to migrate a set of databases that use distributed transactions from on-premises SQL Server. Which option should you choose?Choosing the Right Cloud Database for Massive GrowthYou're building a new cloud database that you expect to grow to 50 TB. Which is the best option for your database?Choosing the Right Index for Your Data Warehouse Fact TableWhat type of index is best suited for a data warehouse fact table?Choosing the Right Tool to Monitor Azure SQL Database PerformanceWhich tool can be used to monitor Azure SQL Database performance?Configuring Access to Encrypted Data in SQL ServerWhat option must be configured to allow users to access encrypted data in SQL Server?Considerations for Minimizing Downtime in Database MigrationWhat should you consider if you have little tolerance for downtime during migration?Discover How Automatic Tuning Enhances Azure SQL Database PerformanceWhich feature in Azure SQL Database is responsible for automatic performance tuning?Discover How Azure Purview Enhances Data Governance and ClassificationWhich service provides data scanning and classification as a managed service in Azure?Discover How Azure SQL Database Enhances Performance ManagementWhat capability does Azure SQL Database offer concerning performance management?Discover how Azure SQL Database Hyperscale handles dynamic workloads with easeWhat does the Azure SQL Database Hyperscale service offer?Discover how Query Performance Insight enhances Azure database monitoringWhich monitoring tool in Azure can be utilized to analyze database queries?Discover the Benefits of Azure Cosmos DB for Managed NoSQL SolutionsWhich Azure service provides a managed NoSQL database option?Discover the Benefits of Azure SQL Database over On-Premises SQL ServerWhat is one advantage of using Azure SQL Database over an on-premises SQL Server?Discover the Benefits of Elastic Database Tools in AzureWhat role does elastic database tools play in Azure?Discover the Best Cost-Effective Option for Your Azure SQL Server VMTo reduce the cost of an Azure SQL Server VM you intend to run full time for three years, which option should you choose?Discover the Financial Benefits of Azure SQL DatabaseWhen utilizing Azure SQL Database, what is a primary benefit of its cloud service model?Discover the Importance of Failover Groups for Multi-Region Database ManagementWhat capability does the Failover Group feature provide in multi-region scenarios?Discover the Importance of Page Life Expectancy in SQL Server PerformanceWhich Performance Monitor counter reflects how long SQL Server expects to retain data in memory?Discover the Key Advantages of Azure Cosmos DBWhat is the primary advantage of using Azure Cosmos DB?Discover the Key Benefits of Using SQL Server Management Studio with Azure SQL DatabaseWhat is the purpose of using SQL Server Management Studio (SSMS) with Azure SQL Database?Discover the Key Insights Dynamic Management Views Provide for SQL ServerWhat is the main function of Dynamic Management Views (DMVs)?Discover the Optimal Azure Storage for Maximum ThroughputWhich Azure storage is recommended for production data files that require maximum throughput?Discover the Power of Azure SQL Database Managed InstancesWhat is the purpose of an Azure SQL Database managed instance?Discover the Power of Geo-Replication in Azure SQL DatabaseWhat is the benefit of using geo-replication in Azure SQL Database?Discover the Simplicity of Migrating to Azure SQL DatabaseWhat is one advantage of migrating to Azure SQL Database?Discover where logins are stored in SQL ServerWhere are logins stored in SQL Server?Discover Which DMV Captures the Last Execution Plan in SQL Server 2019Which DMV can be queried to capture the last actual execution plan for a specific query in SQL Server 2019?Discovering the Best Storage Option for Lowest Latency in AzureWhat type of storage offers the lowest latency in Azure?Discovering the Power of Snapshot Isolation in DatabasesWhat does the snapshot isolation level allow in a database?Explore How to Control Resource Consumption in Azure SQL DatabaseHow can you control resource consumption of a SQL Database in Azure?Explore the Advantages of the Hyperscale Tier in Azure SQL DatabaseWhat is one advantage of the Hyperscale tier in Azure SQL Database?Explore the Serializable Isolation Level in Database TransactionsWhich isolation level prevents users from reading data when another user is writing to it?Exploring Always Encrypted: A Secure Way to Protect Your SQL Server DataWhat encryption technique involves storing only encrypted data in SQL Server?Exploring Automatic Index Tuning in Azure SQL DatabaseWhich element of Azure SQL Database supports adaptive query processing?Exploring Effective Resource Governance in Azure SQL DatabaseHow can resource governance be effectively applied to Azure SQL Database?Exploring Effective Ways to Secure Sensitive Information in Azure SQL DatabasesHow can sensitive information be secured in Azure SQL Databases?Exploring Index Management Enhancements through SQL Database Automatic TuningWhat does the automatic tuning feature in SQL Database enhance?Exploring SQL Insights Through Azure Log Analytics for Database AdministratorsWhich Intelligent Insights options provide SQL Insights?Exploring the Benefits of Hybrid Solutions in Cloud ImplementationsWhich advantage does a hybrid solution offer compared to fully cloud-based implementations?Exploring the Maximum Size of an Azure SQL Database and Its TiersWhat is the maximum size of an individual Azure SQL Database?Finding the Right DMV for Index Utilization in SQL ServerWhich DMV should you use to find index utilization?Finding the Right Tool for Managing SQL Server Database Sizes in AzureWhat tool should you use to see the sizes of your SQL Server databases running in an Azure virtual machine?How Azure Monitor Enhances the Database Migration ExperienceWhich service assists in monitoring the migration process?How Azure SQL Database Efficiently Handles Traffic SpikesWhich feature allows Azure SQL Database to handle traffic spikes efficiently?How SQL Server's Always On Feature Minimizes Downtime During MigrationWhat is the primary benefit of using SQL Server's Always On availability group feature during migration?How to Create a SQL Database Server Using Azure CLIWhich Azure CLI command is used to create a SQL Database server?How to Easily Change Auto-Pause Settings in Your Serverless SQL DatabaseWhat option should you select to change the auto-pause of a serverless SQL Database?How to Initiate a Runbook in Azure AutomationWhich command is used to start a runbook in Azure Automation?Improve Your SQL Server Management with Azure's Virtual Machine Resource FeaturesWhat type of monitoring does the SQL virtual machine resource provider enhance for SQL Server?Learn about Transparent Data Encryption (TDE) in Azure SQL DatabaseWhich service allows for transparent data encryption in Azure SQL Database?Learn how Azure Network Security Group secures your resourcesWhich option in Azure helps you manage network security across multiple Azure resources?Learn how to enforce data integrity in Azure SQL DatabaseHow can you enforce data integrity in Azure SQL Database?Master the Azure CLI Command to Update Your SQL DatabaseWhich Azure CLI command can you use to update an existing SQL Database?Mastering Performance Tuning for Azure SQL DatabaseWhat are the key activities involved in performance tuning of Azure SQL Database?Selecting the Best SQL Server PaaS for Restoring Your Database to AzureWhich SQL Server PaaS offering should you choose to restore an on-premises database backup to Azure?Understand how Azure Purview automates data discovery and classificationWhich feature can be used to automate data discovery through the provision of data scanning and classification as a service?Understand How the Azure CLI Streamlines Azure SQL Database ManagementWhat is the primary function of the Azure CLI in managing Azure SQL Databases?Understand How to Manage Performance in Azure SQL DatabaseWhich method is not typically used for managing performance in Azure SQL Database?Understand the Role of Azure SQL Database in Relational Database ManagementAzure SQL Database primarily caters to which type of database methodology?Understanding Auto Update Statistics Asynchronously for Optimal Query PerformanceWhich statistics option allows statistics to be updated while a query executes against the object the statistics are based on?Understanding Automatic Index Management in SQL DatabaseWhich platform supports automatic index management?Understanding Automatic Scaling with Azure's Elastic PoolsWhat feature in Azure allows for automatic scaling of database resources based on demand?Understanding Automatic Tuning for Better Database ManagementWhich database feature provides recommendations for indexing based on query performance?Understanding Azure Active Directory Integration for Azure SQL DatabaseWhat does Azure Active Directory integration provide in Azure SQL Database?Understanding Azure Database Firewall Rules and Their ImportanceWhat are Azure database Firewall rules used for?Understanding Azure SQL Analytics for Database Performance MonitoringWhich Azure service allows you to analyze and monitor database performance?Understanding Azure SQL Database Backup Types and Their BenefitsWhich type of backup in Azure SQL Database captures all changes since the last full backup?Understanding Azure SQL Database: The Power of PaaS in Cloud SolutionsWhich service model does Azure SQL Database use?Understanding Azure SQL Database's Private IP Address FeatureWhat feature offers a private IP address for an Azure SQL Database?Understanding Azure Storage Solutions for SQL ServerWhich type of storage should be used in conjunction with Azure VMs for SQL Server data files?Understanding Backup Storage Redundancy in AzureWhat does the Backup Storage Redundancy option define?Understanding Block Level Replication with Azure Site RecoveryWhich service performs block level replication of your Azure virtual machine?Understanding Control Permission for Database Management in AzureWhat permission allows a user to perform any action against a database object?Understanding Data Classification Storage in SQL Server 2019Where is the data from data classification stored in SQL Server 2019?Understanding Database Firewall Rules in Azure SQL DatabaseWhich technique can be used to create database firewall rules in Azure SQL Database?Understanding Database Sharding in Azure SQL Database ArchitecturesWhat does "database sharding" mean in Azure SQL Database architectures?Understanding Deadlocks in Database ManagementWhat does “deadlock” mean in database management?Understanding Failover Events in Azure Database ManagementWhat must be manually addressed during a failover event with database-level protection?Understanding Geo-Replication in Azure SQL DatabaseWhat does the term "geo-replication" refer to in Azure SQL Database?Understanding How Always Encrypted Safeguards Your SQL DataWhich feature prevents members of the sysadmin role from viewing data values in a table?Understanding How Azure SQL Database Elastic Pool Automatically Adapts to WorkloadsWhich feature allows Azure SQL Database to automatically adjust for workload changes?Understanding how Azure SQL Database ensures high availabilityHow does Azure SQL Database handle high availability?Understanding How to Automate Backups in Azure SQL DatabaseHow can database administrators automate backups in Azure SQL Database?Understanding How to Define an Azure Policy ScopeWhich of the following is needed to define an Azure Policy scope?Understanding How to Implement Versioning in Azure SQL DatabaseWhat is a method for implementing versioning in applications connected to Azure SQL Database?Understanding Hybrid Solutions in Cloud ArchitectureWhat defines a hybrid solution in cloud architecture?Understanding Indexing in Database ManagementWhat does the term "index" refer to in the context of databases?Understanding Microsoft’s Guarantee on SQL Server UpgradesWhat does Microsoft guarantee if you upgrade versions of SQL Server while maintaining the same compatibility level?Understanding Ownership Chaining in SQL Server SecurityWhich feature allows a user to execute a stored procedure without direct access to the tables it references?Understanding Parameters in Azure Resource Manager TemplatesWhich option must be included in an Azure Resource Manager template to specify the region for a resource group deployment?Understanding Recovery Point Objective and Its ImportanceWhich of the following describes what RPO represents?Understanding Recovery Point Objective in Database ManagementWhat does RPO stand for in database management?Understanding Resource Dependencies in Azure Resource Manager TemplatesWhich element in an Azure Resource Manager template is used to build resource dependencies?Understanding Resource Governor in SQL Server and Its Impact on Write IOPSWhich of the following can be limited using Resource Governor?Understanding Resource Pools in Azure SQL's Resource GovernorWhich component of resource governor allows you to configure limits on system resources?Understanding Resource Pools in SQL Server's Resource GovernorWhich component of Resource Governor allows you to configure limits on system resources?Understanding Runbooks as Execution Units in Azure AutomationWhat is the unit of execution for your Azure Automation Account?Understanding Server-Level Wait Statistics in Azure SQLWhich DMV provides information about server-level wait statistics?Understanding Serverless Compute in Azure SQL DatabaseWhat does "serverless compute" mean in Azure SQL Database?Understanding Service Objectives in Azure SQL DatabaseWhat is a “service objective” in Azure SQL Database?Understanding SOS_SCHEDULER_YIELD and Its Impact on CPU ConsumptionWhich of the following wait types would indicate excessive CPU consumption?Understanding SQL Server Management on Azure VMsWhat type of management is required for SQL Server on Azure VM?Understanding Storage Pool Configuration in Azure SQL ServerWhich is an option from the SQL Server Resource Provider for Azure VMs?Understanding the Advantages of Using a Snowflake SchemaWhat is the primary advantage of using a snowflake schema?Understanding the AFTER UPDATE Block Predicate in Azure SQLWhich block predicate prevents users from updating rows to values that violate its row-level security predicate?Understanding the Automatic Scalability of Azure SQL DatabaseWhat does Azure SQL Database allow in terms of scalability?Understanding the Azure SQL Database Maintenance Window FunctionalityHow does the Azure SQL Database maintenance window function?Understanding the Basic Service Tier in Azure SQL DatabaseWhat is an example of a service tier in Azure SQL Database?Understanding the Benefits of Auto Update Statistics Asynchronously in SQL ServerWhich of the following is a benefit of using Auto Update Statistics Asynchronously?Understanding the Benefits of Azure Integration in Hybrid SolutionsIn hybrid solutions, what is the primary advantage of integrating on-premises resources with Azure?Understanding the Benefits of Azure SQL Database Compared to On-Premises SQL ServerWhat is a primary benefit of using Azure SQL Database over traditional on-premises SQL Server?Understanding the Benefits of Using Azure Managed Disks with SQL Server DataWhich type of storage should be used in conjunction with Azure VMs for SQL Server data files?Understanding the Best Azure Storage for Unstructured DataWhich type of Azure storage is best suited for large amounts of unstructured data?Understanding the Best Method for Inserting Data into Columnstore IndexesWhich method is recommended for inserting data into a columnstore index?Understanding the Configuration for SQL Server Agent Email FunctionsWhat must be configured before the SQL Server Agent can send emails?Understanding the Core Purpose of Azure SQL DatabaseWhat is the primary purpose of Azure SQL Database?Understanding the Database Owner's Role in Auditing Azure SQL ProceduresWhich user role is involved in auditing stored procedures in Azure SQL Database?Understanding the Database-Level Protection Features in SQL Server FailoverWhat is a key feature of database-level protection in SQL Server after failover?Understanding the Estimated Execution Plan in SQL ServerWhat type of execution plan is stored in the plan cache?Understanding the Format of Azure Resource Manager TemplatesIn what format are Azure Resource Manager templates written?Understanding the Frequency of Differential Backups in Azure SQL Managed InstanceHow often do differential backups occur with Azure SQL managed instance?Understanding the Importance of a Data Backup Plan in Database MigrationWhat element is crucial to establish before a successful database migration?Understanding the Importance of Always On Availability Groups in AzureWhat is the significance of Always On Availability Groups in Azure?Understanding the Importance of Azure Key Vault in Securing Azure SQL DatabaseDescribe the role of Azure Key Vault in Azure SQL Database.Understanding the Importance of Azure SQL Auditing CapabilitiesWhat are Azure SQL Auditing capabilities used for?Understanding the Importance of Azure SQL Data Sync for Database ManagementWhat is the function of Azure SQL Data Sync?Understanding the Importance of Compatibility Level in Azure SQL DatabasesIn Azure SQL Databases, what is the importance of “compatibility level”?Understanding the Importance of Credentials in Azure's Self-Hosted Integration RuntimeWhat is the purpose of entering credentials in the self-hosted integration runtime?Understanding the Importance of Database-Level Protection During FailoversWhat does database-level protection ensure in the event of a failover?Understanding the Importance of Monitoring SQL Database MetricsHow does monitoring SQL Database metrics benefit administrators?Understanding the Importance of Schema in DatabasesWhat does “schema” refer to in a database context?Understanding the Importance of Service Tiers for Azure SQL Database ScalingWhich entity is critical for scaling databases in Azure SQL Database?Understanding the Importance of sys.dm_db_tuning_recommendations in Azure SQLWhich DMV shows the status of a plan updated by automatic tuning?Understanding the Importance of Target Groups in SQL Elastic JobsWhat is essential when defining a SQL Elastic Job?Understanding the Key Benefits of Azure SQL Database’s High AvailabilityWhat is the primary benefit of Azure SQL Database’s built-in high availability?Understanding the Key Differences Between Azure SQL Database and SQL Server on Azure VMWhat distinguishes Azure SQL Database from SQL Server on Azure VM?Understanding the Key Features of Azure SQL Database Compared to SQL Server on Azure VMWhat primary feature might a user miss when using Azure SQL Database compared to SQL Server on Azure VM?Understanding the Key Role of the Log Replay Service in Azure SQL Managed InstanceWhat is the primary use case for the Log Replay Service for Azure SQL Managed Instance?Understanding the Limitations of the Azure Data Migration ServiceWhat is a drawback of using the Azure Data Migration Service?Understanding the Maintenance Cleanup Task in SQL ServerWhich built-in option is used to remove old files related to maintenance plans?Understanding the Minimum Rows Required for Bulk Inserts into Columnstore IndexesWhat is the minimum number of rows required to bulk insert into a columnstore index?Understanding the Power of Automatic Tuning in SQL ServerWhich SQL Server feature supports performance tuning recommendations?Understanding the Power of In-Memory OLTP in Azure SQL DatabaseWhat does the term "in-memory OLTP" refer to in Azure SQL Database?Understanding the Purpose of a Clustered Index in DatabasesWhat is the purpose of a clustered index in a database?Understanding the Purpose of Database Connection Strings in ApplicationsWhat is the purpose of database connection strings in applications?Understanding the Range of Backup Retention Policy Options in Azure SQL DatabaseWhat is the range of backup retention policy options in Azure SQL Database?Understanding the Role of 'DependsOn' in Azure Resource ManagementWhich statement best describes 'DependsOn' in an Azure Resource Manager template?Understanding the Role of Access Admin in Azure Database ManagementWhich role permits users to create new users within a database?Understanding the Role of Azure Logic Apps with Azure SQL DatabaseWhat role do Azure Logic Apps play in relation to Azure SQL?Understanding the Role of Azure Policy in Governance and ComplianceWhat is the primary purpose of Azure Policy?Understanding the Role of Azure Resource Manager in Cloud DeploymentIn what context is Azure Resource Manager primarily used?Understanding the Role of Azure SQL Database Elastic PoolsWhat is the function of Azure SQL Database elastic pools?Understanding the role of Azure SQL Database Threat DetectionWhat is the purpose of the Azure SQL Database threat detection feature?Understanding the Role of BATCH_COMPLETED_GROUP in Azure SQL Database AuditingWhich server-level action group audits queries and stored procedures executed against an Azure SQL Database?Understanding the Role of event_counter in SQL Server Extended EventsWhich extended event target counts how many times each specified event occurs?Understanding the Role of Foreign Keys in Azure SQL DatabaseWhat describes the function of a foreign key in Azure SQL Database?Understanding the Role of Index Rebuilding in Azure Database ManagementWhat operation is performed to recalculate the statistics on an index?Understanding the Role of Indexes in Azure SQL DatabaseWhat is the main purpose of using indexes in Azure SQL Database?Understanding the Role of Parameters in Azure Resource Manager TemplatesWhat is the main purpose of parameters in an Azure Resource Manager template?Understanding the Role of Read Scale-out in Azure SQL DatabaseWhat is the significance of using "Read Scale-out" in Azure SQL Database?Understanding the Role of Resource Governor in SQL Database ManagementIn SQL Database, what does the Resource Governor primarily manage?Understanding the Role of Resource Limits in Azure SQL DatabaseWhat is the purpose of setting resource limits in Azure SQL Database?Understanding the Role of Resource Pools in SQL Server's Resource GovernorWhat is the role of Resource Pools in the Resource Governor?Understanding the Role of Row-Level Security in SQL Database ComplianceWhich method allows users to ensure compliance with data classification in SQL databases?Understanding the Role of RPO in Business Continuity PlanningHow is RPO related to business continuity planning?Understanding the Role of SAML in Microsoft Entra ID for AuthorizationWhich protocol is utilized by Microsoft Entra ID for authorization?Understanding the Role of Security Admin in Azure Database ManagementWhat role is usually allocated to users who need to create new database roles?Understanding the Role of Self-Hosted Integration Runtime in Data MigrationWhat role does the self-hosted integration runtime play in data migration?Understanding the Role of SQL Database Logical Servers in Azure ManagementWhat is an SQL Database Logical Server?Understanding the Role of the Azure Database Migration ServiceWhat is the Azure Database Migration Service primarily used for?Understanding the Role of the Master Key in Database EncryptionWhich security object is necessary for encrypting databases?Understanding the Role of the Master Key in Transparent Data EncryptionWhat security object is required to enable transparent data encryption?Understanding the Role of the Resource Governor in SQL Server ManagementWhat role does the resource governor play in managing SQL server resources?Understanding the Scope of Azure Policy for Effective Resource ManagementWhat scope can Azure Policy be deployed to?Understanding the Scope of SQL Elastic Jobs in AzureWhat is the name for the scope that you must define for a SQL Elastic Job?Understanding the Security Benefits of TLS 1.3 in Database ManagementWhich TLS version provides the highest level of security for encryption?Understanding the Service Level of an Azure SQL DatabaseHow do you define the service level of an Azure SQL Database?Understanding the Service Tiers of Azure SQL DatabaseWhich of the following service tiers is NOT available for Azure SQL Database?Understanding the SQL Database Auditing Feature in AzureWhich feature allows an Azure SQL Database to audit and log events?Understanding the SQL Managed Instance Link Feature in Database MigrationWhat is the purpose of using the SQL Managed Instance link feature during migration?Understanding the Types of Backups in Azure SQL DatabaseWhat are the different types of backups performed in Azure SQL Database?Understanding Threat Detection Features in Azure SQL DatabaseWhich of the following features enhances the security of Azure SQL Database?Understanding Tools for Migrating SQL Server Databases to AzureWhich tool is used to assess and migrate databases from an on-premises SQL Server to an Azure Virtual Machine?Understanding Transaction Log Retention During Database FailoverAfter a failover event, which components of SQL databases are retained under database-level protection?Understanding Transactional Replication Configuration Limitations in AzureCan transactional replication be configured from the Azure portal?Understanding Transport-Level Encryption for Azure SQL DatabaseWhat type of data encryption occurs during data transmission to Azure SQL Database?Understanding Where SQL Server Agent Jobs Reside: Insights into the msdb DatabaseIn which system database are SQL Server Agent jobs and their information stored?Understanding Why Columnstore Indexes Are Ideal for Large Aggregation WorkloadsWhich index type is recommended for queries that run large aggregation workloads?What Does DTU Mean in Azure SQL Database?In the context of Azure SQL Database, what does the acronym DTU stand for?When to Use the Log Replay Service for Database MigrationsWhen would you prefer to use the Log Replay Service?Why Azure SQL Database is Ideal for Application HostingWhat benefit does using Azure SQL Database provide for application hosting?Why Choosing the Right Tables Matters During Data MigrationWhy is selecting tables important during data migration?Why Migrating Your Database to Azure SQL Database Makes SenseWhat is a valid reason for migrating your database to Azure SQL Database?Why Organizations Opt for SQL Server on Azure Virtual MachinesWhy would an organization choose to use SQL Server on Azure VM?Why the AFTER UPDATE Block Predicate is Key for SQL Server SecurityWhat is the purpose of the AFTER UPDATE block predicate in SQL Server?Why the PaaS Model is Game-Changer for Azure SQL DatabaseWhat does the 'PaaS' model in Azure SQL Database primarily allow?Why the Snowflake Schema is Essential for Data Warehousing EfficiencyWhat type of database design should be used in a data warehouse to reduce the data volume of dimensions?Why You Need a Service Tier for Azure SQL DatabaseWhat happens to Azure SQL Database when no service tier is selected?

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy