Question 1 of 30
A database administrator is tasked with optimizing the performance of a large e-commerce database that frequently handles complex queries involving product searches, customer orders, and inventory levels. The administrator decides to implement indexing strategies to enhance query performance. Given that the database contains millions of records, which indexing strategy would most effectively reduce the query execution time for searches based on product names and categories, while also considering the potential impact on write operations?
Creating a composite index on both product name and category fields
Implementing a full-text index on the product description field
Using a clustered index on the product ID field
Establishing a unique index on the customer email field

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free