NEW
Font size
WorksheetsDatabase and AWS
Total questions: 15
Worksheet time: 8mins
In an automobile factory, the engine performance logs with fixed columns like engine temperature, RPM, and oil pressure are an example of:
Structured data
Unstructured data
Semi-structured data
Metadata
Video recordings from assembly line cameras used for defect detection are considered:
Structured data
Unstructured data
Normalized data
Indexed data
Which of the following is a key difference between structured and unstructured data in car manufacturing?
Structured data cannot be stored in databases
Structured data has a predefined schema; unstructured data does not
Unstructured data is always numeric
Unstructured data is faster to query than structured data
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?
Consistency
Atomicity
Isolation
Durability
Ensuring that after updating a car's warranty record, all data remains accurate and conforms to predefined rules demonstrates:
Atomicity
Consistency
Isolation
Scalability
Multiple engineers updating the same vehicle design specification simultaneously without interference illustrates which ACID property?
Atomicity
Consistency
Isolation
Durability
Which concurrency control method would prevent two robotic arms from modifying the same assembly log simultaneously?
Two-phase commit
Locking mechanism
Load balancing
Data sharding
In automobile production databases, optimistic concurrency control is suitable when:
Multiple updates are frequent
Updates are rare and collisions are unlikely
Data is unstructured
Only read operations exist
Which of the following cloud ML stacks can be used to predict car part failures based on sensor data from the production line?
AWS SageMaker
Google Vertex AI
Azure ML Studio
All of the above
AutoML in cloud ML stacks allows an automobile company to:
Manufacture cars automatically
Train ML models without deep expertise in algorithms
Control robotic arms in real-time
Store structured data only
Which AWS SageMaker feature allows engineers to automatically tune hyperparameters for predicting engine failure?
SageMaker Studio
SageMaker Ground Truth
SageMaker Autopilot
SageMaker Model Monitor
For deploying a car defect detection model in a factory, AWS SageMaker provides:
Endpoint deployment
On-premise storage only
Only training notebooks
Manual model tuning only
Historical production and sales data stored in a structured format for reporting KPIs in automobile manufacturing is an example of:
Data Lake
Data Warehouse
NoSQL Database
Object Storage
Storing raw sensor data, camera images, and telemetry data from all factory equipment in its native format is best suited for:
Data Warehouse
Data Lake
Relational Database
ACID Database
A key advantage of using a data lake in automobile manufacturing is:
Only numeric data can be stored
Supports all types of data and ML analytics
Cannot integrate with cloud ML services
Requires predefined schema for all data
