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

View Full Microsoft DP-800 Exam Dumps and Practice Test Dumps.   Question 1 Which SQL statement is used to retrieve data from one or more tables in a SQL Server database? SELECT GET FETCH READ Correct Answer: 1 Explanation The SELECT statement is used to retrieve data from tables, views, and other queryable objects in […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 381 Which security control is designed to prevent unauthorized users from accessing a restricted physical area? Badge reader Load balancer Proxy server SIEM Correct Answer: 1 Explanation A badge reader is a physical access control that verifies an individual’s authorized credential before allowing entry into […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 361 Which security control is used to verify that a user’s identity is valid before granting access to a system? Authentication Authorization Accounting Auditing Correct Answer: 1 Explanation Authentication is the process of verifying the identity of a user, device, or system before access is […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 341 Which security principle ensures that sensitive information is accessible only to authorized individuals? Availability Integrity Confidentiality Non-repudiation Correct Answer: 3 Explanation Confidentiality is the security principle that ensures sensitive information is accessible only to authorized individuals, systems, or processes. Organizations protect confidentiality through access […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 321 Which security solution collects and analyzes log data from multiple sources to identify potential security threats? SIEM VPN NAC HSM Correct Answer: 1 Explanation A security information and event management (SIEM) solution collects logs and security events from multiple systems, applications, servers, endpoints, and […]