Microsoft Administering Azure SQL Solutions (DP-300) Certification Sample Questions

Administering Azure SQL Solutions Dumps, DP-300 Dumps, DP-300 PDF, Administering Azure SQL Solutions VCE, Microsoft DP-300 VCE, Microsoft Administering Azure SQL Solutions PDF The purpose of this Sample Question Set is to provide you with information about the Administering Microsoft Azure SQL Solutions exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-300 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Administering Azure SQL Solutions Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Azure Database Administrator Associate certification exam.

These sample questions are simple and basic questions that represent likeness to the real Microsoft DP-300 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Administering Azure SQL Solutions Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

Microsoft DP-300 Sample Questions:

01. An on-premises SQL Server 2019 database uses merge replication. You must migrate it to Azure while retaining a platform that supports merge replication. Which service should you use?

a) Azure SQL Database

b) SQL Server on Azure Virtual Machines

c) Azure SQL Managed Instance

d) Azure SQL Edge

02. A production workload currently runs on SQL Server Enterprise edition, but the target must run Standard edition. You must avoid an unsupported in-place edition downgrade and preserve a tested rollback path. Which migration strategy should you use?

a) Provision a Standard-edition target, resolve feature incompatibilities, and migrate side by side

b) Use a product key to perform an in-place downgrade to Standard edition

c) Install Developer edition on the production server

d) Back up master and alter the existing instance to Standard edition

03. Which system stored procedure lists the database roles in the current Azure SQL Database?

a) sp_helprolemember

b) sp_helpdatabaserole

c) sp_helprotect

d) sp_helprole

04. A DBA investigates storage latency and needs cumulative I/O statistics for every data file and log file in a database. Which dynamic management function should the DBA query?

a) sys.dm_io_virtual_file_stats

b) sys.dm_os_job_object

c) sys.dm_os_performance_counters

d) sys.dm_exec_requests

05. You need an encryption technology that protects SQL Server data at rest but does not protect plaintext while it is in use by the Database Engine. Which technology fits this scope?

a) Always Encrypted

b) Dynamic Data Masking (DDM)

c) Transparent Data Encryption (TDE)

d) Transport Layer Security (TLS)

06. A synchronization design must determine which rows had data modifications. Which statement correctly compares Change Data Capture (CDC) and Change Tracking in SQL Server?

a) Both features require SQL Server Agent to be disabled.

b) Both features capture previous row versions.

c) Both features can identify that DML changes occurred; CDC also retains historical change data.

d) Both features are enabled automatically for user tables.

07. Four Azure subscriptions contain multiple Azure SQL Databases. You need a centralized, scheduled way to run maintenance that updates column and index statistics across the databases. What should you use?

a) Automatic tuning in Azure SQL Database

b) An Azure Automation runbook

c) A SQL Server Agent job

d) An Azure Monitor log alert rule

08. An Azure SQL Database workload needs the vCore purchasing model so its compute, memory, and storage can be selected independently. It is a general business workload that needs a budget-oriented balance of compute and storage rather than the high-I/O requirements of a business-critical workload.

Which service tier should you choose?

a) General Purpose

b) Standard

c) Basic

d) Premium

09. You have an Azure SQL Managed Instance and need to configure SQL Agent job email notifications. Before creating the required managed-instance Database Mail profile and job notification, you must enable Database Mail. Which configuration change enables the Database Mail feature?

a) Run sp_set_agent_properties.

b) Enable Database Mail XPs by using sp_configure.

c) Enable Agent XPs.

d) Enable SQL Server Agent.

10. A customer-managed database protector must use an HSM-protected key stored in an Azure Key Vault vault. Which statement correctly identifies the required Key Vault tier capability?

a) Only Premium Key Vault can perform ordinary software-protected key operations.

b) Standard Key Vault supports HSM-protected keys for this requirement.

c) Standard Key Vault supplies the Premium HSM-protected key types.

d) Premium Key Vault supports HSM-protected keys.

Answers:

Question: 01 Answer: b	Question: 02 Answer: a	Question: 03 Answer: d	Question: 04 Answer: a	Question: 05 Answer: c
Question: 06 Answer: c	Question: 07 Answer: b	Question: 08 Answer: a	Question: 09 Answer: b	Question: 10 Answer: d

Note: For any error in Microsoft Certified - Azure Database Administrator Associate (DP-300) certification exam sample questions, please update us by writing an email on feedback@edusum.com.