Data Store Management Questions
Practice questions for Data Store Management topic in AWS Certified Data Engineer - Associate. 51 questions covering this domain.
A team wants to save Amazon Redshift query results in an efficient open columnar format in Amazon S3 so that Athena and EMR can analyze the data later...
A user runs an Amazon Redshift UNLOAD command to export query results to Amazon S3, but the command fails with an authorization error. Which permissio...
A team enables TTL on a DynamoDB table and expects expired items to disappear immediately. Which statement is accurate?
Several Amazon Redshift clusters need to query the same large dataset in Amazon S3 without making cluster-specific copies of that data. Which feature ...
A team wants objects to move automatically to a lower-cost Amazon S3 storage class 30 days after creation. Which feature should they use?
A user deletes an object from a versioning-enabled S3 bucket by mistake. What does Amazon S3 do at delete time?
A company adds an expiration rule to an S3 bucket today. Which objects can the rule affect?
A data warehouse team wants to query structured and semi-structured files in Amazon S3 without loading them into Amazon Redshift tables first. Which f...
A team needs to bulk load a large compressed dataset from Amazon S3 into Amazon Redshift as quickly as possible. Which approach aligns with Redshift g...
A DynamoDB table uses TTL to remove expired session records. What format must the TTL attribute use?
A data engineer needs to recover from accidental overwrite and deletion of objects in an S3 bucket. Which S3 feature should be enabled?
An analytics team needs reporting queries that join Amazon Redshift warehouse tables with live records still stored in Amazon Aurora PostgreSQL-Compat...
A Redshift team needs to combine warehouse data with live operational data that remains in Amazon RDS for PostgreSQL. Which Redshift capability should...
A regulated team must enforce that Amazon S3 objects cannot be deleted or overwritten for a fixed retention period, even by privileged users. Which S3...
Which Amazon DynamoDB feature replicates a table across multiple AWS Regions, providing fully managed multi-active read/write replication?
An analytics workload requires data files split into row groups for efficient predicate pushdown and column pruning when scanned by Athena, EMR, and R...
An OpenSearch cluster handles a mix of recent (hot) and old (cold) indices. The team wants to keep recent data on faster nodes and move older indices ...
An Amazon Redshift cluster needs to deliver consistent performance for short interactive queries while also running long ETL queries without resource ...
A data engineer wants Amazon Redshift to automatically choose distribution and sort keys based on workload patterns to optimize performance over time....
Which Amazon S3 storage class is intended for long-term archives where retrieval can take 12 hours or more and is the lowest-cost S3 tier?
Sign in to see all 51 questions
Create a free account to browse all questions — completely free during our launch phase.