SACA Factory Data Analytics 2

Question 1

Which data aggregation method is most appropriate for calculating the average cycle time across multiple production shifts?

Accepted Answer

Apply a weighted average based on units produced per shift

Answer

A weighted average accounts for varying production volumes per shift, giving a more accurate overall cycle time.

Question 2

In factory analytics, what does the term 'data historian' refer to?

Accepted Answer

A software system that stores time-series industrial data

Answer

A data historian is specialized software that captures and stores time-stamped process data from industrial equipment.

Question 3

A control chart shows seven consecutive data points all above the center line. This pattern indicates:

Accepted Answer

A potential process shift requiring investigation

Answer

Seven consecutive points on one side of the centerline is a Western Electric run rule signal indicating a non-random process shift.

Question 4

What is the primary purpose of data normalization in factory analytics pipelines?

Accepted Answer

To scale features to a common range for fair model comparison

Answer

Normalization scales input features to a consistent range so that no single variable dominates model training due to magnitude differences.

Question 5

Which SQL window function would you use to calculate a 5-minute rolling average of machine temperature readings?

Accepted Answer

AVG() OVER (PARTITION BY ... ORDER BY ... ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)

Answer

The ROWS BETWEEN clause in a window function defines the rolling frame over which the average is computed.

SACA - Smart Automation Certification Alliance Practice Test