View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q1. Which Azure service should you use to deploy a fully managed relational database based on Microsoft SQL Server? 1) Azure Cosmos DB 2) Azure SQL Database 3) Azure Blob Storage 4) Azure Table Storage Correct Answer: 2) Explanation: Azure SQL Database is a […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q21. Which Azure SQL Database purchasing model provides pricing based primarily on vCores and configurable compute and storage resources? 1) DTU-based purchasing model 2) vCore-based purchasing model 3) Database transaction model 4) Storage-only purchasing model Correct Answer: 2) Explanation: The vCore-based purchasing model for […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q41. Which Azure SQL Database service tier is designed to provide high performance with low-latency access and built-in availability features? 1) Basic 2) General Purpose 3) Business Critical 4) Serverless Correct Answer: 3) Explanation: The Business Critical service tier is designed for workloads that […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q61. Which Azure SQL Database feature provides automatic failover between databases in different Azure regions? 1) Failover groups 2) Query Store 3) Elastic pools 4) Dynamic Data Masking Correct Answer: 1) Explanation: Azure SQL Database failover groups are designed to manage databases across different […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q81. Which Azure SQL Database purchasing model allows you to select resources based on virtual CPU cores? 1) DTU-based model 2) vCore-based model 3) Serverless model 4) Consumption model Correct Answer: 2) Explanation: The vCore-based purchasing model allows administrators to select Azure SQL Database […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Q101. Which Azure SQL Database feature helps identify query performance regressions by retaining query execution information over time? 1) Azure Monitor 2) Query Store 3) Elastic pool 4) Microsoft Defender for SQL Correct Answer: 2) Explanation: Query Store collects and retains information about queries, […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 121. Which Azure service provides centralized monitoring for database resources and applications? 1) Azure Monitor 2) Azure DevOps 3) Azure Storage 4) Azure DNS Answer: 1) Azure Monitor Explanation: Azure Monitor collects and analyzes telemetry from Azure resources, applications, and infrastructure. Database administrators […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 141. Which Azure SQL Database feature helps automatically detect and resolve common performance issues? 1) Azure Advisor 2) Automatic tuning 3) Azure Storage Explorer 4) Microsoft Sentinel Answer: 2) Automatic tuning Explanation: Automatic tuning in Azure SQL Database continuously monitors database performance and […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 161. Which SQL Server feature helps restrict users from accessing specific rows in a table? 1) Dynamic Data Masking 2) Row-Level Security 3) Transparent Data Encryption 4) Always Encrypted Answer: 2) Row-Level Security Explanation: Row-Level Security (RLS) controls access to individual rows based […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 181. Which SQL Server feature allows administrators to automatically apply recommended performance changes based on workload analysis? 1) Automatic tuning 2) Transparent Data Encryption 3) Row-Level Security 4) Database Mail Answer: 1) Automatic tuning Explanation: Automatic tuning helps SQL Server identify and apply […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 201. Which Azure SQL Database feature helps automatically improve query performance by forcing a previously successful execution plan when a regression is detected? 1) Automatic plan correction 2) Dynamic Data Masking 3) Row-Level Security 4) Azure Backup Answer: 1) Automatic plan correction Explanation: […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 221. Which feature controls inbound network connections to an Azure SQL Database server? 1) Server-level firewall rules 2) Query Store 3) Database Mail 4) Automatic tuning Answer: 1) Server-level firewall rules Explanation: Azure SQL Database uses firewall rules to control which client IP […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 241. Which Azure SQL Database feature allows an administrator to configure alerts based on monitored metric values? 1) Azure Monitor alerts 2) Database Mail 3) Query Store 4) Transparent Data Encryption Answer: 1) Azure Monitor alerts Explanation: Azure Monitor alerts can notify administrators […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 261. Which SQL Server feature allows administrators to group users and assign permissions to the group? 1) Database roles 2) Query Store 3) Statistics 4) Indexes Answer: 1) Database roles Explanation: Database roles provide a convenient way to organize database principals and manage […]

View Full Microsoft DP-300 Exam Dumps and Practice Test Dumps   Question 281. Which Azure service provides a fully managed SQL Server instance with near-complete SQL Server compatibility? 1) Azure SQL Database 2) Azure SQL Managed Instance 3) Azure Cosmos DB 4) Azure Database for PostgreSQL Answer: 2) Azure SQL Managed Instance Explanation: Azure SQL […]