Export to S3 in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the S3 bucket name for export.

DynamoDB

export_task = dynamodb.export_table_to_point_in_time(
    TableArn='arn:aws:dynamodb:us-west-2:123456789012:table/Books',
    S3Bucket=[1]
)

Drag options to blanks, or click blank then click option'

A'dynamodb-exports'

B'my-s3-bucket'

C'backup-bucket'

D'my-export-bucket'

Attempts:

3 left

💡 Hint

Common Mistakes

Using an incorrect or non-existent bucket name.

Forgetting to put the bucket name in quotes.

The S3Bucket parameter must be the name of the S3 bucket where the export will be stored. Here, 'dynamodb-exports' is the correct bucket name used in this example.

2fill in blank

medium

Complete the code to specify the export format as DynamoDB JSON.

DynamoDB

export_task = dynamodb.export_table_to_point_in_time(
    TableArn='arn:aws:dynamodb:us-west-2:123456789012:table/Books',
    S3Bucket='dynamodb-exports',
    ExportFormat=[1]
)

Drag options to blanks, or click blank then click option'

A'DYNAMODB_JSON'

B'CSV'

C'ION'

D'JSON'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'JSON' instead of 'DYNAMODB_JSON'.

Using unsupported formats like 'CSV' for DynamoDB export.

The ExportFormat parameter defines the format of the exported data. 'DYNAMODB_JSON' is the correct format for DynamoDB JSON export.

3fill in blank

hard

Fix the error in the export code by completing the missing parameter for export time.

DynamoDB

export_task = dynamodb.export_table_to_point_in_time(
    TableArn='arn:aws:dynamodb:us-west-2:123456789012:table/Books',
    S3Bucket='dynamodb-exports',
    ExportFormat='DYNAMODB_JSON',
    ExportTime=[1]
)

Drag options to blanks, or click blank then click option'

A'now()'

Bdatetime.datetime.now()

C'2023-01-01T00:00:00Z'

Dtime.time()

Attempts:

3 left

💡 Hint

Common Mistakes

Passing a string instead of a datetime object.

Using incorrect functions like 'now()' as a string.

The ExportTime parameter expects a datetime object representing the point in time to export. Using datetime.datetime.now() provides the current time in the correct format.

4fill in blank

hard

Fill both blanks to create an export task with the correct table ARN and S3 prefix.

DynamoDB

export_task = dynamodb.export_table_to_point_in_time(
    TableArn=[1],
    S3Bucket='dynamodb-exports',
    S3Prefix=[2],
    ExportFormat='DYNAMODB_JSON'
)

Drag options to blanks, or click blank then click option'

A'arn:aws:dynamodb:us-west-2:123456789012:table/Orders'

B'exports/orders'

C'arn:aws:dynamodb:us-west-2:123456789012:table/Customers'

D'exports/customers'

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing table ARNs and prefixes incorrectly.

Using prefixes without quotes.

The TableArn must be the ARN of the table you want to export. The S3Prefix is the folder path inside the bucket where the export files will be stored.

5fill in blank

hard

Fill all three blanks to complete the export task with table ARN, S3 bucket, and export format.

DynamoDB

export_task = dynamodb.export_table_to_point_in_time(
    TableArn=[1],
    S3Bucket=[2],
    ExportFormat=[3]
)

Drag options to blanks, or click blank then click option'

A'arn:aws:dynamodb:us-west-2:123456789012:table/Inventory'

B'dynamodb-exports'

C'DYNAMODB_JSON'

D'arn:aws:dynamodb:us-west-2:123456789012:table/Sales'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong ARNs or bucket names.

Confusing export format strings.

To export a DynamoDB table, you need to provide the table ARN, the S3 bucket name, and the export format. Here, the correct values are the Inventory table ARN, the bucket 'dynamodb-exports', and the format 'DYNAMODB_JSON'.

Practice

1. What is the main purpose of exporting a DynamoDB table to Amazon S3?

easy

A. To create a backup or analyze data without affecting the live table

B. To delete the table data permanently

C. To move data from S3 back to DynamoDB

D. To update the live data in DynamoDB automatically

Solution

1. Step 1: Understand export purpose

   Exporting saves a snapshot of the table data to S3 for backup or analysis.

2. Step 2: Confirm live data remains unchanged

   The export does not modify or delete live DynamoDB data.

3. Final Answer:

   To create a backup or analyze data without affecting the live table -> Option A

4. Quick Check:

   Export = Backup/Analysis without live change [OK]

Hint: Export means snapshot backup, not live data change [OK]

Common Mistakes:

• Thinking export deletes or moves live data
• Confusing export with import
• Assuming export updates live table

2. Which of the following is the correct AWS CLI command syntax to export a DynamoDB table named Users to an S3 bucket my-backups?

easy

A. aws dynamodb export-table-to-point-in-time --table-name Users --s3-bucket my-backups

B. aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:region:account-id:table/Users --s3-bucket my-backups

C. aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:::table/Users --s3-bucket my-backups --export-format CSV

D. aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:::table/Users --s3-bucket my-backups

Solution

1. Step 1: Identify correct ARN format

   The table ARN must include region and account ID, like arn:aws:dynamodb:region:account-id:table/Users.

2. Step 2: Check command options

   aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:region:account-id:table/Users --s3-bucket my-backups uses correct ARN format and specifies the S3 bucket properly.

3. Final Answer:

   aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:region:account-id:table/Users --s3-bucket my-backups -> Option B

4. Quick Check:

   Correct ARN format + bucket = aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:region:account-id:table/Users --s3-bucket my-backups [OK]

Hint: Table ARN needs region and account ID for export [OK]

Common Mistakes:

• Using --table-name instead of --table-arn
• Missing region or account ID in ARN
• Adding unsupported export-format option

3. Given this export command snippet:

aws dynamodb export-table-to-point-in-time \
  --table-arn arn:aws:dynamodb:us-east-1:123456789012:table/Orders \
  --s3-bucket order-backups \
  --export-format DYNAMODB_JSON

What will be the format of the exported files in the S3 bucket?

medium

A. DynamoDB JSON format files preserving data types

B. Parquet files for big data processing

C. Plain text files with no structure

D. CSV files with comma-separated values

Solution

1. Step 1: Identify export format option

   The command uses --export-format DYNAMODB_JSON, which exports data in DynamoDB JSON format.

2. Step 2: Understand DynamoDB JSON format

   This format preserves DynamoDB data types like strings, numbers, and binary in JSON structure.

3. Final Answer:

   DynamoDB JSON format files preserving data types -> Option A

4. Quick Check:

   Export format DYNAMODB_JSON = DynamoDB JSON files [OK]

Hint: DYNAMODB_JSON means JSON with DynamoDB data types [OK]

Common Mistakes:

• Assuming export creates CSV files by default
• Confusing JSON with plain text
• Expecting Parquet without specifying it

4. You run this export command but get an error:

aws dynamodb export-table-to-point-in-time \
  --table-arn arn:aws:dynamodb:us-east-1:123456789012:table/Products \
  --s3-bucket my-products-backup

The error says: AccessDeniedException. What is the most likely cause?

medium

A. The table ARN is invalid or misspelled

B. The export format is missing and required

C. The S3 bucket does not exist or you lack write permission

D. The AWS CLI version is outdated

Solution

1. Step 1: Analyze error message

   AccessDeniedException usually means permission issues on AWS resources.

2. Step 2: Check S3 bucket access

   The export writes data to the S3 bucket, so lacking write permission or bucket missing causes this error.

3. Final Answer:

   The S3 bucket does not exist or you lack write permission -> Option C

4. Quick Check:

   AccessDenied = S3 permission or bucket issue [OK]

Hint: AccessDenied usually means S3 bucket permission problem [OK]

Common Mistakes:

• Assuming ARN format error causes AccessDenied
• Thinking export format is mandatory for permission
• Blaming AWS CLI version without checking permissions

5. You want to export a DynamoDB table Sales to S3 but only for data as it was exactly at 2024-05-01T12:00:00Z. Which approach correctly achieves this?

hard

A. Create a new table snapshot manually and export it

B. Export the whole table and then filter data in S3

C. Use scan API with a filter for that timestamp and export results manually

D. Use export-table-to-point-in-time with --export-time 2024-05-01T12:00:00Z option

Solution

1. Step 1: Understand point-in-time export

   The export-table-to-point-in-time command supports --export-time to export data as it was at a specific timestamp.

2. Step 2: Compare other options

   Export the whole table and then filter data in S3 exports all data, not filtered by time. Use scan API with a filter for that timestamp and export results manually requires manual filtering and export. Create a new table snapshot manually and export it is not a valid DynamoDB feature.

3. Final Answer:

   Use export-table-to-point-in-time with --export-time 2024-05-01T12:00:00Z option -> Option D

4. Quick Check:

   Export with --export-time = point-in-time snapshot [OK]

Hint: Use --export-time to get data at specific timestamp [OK]

Common Mistakes:

• Exporting full table then filtering externally
• Trying to filter with scan API before export
• Assuming manual snapshot creation is needed