: Manish Soni
: Administering Microsoft Azure SQL Solutions DP 300
: Poorav Publications
: 9789369720231
: 1
: CHF 7.50
:
: Sonstiges
: English
: 86
: DRM
: PC/MAC/eReader/Tablet
: ePUB

Administering Microsoft Azure SQL Solutions DP 300: 250+ Practice Questions is a meticulously curated resource designed to support candidates preparing for the DP-300 certification exam. This book serves as a comprehensive guide for database administrators and IT professionals, providing an extensive collection of practice questions, multiple-choice questions (MCQs) from previous years, and real-world scenarios that align with the essential competencies required for Microsoft Azure SQL solutions. Covering a broad spectrum of topics, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (both Windows and Linux), this book offers a structured approach to mastering the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. Through its well-structured content, candidates will gain a deep understanding of critical areas such as database management, availability, security, performance optimization, and automation using Transact-SQL (T-SQL) and administrative tools.
This book is more than just a compilation of practice questions-it is a strategic learning tool designed to reinforce knowledge, identify areas requiring further study, and simulate real exam conditions. The detailed explanations accompanying each question provide valuable insights, helping candidates develop a clear and practical understanding of key concepts. Whether you are an experienced database professional seeking certification validation or a newcomer aspiring to establish expertise in Azure database administration, DP-300 Administering Microsoft Azure SQL Solutions: 250+ Practice Questions serves as a definitive guide to enhance your readiness and confidence for the DP-300 examination. Engage with the content, challenge yourself with the questions, and let this book be your trusted companion in achieving success in Microsoft Azure SQL administration.

Chapter 2: Part 2


 

51. You have an Azure subscription and along with it you have a SQL Server Database which is causing a lot of performance issues.

You have set up an extended events engine in Azure SQL which is a lightweight and powerful monitoring system that allows you to capture granular information about activity in your databases and servers.

Which Channel within the Extended event is typically related to performance?

A. Admin Events

B. Operational Events

C. Analytic Events

D. Debug Events

 

Correct Answer: C

 

52. A company is planning to build a solution that would contain the below layers. You have to decide on which services will be used for each layer.

Which of the following would you choose as the service to use Service A?

A. Azure Blob Storage

B. Azure Data Factory

C. Azure Databricks

D. Azure SQL Datawarehouse

 

Correct Answer: B

 

53. You have a Microsoft Azure Subscription that holds an Azure SQL Managed Instance. This holds tables on various modules of an ERP system. You need to configure automatic tuning on the Azure SQL Managed Instance. Which Automatic tuning option is available for Instance database support?

a. FORCE_LAST_GOOD_PLAN

b. CREATE INDEX

c. DROP INDEX

d. CREATE PRIMARY KEY CONSTRAINT

 

Correct Answer: A

 

54. A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer. Which of the following would you choose as the service to use Service B?

A. Azure Blob Storage

B. Azure Data Factory

C. Azure Databricks

D. Azure SQL Datawarehouse

 

Correct Answer: A

 

55. You have a ‘server01’ running HADR with a primary role and it crashes. The DBA performs a HADR takeover by force on the ‘servers02’ to switch roles. The ‘server02’ now becomes the primary server. The below DMVs provide information on the state of a replica. Match the correct definition with their respective DMVs.

 

Correct Answer: 1-B, 2-C, 3-D and 4-A

 

56. A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer. Which of the following would you choose as the service to use Service C?

A. Azure Blob Storage

B. Azure Data Factory

C. Azure Databricks

D. Azure SQL Datawarehouse

 

Correct Answer: C

 

57. You have an Azure SQL server virtual machine.

You need to back up the transaction log from the Primary server instance to the secondary server instance. Which option should you choose?

A. Implement ‘Always On’ availability groups

B. Configure transactional replication

C. Configure Transaction Log Shipping

D. Import a DACPAC

 

Correct Answer: C

 

58. A company is planning to build a solution that would contain the below layers.

You have to decide on which services will be used for each layer. Which of the following would you choose as the service to use Service D?

A. Azure Blob Storage

B. Azure Data Factory

C. Azure Databricks

D. Azure SQL Datawarehouse

 

Correct Answer: D

 

59. A company currently stores data about its customers. The different properties of the customer data are shown below.

The data is going to be stored in an Azure Cosmos DB container. The queries on the data will be filtered by using the Customer Category and the Customer