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. You must migrate databases from on-premises SQL1 to Azure. The target must communicate with on-premises SQL2 through linked server connections while minimizing infrastructure administration. What should host the migrated databases?

a) A single Azure SQL Database

b) SQL Server on Azure Virtual Machines

c) Azure SQL Managed Instance

d) An Azure SQL Database elastic pool

02. Reference scenario: Contoso.

A customer Azure SQL Database has had a large, one-time archival-data deletion. You need to reclaim physical file space and will assess index fragmentation afterward. Which command is appropriate?

a) DBCC SHRINKDATABASE

b) sp_clean_db_free_space

c) DBCC CHECKDB

d) sp_clean_db_file_free_space

03. Reference Scenario: DP-300 Case 7 — Tailspin Toys retail and manufacturing platform

You are planning the Azure target that will host Orders. What should you do to preserve the case-sensitive comparison behavior?

a) Deploy Orders to Azure SQL Database, then configure the data collation and the catalog collation on the database.

b) Specify SQL_Latin1_General_CP1_CS_AS as the server-level collation when you create the Azure SQL Managed Instance.

c) Create the managed instance with the default collation, then set each migrated database to SQL_Latin1_General_CP1_CS_AS by using ALTER DATABASE.

d) Create the managed instance with the default collation, then change that collation after migration.

04. On SQL Server running on an Azure VM, a Policy-Based Management condition must mark a database as compliant only when its recovery model is Full. The selected facet field is @RecoveryModel. Which condition expression should you enter?

a) Operator: =; Value: Bulk Logged

b) Operator: !=; Value: Full

c) Operator: <>; Value: Full

d) Operator: =; Value: Full

05. Two SQL Server 2019 Enterprise instances run on Azure virtual machines in one availability set and form a failover cluster instance named FCI1. Client applications need a highly available connection endpoint, and the design must minimize infrastructure cost. What should you create?

a) A Basic Azure Load Balancer

b) An Azure Standard Load Balancer

c) A distributed network name resource

d) A virtual network name resource

06. Reference Scenario: DP-300 Case 4 — Fabrikam regional logistics

A database administrator proposes adding ArchiveDB to a failover group whose secondary is a logical server in a second Azure region. Which statement best evaluates the proposal against the ArchiveRecovery requirement?

a) It satisfies ArchiveRecovery most economically, because a failover group's geo-secondary incurs compute charges only after an actual failover

b) It meets the recovery targets but breaks the standby compute constraint, and geo-restore satisfies ArchiveRecovery

c) It fails ArchiveRecovery because a failover group cannot contain a General Purpose database, so no regional copy is possible

d) It is required, because only a failover group can recover ArchiveDB in another region

07. You deploy a SQL Server failover cluster instance to two Azure virtual machines. You must avoid both an Azure Load Balancer and a distributed network name for FCI client connectivity. What should you do?

a) Connect both virtual machines to one subnet.

b) Deploy the virtual machines to different proximity placement groups in one region.

c) Connect the virtual machines to different subnets in the same virtual network.

d) Deploy both virtual machines to one proximity placement group.

08. 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) An Azure Automation runbook

b) A SQL Server Agent job

c) Automatic tuning in Azure SQL Database

d) An Azure Monitor log alert rule

09. SQL Server runs on an Azure virtual machine. A database query intermittently consumes excessive CPU and degrades other workloads. You need historical query execution and performance details with minimal ongoing administration. Which feature should you use?

a) SQL Server Profiler

b) Query Store

c) Database Engine Tuning Advisor

d) Resource Governor

10. An Availability Group primary and secondary are synchronized and configured for automatic failover. Which statement is true about the availability mode required for automatic failover without acknowledged transaction loss?

a) A planned manual failover of the synchronized pair necessarily causes data loss.

b) An automatic failover of the synchronized pair is a forced failover with possible data loss.

c) Automatic failover requires asynchronous-commit mode.

d) Automatic failover requires synchronous-commit mode on the automatic failover pair.

Answers:

Question: 01 Answer: c	Question: 02 Answer: a	Question: 03 Answer: b	Question: 04 Answer: d	Question: 05 Answer: c
Question: 06 Answer: b	Question: 07 Answer: c	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.