Soni | Administering Microsoft Azure SQL Solutions DP 300 | E-Book | www.sack.de
E-Book

E-Book, Englisch, Band 18, 86 Seiten

Reihe: Azure Books Series

Soni Administering Microsoft Azure SQL Solutions DP 300


1. Auflage 2024
ISBN: 978-93-6972-023-1
Verlag: Poorav Publications
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, Band 18, 86 Seiten

Reihe: Azure Books Series

ISBN: 978-93-6972-023-1
Verlag: Poorav Publications
Format: EPUB
Kopierschutz: 0 - No protection



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.

Soni Administering Microsoft Azure SQL Solutions DP 300 jetzt bestellen!

Autoren/Hrsg.


Weitere Infos & Material


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 Surname.

Which of the following would you use as the Partition Key?

A. Customer ID

B. Customer Surname

C. Customer Given Name

D. Customer Category

Correct Answer: D

60. You have a large production Azure SQL database named ‘bankdb’. You are running a reporting or analytics workload on this data that is causing performance issues.

To overcome this issue you decide to have a second database such that additional workload can be handled thereby minimizing the performance impact on your production workload. Data Sync helps you to keep the two databases synchronized. Below are the steps required to set up SQL Data Sync between databases. Identify the correct sequence from the options below.

A. Add a Database in Azure SQL Database

B. Add a SQL Server Database

C. Create a Sync group

D. Configure Sync Group

E. Add Sync Member

Correct Answer: A

71. Which of the following would you use as the Item ID?

A. Customer ID

B. Customer Surname

C. Customer Given Name

D. Customer Category

Correct Answer: A

72. A company is planning on implementing an Azure data warehousing solution. A snippet of the tables in the data warehouse is shown below.

All dimension tables will be less than 4 GB after compression. The fact table will be approximately 5 TB. You have to decide on the underlying table type for each table. Which of the following would you use as the underlying table type for the Whizlab_employee table?

A. Primary

B. Hash distributed

C. Replicated

D. Round-robin

Correct Answer: C

73. You have an Azure SQL manage instance that has a database named IBC-data that stores data in geo-redundant storage blobs which are replicated to a paired region. Match the following storage redundancies for backup.

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

74. Which of the following would you use as the underlying table type for the Whizlab_fact table?

A. Primary

B. Hash distributed

C. Replicated

D. Round-robin

Correct Answer: B.

75. Which of the following would you use as the underlying table type for the Whizlab_Customer table?

A. Primary

B. Hash distributed

C. Replicated

D. Round-robin

Correct Answer: C

76. You have a Microsoft Azure SQL database instance running in the single-user mode for a POS application that manages sales and performs day to day operations of the retail store. We have a table named product_specification. The non-cluster index is created on columns

batch_number, name, description, and price. There was a loss of data due to a deadlock caused when multiple users started performing CRUD operations.

Which parameter option under the DBCC(Database Console Commands) check would ensure an integrity check for the given table with no data loss?

A. NOINDEX

B. REPAIR_FAST

C. REPAIR_REBUILD

D. REPAIR_ALLOW_DATA_LOSS

Correct Answer: C

77. Which of the following would you use as the underlying table type for the Whizlab_Course table?

A. Primary

B. Hash distributed

C. Replicated

D. Round-robin

Correct Answer: C

78. An instance of Microsoft Azure SQL Server has a Sales Database with multiple objects. You have multiple indexes created on tables. Index pages are increasing massively because of the Insert and Update operation.

Name a stored procedure that provides all information about the fragmentation page and space.

A. dm_db_index_physical_stats

B. dm_db_column_store_row_group_physical_stats

C. dm_db_index_usage_stats

D. dm_db_index_operational_stats

Correct Answer: A

79. A company wants to create multiple Cosmos DB accounts. Each account has different requirements. Below are the requirements for each account. Whizlabaccount-stag – This account should be able to store log records. Whizlabaccount-prod – This account should be able to store Social media mentions. Which of the following would you use as the API for the Whizlabaccount-stag account?

A. Cassandra

B. Gremlin

C. SQL

D. Table

Correct Answer: C

80. Which of the following would you use as the API for the Whizlabaccount-prod account?

A. Cassandra

B. Gremlin

C. SQL

D. Table

Correct Answer: B

81. You need to run a Transact-SQL system stored procedure on the Microsoft Azure job agent database. For this, we need to add a new target server member to the target group containing server(s) and exclude a database target member MappingDB from the server target group. Identify the procedure that would help us perform the above tasks.

A. jobs.target_groups

B. jobs.sp_add_target_group

C. jobs.sp_add_target_group_member

D. jobs.target_group_members

Correct Answer: C

82. A company is designing an application that would be used to store images. They are going to be using Azure blob storage. They have the following requirements when it comes to the storage of images. When an image is first uploaded, it would be accessed frequently. After a week, the images would not be accessed frequently. But if accessed, it would need to be available within 30 seconds. After a year, the data would not be accessed that frequently, but it would need to be available within 5 minutes if it was accessed. The data storage costs must be minimized. Which of the following would you choose as the storage tier for the images for the first week?...



Ihre Fragen, Wünsche oder Anmerkungen
Vorname*
Nachname*
Ihre E-Mail-Adresse*
Kundennr.
Ihre Nachricht*
Lediglich mit * gekennzeichnete Felder sind Pflichtfelder.
Wenn Sie die im Kontaktformular eingegebenen Daten durch Klick auf den nachfolgenden Button übersenden, erklären Sie sich damit einverstanden, dass wir Ihr Angaben für die Beantwortung Ihrer Anfrage verwenden. Selbstverständlich werden Ihre Daten vertraulich behandelt und nicht an Dritte weitergegeben. Sie können der Verwendung Ihrer Daten jederzeit widersprechen. Das Datenhandling bei Sack Fachmedien erklären wir Ihnen in unserer Datenschutzerklärung.