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

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 301 Which security tool continuously monitors systems and networks for changes to configurations, files, and security settings? Configuration monitoring Data masking Load balancing Tokenization Correct Answer: 1 Explanation Configuration monitoring continuously checks systems and network devices to identify unauthorized or unexpected changes. It can monitor […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 281 Which security control is primarily used to detect unauthorized changes to critical system files? Network segmentation File integrity monitoring Data masking Load balancing Correct Answer: 2 Explanation File integrity monitoring (FIM) detects unauthorized or unexpected changes to important files, directories, and system configurations. It […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 261 Which Azure service provides a managed relational database service based on Microsoft SQL Server? Azure Cosmos DB Azure SQL Database Azure Table Storage Azure Queue Storage Correct Answer: 2 Explanation Azure SQL Database is a fully managed relational database service based on the Microsoft […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 241 Which Azure service provides a platform for hosting web applications without managing the underlying operating system? Azure Virtual Machines Azure Storage Azure App Service Azure Load Balancer Correct Answer: 3 Explanation Azure App Service is a managed platform for hosting web applications, REST APIs, […]

View Full Microsoft AZ-104 Exam Dumps and Practice Test Dumps.   Question 221 Which Azure service allows administrators to query information about resources across multiple subscriptions using Kusto Query Language? Azure Resource Graph Azure Advisor Azure Service Health Azure Bastion Correct Answer: 1 Explanation Azure Resource Graph allows administrators to explore and query Azure resources across subscriptions […]