View Full Cisco 200-301 Exam Dumps and Practice Test Dumps.   Question 1 Which OSI model layer is responsible for logical addressing and routing packets between different networks? Data Link layer Network layer Transport layer Session layer Correct Answer: 2 Explanation The Network layer, Layer 3 of the OSI model, is responsible for logical addressing […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 381 Which Microsoft service can help migrate SQL Server databases to Azure by providing migration assessment and guidance? Azure Database Migration Service Azure DNS Azure Key Vault Azure Advisor Correct Answer: 1 Explanation Azure Database Migration Service is designed to help migrate database workloads to […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 361 Which Azure SQL feature allows read-only queries to be routed to a readable secondary replica? Read scale-out Transparent Data Encryption Dynamic Data Masking Row-Level Security Correct Answer: 1 Explanation Read scale-out allows supported Azure SQL workloads to send read-only queries to secondary replicas instead […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 341 Which connection policy can reduce connection latency for Azure SQL Database clients by sending traffic directly to the database after the initial connection? Proxy Redirect Offline Tunnel Correct Answer: 2 Explanation The Redirect connection policy allows Azure SQL Database clients to establish the initial […]

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 321 Which T-SQL statement removes a previously granted or denied permission from a database principal? DROP REVOKE GRANT ALTER Correct Answer: 2 Explanation The REVOKE statement removes a previously granted or denied permission from a database principal. It is commonly used when access should no […]

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 […]