wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database and AWS

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

In an automobile factory, the engine performance logs with fixed columns like engine temperature, RPM, and oil pressure are an example of:

a)

Structured data

b)

Unstructured data

c)

Semi-structured data

d)

Metadata

2.

Video recordings from assembly line cameras used for defect detection are considered:

a)

Structured data

b)

Unstructured data

c)

Normalized data

d)

Indexed data

3.

Which of the following is a key difference between structured and unstructured data in car manufacturing?

a)

Structured data cannot be stored in databases

b)

Structured data has a predefined schema; unstructured data does not

c)

Unstructured data is always numeric

d)

Unstructured data is faster to query than structured data

4.

In the context of automobile sales transactions, which ACID property ensures that either the full transaction completes or nothing happens if there is a power failure?

a)

Consistency

b)

Atomicity

c)

Isolation

d)

Durability

5.

Ensuring that after updating a car's warranty record, all data remains accurate and conforms to predefined rules demonstrates:

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Scalability

6.

Multiple engineers updating the same vehicle design specification simultaneously without interference illustrates which ACID property?

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

7.

Which concurrency control method would prevent two robotic arms from modifying the same assembly log simultaneously?

a)

Two-phase commit

b)

Locking mechanism

c)

Load balancing

d)

Data sharding

8.

In automobile production databases, optimistic concurrency control is suitable when:

a)

Multiple updates are frequent

b)

Updates are rare and collisions are unlikely

c)

Data is unstructured

d)

Only read operations exist

9.

Which of the following cloud ML stacks can be used to predict car part failures based on sensor data from the production line?

a)

AWS SageMaker

b)

Google Vertex AI

c)

Azure ML Studio

d)

All of the above

10.

AutoML in cloud ML stacks allows an automobile company to:

a)

Manufacture cars automatically

b)

Train ML models without deep expertise in algorithms

c)

Control robotic arms in real-time

d)

Store structured data only

11.

Which AWS SageMaker feature allows engineers to automatically tune hyperparameters for predicting engine failure?

a)

SageMaker Studio

b)

SageMaker Ground Truth

c)

SageMaker Autopilot

d)

SageMaker Model Monitor

12.

For deploying a car defect detection model in a factory, AWS SageMaker provides:

a)

Endpoint deployment

b)

On-premise storage only

c)

Only training notebooks

d)

Manual model tuning only

13.

Historical production and sales data stored in a structured format for reporting KPIs in automobile manufacturing is an example of:

a)

Data Lake

b)

Data Warehouse

c)

NoSQL Database

d)

Object Storage

14.

Storing raw sensor data, camera images, and telemetry data from all factory equipment in its native format is best suited for:

a)

Data Warehouse

b)

Data Lake

c)

Relational Database

d)

ACID Database

15.

A key advantage of using a data lake in automobile manufacturing is:

a)

Only numeric data can be stored

b)

Supports all types of data and ML analytics

c)

Cannot integrate with cloud ML services

d)

Requires predefined schema for all data