AWS Data Engineering - Storing Data

What type of storage is provided by Amazon S3?

• Block storage

• File storage

• Object storage

• Cache storage

Which AWS service is primarily used for data warehousing?

• Amazon S3

• Amazon Redshift

• Amazon DynamoDB

• Amazon RDS

What does the storage class S3 Intelligent-Tiering provide?

• High performance for frequently accessed data

• Automatic cost savings for data with unknown or changing access patterns

• Low-cost storage for archival data

• High durability for frequently accessed data

Which AWS service integrates with Amazon Redshift to provide in-place querying for data stored in Amazon S3?

• AWS Glue

• Amazon Athena

• Redshift Spectrum

• AWS Lambda

How does Amazon Redshift handle query execution for a provisioned cluster with multiple compute nodes?

• The compute nodes independently handle all queries without coordination

• The leader node coordinates the parallel processing of the query plans with the compute nodes

• Queries are executed sequentially by the leader node

• Compute nodes only handle storage and do not participate in query execution

What does the “Lake Formation” service primarily help with in AWS?

• Creating and managing S3 buckets

• Automating elements of data lake creation and management

• Providing compute resources for data processing

• Offering storage for structured data

What distinguishes an ELT pipeline from an ETL pipeline?

• ELT pipelines transform data before loading it into storage

• ELT pipelines do not transform data before loading it into storage

• ELT pipelines use only Amazon Redshift

• ELT pipelines cannot handle unstructured data

In a modern data architecture, what is the role of the catalog layer?

• To store raw data

• To process and transform data

• To store business and technical metadata about datasets

• To provide low-cost archival storage

What is the main advantage of using Amazon S3 Glacier for data storage?

• High performance

• Immediate data retrieval

• Low-cost archival storage

• Real-time data processing

What does the ELT process stand for?

• Extract, Load, Transform

• Extract, Load, Transfer

• Extract, Locate, Transform

• Extract, Label, Transfer