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

Sum all cycle times and divide by total shifts

Answer

Use the median of shift totals to eliminate outliers

Answer

Select the maximum cycle time recorded across shifts

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 worker who manually records production logs

Answer

A report summarizing past quality incidents

Answer

A database of supplier transaction histories

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

Normal random variation within control limits

Answer

The process is running at peak efficiency

Answer

Measurement system calibration is perfect

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

To compress sensor data for faster transmission

Answer

To remove all negative values from datasets

Answer

To convert analog signals to digital format

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

GROUP BY with AVG()

Answer

HAVING AVG(temperature) with a subquery

Answer

DISTINCT AVG() with a LIMIT clause

Question 6

A manufacturer notices that defect rates spike every Monday morning. This is an example of what type of data pattern?

Accepted Answer

Seasonality or cyclical pattern

Answer

Random noise

Answer

Trend

Answer

Outlier cluster

Question 7

In the context of SACA factory analytics, what does SCADA stand for?

Accepted Answer

Supervisory Control and Data Acquisition

Answer

Statistical Control and Data Analysis

Answer

System Configuration and Device Automation

Answer

Sensor Calibration and Data Archiving