View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 301 Which Azure SQL Database feature provides automatic failover capabilities between databases in different Azure regions? Azure SQL Auditing Auto-failover groups Query Store Elastic pools Correct Answer: 2 Explanation Auto-failover groups are designed to manage disaster recovery between Azure SQL databases in different regions. They […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 281 Which Azure SQL Database feature allows a database to automatically scale compute resources up and down based on workload activity? Serverless compute Database snapshot Azure SQL Auditing BACPAC Correct Answer: 1 Explanation Serverless compute allows Azure SQL Database to automatically adjust compute resources according […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 261 Which SQL Server feature can limit CPU, memory, or other resources available to specific workloads? Resource Governor Query Store Database Mail SQL Server Browser Correct Answer: 1 Explanation Resource Governor allows administrators to control and manage SQL Server resource consumption for different workloads. Administrators […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 241 Which SQL Server object is used to group multiple operations into a single unit of work that can be committed or rolled back? View Transaction Index Schema Correct Answer: 2 Explanation A transaction groups one or more database operations into a logical unit of […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 221 Which Azure SQL Database purchasing model allows administrators to select CPU and memory resources using vCores? DTU-based model vCore-based model Storage-only model Serverless-only model Correct Answer: 2 Explanation The vCore-based purchasing model allows administrators to select compute resources based on virtual CPU cores and […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 201 Which Azure service provides a fully managed relational database based on the SQL Server database engine? Azure Storage Azure SQL Database Azure Cosmos DB Azure Cache for Redis Correct Answer: 2 Explanation Azure SQL Database is a fully managed relational database service based on […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 181 Which SQL Server feature allows a database administrator to create a copy of a database schema and data for development or testing purposes? Database snapshot BACPAC Database role Query Store Correct Answer: 2 Explanation A BACPAC package can contain the schema and data of […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 161 Which SQL Server feature can automatically update statistics when SQL Server determines that existing statistics are outdated? Auto Update Statistics Auto Backup Auto Index Creation Auto Transaction Correct Answer: 1 Explanation Auto Update Statistics allows SQL Server to automatically refresh statistics when it determines […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 141 Which Azure service can provide recommendations to improve the performance, security, and reliability of Azure resources? Azure Advisor Azure DNS Azure Storage Explorer Azure Bastion Correct Answer: 1 Explanation Azure Advisor analyzes Azure resources and provides recommendations related to areas such as performance, security, […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 121 Which database permission allows a user to execute a stored procedure? SELECT EXECUTE INSERT REFERENCES Correct Answer: 2 Explanation The EXECUTE permission allows a user or principal to execute a stored procedure or other executable database objects where applicable. Granting execute permission can allow […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 101 Which Azure SQL Database purchasing model is based on vCores and allows more control over compute and storage resources? DTU-based model vCore-based model Basic model Serverless-only model Correct Answer: 2 Explanation The vCore-based purchasing model allows organizations to select compute resources based on virtual […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 81 Which Azure feature can restrict access to an Azure SQL Database by allowing only specified IP addresses? Azure SQL firewall rules Azure Storage lifecycle rules Azure DNS zones Azure Load Balancer rules Correct Answer: 1 Explanation Azure SQL firewall rules control which IP addresses […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 61 Which SQL Server tool is primarily used to schedule automated jobs such as backups and maintenance tasks? SQL Server Agent SQL Server Browser SQL Server Profiler Database Engine Tuning Advisor Correct Answer: 1 Explanation SQL Server Agent is used to automate scheduled tasks on […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 41 Which SQL Server object is commonly used to store a precompiled set of SQL statements and procedural logic? View Stored procedure Index Synonym Correct Answer: 2 Explanation A stored procedure is a database object that contains one or more SQL statements and can include […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 21 Which SQL Server function returns the current date and time of the database server? CURRENT_DATE() GETDATE() TODAY() SERVERDATE() Correct Answer: 2 Explanation The GETDATE() function returns the current date and time from the SQL Server instance. It is commonly used when inserting records that […]