CompTIA Exam DA0-001 Topic 5 Question 39 Discussion

Actual exam question for CompTIA's DA0-001 exam

Question #: 39
Topic #: 5

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5.000.000 rows?

AMicrosoft Excel

CSnowflake

DSQL

Show Suggested Answer

Suggested Answer: A

by Tanja at Jul 17, 2024, 08:30 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Blythe

7 days ago

B for sure. R is a power tool for statistical analysis, and it can handle huge datasets like no other. Excel would probably start smoking if you tried to run those calculations on 5 million rows!

upvoted 0 times

...

Sheridan

10 days ago

I personally prefer using Microsoft Excel for these calculations as it is user-friendly and easy to use.

upvoted 0 times

...

Hmm, I'd say R would be the way to go for crunching those big numbers. Excel might choke on a dataset that size, and Snowflake is more for warehousing than analysis, right? SQL could work, but R has those built-in stats functions that would make this a breeze.

upvoted 0 times

...

Barrie

17 days ago

I disagree, I believe SQL would be the best option as it is efficient for handling large datasets and performing calculations.

upvoted 0 times

...

Leila

22 days ago

I think R would be the best tool for this task because it is specifically designed for statistical analysis.

upvoted 0 times

...

CompTIA Exam DA0-001 Topic 5 Question 39 Discussion

Contribute your Thoughts:

Blythe

Sheridan

Erinn

Barrie

Leila