PrepAway - Latest Free Exam Questions & Answers

What steps will allow you to minimize the data analyzed?

You are analyzing a historical data source with 500 million records with approximately 15
million added per year. You wish to analyze only records from the year 2000. The table
contains a numeric field called YearAdded. What steps will allow you to minimize the data
analyzed?

PrepAway - Latest Free Exam Questions & Answers

A.
Create Virtual Table; Set Where clause to YearAdded= 2000; Select Virtual Table; Run
Column Analysis.

B.
Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample
Type to Random. Sample Interval to First, and Sample Size to 15.000.000.

C.
Select Table; Run Column Analysis; Select Sample tab; Check Use Sample; Set Sample
Type to Sequential and Sample Size to 15.000.000.

D.
Select Table; Run Column Analysis; Select Analysis Settings tab; Set Where clause to
YearAdded= 2000.

Explanation:

One Comment on “What steps will allow you to minimize the data analyzed?


Leave a Reply