Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA Exam DS0-001 Topic 1 Question 41 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 41
Topic #: 1
[All DS0-001 Questions]

A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of the following is the best way for the administrator to accomplish this task?

Show Suggested Answer Hide Answer
Suggested Answer: A

The best way for the administrator to accomplish this task is to create a materialized view. A materialized view is a type of view that stores the result of a query on one or more tables as a separate table in the database. A materialized view can aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department as a single source of truth. A materialized view also improves query performance and efficiency by reducing the need to recompute complex queries every time they are executed. The other options are either not suitable or not optimal for this task. For example, creating indexes on those tables may improve query performance on individual tables, but not on aggregated data; creating a new database may require additional resources and maintenance, and may introduce inconsistency or redundancy; creating a function may require additional coding and execution, and may not store the result as a separate table.Reference:CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.2 Given a scenario, create database objects using scripting and programming languages.


by Linn at Jun 15, 2025, 07:51 PM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Emilio
7 days ago
I think the best way is to create a materialized view.
upvoted 0 times
...

Save Cancel