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 PDFThe 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. Which of these is NOT a reason to use normalization?
a) Minimise duplicate data
b) Restrict what type of data can go in a particular column.
c) Reduce inconsistent data
d) Simplifying queries.
 
02. Which DMV shows for I/O statistics for each data and log file (one row per data or log file)?
a) sys.dm_os_performance_counters
b) sys.dm_os_job_object
c) sys.dm_io_virtual_file_stats
d) sys.dm_exec_requests
 
03. You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases. You need to update the column and index statistics for the databases. What should you use?
a) an Azure Automation runbook
b) a SQL Agent job
c) Azure SQL Analytics
d) automatic tuning in Azure SQL Database
 
04. What is the difference between the Standard version and the Premium version of Azure Key Vault?
a) The Standard version allows for Cryptographic Operations as well as Key Management Operations.
b) The Premium version allows for Cryptographic Operations as well as Key Management Operations.
c) The Standard version allows for a Hardware Security Module (HSM).
d) The Premium version allows for a Hardware Security Module (HSM).
 
05. Which of the following Stored Procedures can be used in Azure SQL Database to list the database roles?
a) sp_helprole
b) sp_helprotect
c) sp_helprolemember
d) sp_helpdatabaserole
 
06. I want to do an online upgrade to SQL Server 2019 Standard. Which of the following can I NOT upgrade from?
a) SQL Server 2019 Developer
b) SQL Server 2019 Express
c) SQL Server 2012 Standard
d) SQL Server 2016 Enterprise
 
07. You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?
a) Run the sp_configure command.
b) Enable the SQL Server Agent.
c) Run the sp set_agent properties command.
d) Use the Agent XPs option.
 
08. What is the maximum time period that differential backups can be stored for Azure SQL Database on the General Purpose tier?
a) 7 days
b) 35 days
c) 1 year
d) 10 years
 
09. Which of the following is true for both Change Data Capture and Change Tracking?
a) They both track the data in previous versions of that row.
b) They are both enabled by default.
c) They both track whether the column was changed.
d) To use it, you don't need to enable it for the database - you only need to enable for a table.
 
10. What is the minimum time for auto-failover?
a) 1 minute
b) 1 hour
c) 1 day
d) 1 week

Answers:

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

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.

Rating: 4.9 / 5 (82 votes)