SACA Factory Data Analytics 2 — Questions and Answers
Question 1: Which data aggregation method is most appropriate for calculating the average cycle time across multiple production shifts?
- Sum all cycle times and divide by total shifts
- Use the median of shift totals to eliminate outliers
- Apply a weighted average based on units produced per shift (Correct answer)
- Select the maximum cycle time recorded across shifts
Correct answer: Apply a weighted average based on units produced per shift
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?
- A worker who manually records production logs
- A software system that stores time-series industrial data (Correct answer)
- A report summarizing past quality incidents
- A database of supplier transaction histories
Correct answer: A software system that stores time-series industrial data
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:
- Normal random variation within control limits
- A potential process shift requiring investigation (Correct answer)
- The process is running at peak efficiency
- Measurement system calibration is perfect
Correct answer: A potential process shift requiring investigation
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?
- To compress sensor data for faster transmission
- To scale features to a common range for fair model comparison (Correct answer)
- To remove all negative values from datasets
- To convert analog signals to digital format
Correct answer: To scale features to a common range for fair model comparison
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?
- GROUP BY with AVG()
- AVG() OVER (PARTITION BY ... ORDER BY ... ROWS BETWEEN 4 PRECEDING AND CURRENT ROW) (Correct answer)
- HAVING AVG(temperature) with a subquery
- DISTINCT AVG() with a LIMIT clause
Correct answer: AVG() OVER (PARTITION BY ... ORDER BY ... ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)
The ROWS BETWEEN clause in a window function defines the rolling frame over which the average is computed.
Question 6: A manufacturer notices that defect rates spike every Monday morning. This is an example of what type of data pattern?
- Random noise
- Trend
- Seasonality or cyclical pattern (Correct answer)
- Outlier cluster
Correct answer: Seasonality or cyclical pattern
A repeating pattern tied to a calendar cycle (weekly in this case) is classified as seasonality or a cyclical pattern.
Question 7: In the context of SACA factory analytics, what does SCADA stand for?
- Supervisory Control and Data Acquisition (Correct answer)
- Statistical Control and Data Analysis
- System Configuration and Device Automation
- Sensor Calibration and Data Archiving
Correct answer: Supervisory Control and Data Acquisition
SCADA stands for Supervisory Control and Data Acquisition, a system used to monitor and control industrial processes.
SACA Factory Data Analytics 2
Which data aggregation method is most appropriate for calculating the average cycle time across multiple production shifts?