Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - 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 DA0-001 Exam - Topic 4 Question 11 Discussion

Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company.Which of the following systems is the most appropriate?
C) Data warehouse.
A) OLTP.
B) OLAP.
D) Data mart.

CompTIA DA0-001 Exam - Topic 4 Question 11 Discussion

Actual exam question for CompTIA's DA0-001 exam
Question #: 11
Topic #: 4
[All DA0-001 Questions]

Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company.

Which of the following systems is the most appropriate?

Show Suggested Answer Hide Answer
Suggested Answer: C

A Data mart is too narrow, because Taylor needs data from across multiple divisions.

OLAP is a broad term for analytical processing, and OLTP systems are transactional and not ideal for the task. Since Taylor is working with data across multiple different divisions, she will work with a Data warehouse.


by Cory at Dec 25, 2022, 02:36 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Latonia
8 months ago
Data mart could work too, but it’s more limited.
upvoted 0 times
...
Brittani
8 months ago
Wait, can OLTP even handle this kind of analysis?
upvoted 0 times
...
Alyce
9 months ago
Definitely OLAP, it’s designed for analysis!
upvoted 0 times
...
Denise
9 months ago
I think a data warehouse would be more comprehensive.
upvoted 0 times
...
Viki
9 months ago
OLAP is the way to go for this!
upvoted 0 times
...
Yuette
9 months ago
I feel like OLTP is more about transaction processing, so it probably wouldn’t help Taylor with her analysis.
upvoted 0 times
...
Pamella
9 months ago
I’m leaning towards OLAP too, but I wonder if a data mart could be useful for specific insights on profitability.
upvoted 0 times
...
Lyda
9 months ago
I remember practicing a question about data warehouses, and they seem more focused on storage rather than analysis.
upvoted 0 times
...
Loreta
9 months ago
I think OLAP might be the right choice since it’s designed for analysis and reporting, but I'm not completely sure.
upvoted 0 times
...
Basilia
9 months ago
Hmm, I'm a bit unsure about this one. I'll need to think it through carefully.
upvoted 0 times
...
Edelmira
10 months ago
Okay, I know the Multi-Org Access Control feature is used to control access across different organizations, so the reporting levels must be related to that. I'll try to remember the different organizational entities we've covered.
upvoted 0 times
...

Save Cancel