Question 1mediummultiple choice
Read the full Data Operations and Support explanation →DEA-C01 Data Operations and Support • Complete Question Bank
Complete DEA-C01 Data Operations and Support question bank — all 0 questions with answers and detailed explanations.
Refer to the exhibit.
```json
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject",
"s3:DeleteObject"
],
"Resource": "arn:aws:s3:::data-lake-bucket/*",
"Condition": {
"StringEquals": {
"s3:x-amz-server-side-encryption": "AES256"
}
}
},
{
"Effect": "Deny",
"Action": "s3:PutObject",
"Resource": "arn:aws:s3:::data-lake-bucket/*",
"Condition": {
"StringNotEquals": {
"s3:x-amz-server-side-encryption": "aws:kms"
}
}
}
]
}
```Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag a concept onto its matching description — or click a concept then click the description.
General-purpose, good compression ratio
Fast compression/decompression for real-time
Columnar storage with built-in compression
Optimized for Hive and large-scale analytics
High compression ratio, slower speed
Drag a concept onto its matching description — or click a concept then click the description.
Serverless SQL query on S3
Business intelligence and dashboards
Data lake setup and access control
Real-time SQL on streaming data
Query data in S3 from Redshift
Refer to the exhibit.
```
[
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:ListBucket"
],
"Resource": [
"arn:aws:s3:::example-bucket",
"arn:aws:s3:::example-bucket/*"
]
}
]
```Refer to the exhibit.
```
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"lambda:InvokeFunction"
],
"Resource": [
"arn:aws:lambda:us-east-1:123456789012:function:my-function"
]
},
{
"Effect": "Allow",
"Action": [
"kinesis:DescribeStream",
"kinesis:GetRecords",
"kinesis:GetShardIterator",
"kinesis:ListShards"
],
"Resource": [
"arn:aws:kinesis:us-east-1:123456789012:stream/my-stream"
]
}
]
}
```{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:PutObject",
"s3:GetObject"
],
"Resource": "arn:aws:s3:::my-bucket/*",
"Condition": {
"IpAddress": {
"aws:SourceIp": "10.0.0.0/16"
}
}
}
]
}CloudWatch Logs Insights query: fields @timestamp, @message | filter @message like /ERROR/ | sort @timestamp desc | limit 20
Refer to the exhibit.
```
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::data-lake-bucket/*"
},
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": "arn:aws:s3:::data-lake-bucket"
},
{
"Effect": "Allow",
"Action": [
"kms:Decrypt"
],
"Resource": "arn:aws:kms:us-east-1:123456789012:key/abc123"
}
]
}
```Refer to the exhibit.
```
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject",
"s3:DeleteObject"
],
"Resource": "arn:aws:s3:::data-bucket/*"
},
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": "arn:aws:s3:::data-bucket"
},
{
"Effect": "Deny",
"Action": "s3:*",
"Resource": "arn:aws:s3:::data-bucket/confidential/*",
"Condition": {
"StringNotEquals": {
"aws:PrincipalTag/role": "admin"
}
}
}
]
}
```{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject"
],
"Resource": "arn:aws:s3:::my-bucket/*",
"Condition": {
"StringEquals": {
"s3:ExistingObjectTag/classification": "public"
}
}
},
{
"Effect": "Deny",
"Action": "s3:*",
"Resource": "arn:aws:s3:::my-bucket/*",
"Condition": {
"StringNotEquals": {
"aws:SourceAccount": "123456789012"
}
}
}
]
}2024-01-15T10:30:00Z ERROR 123456789012 i-0abcd1234efgh5678 {"errorCode": "InvalidS3ObjectException", "errorMessage": "The specified S3 object is not a valid Parquet file."}Resources:
MyTable:
Type: AWS::DynamoDB::Table
Properties:
TableName: !Ref TableName
AttributeDefinitions:
- AttributeName: pk
AttributeType: S
- AttributeName: sk
AttributeType: S
KeySchema:
- AttributeName: pk
KeyType: HASH
- AttributeName: sk
KeyType: RANGE
BillingMode: PAY_PER_REQUEST
PointInTimeRecoverySpecification:
PointInTimeRecoveryEnabled: true
SSESpecification:
SSEEnabled: trueRefer to the exhibit.
IAM Policy:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::example-bucket/*"
},
{
"Effect": "Allow",
"Action": "s3:ListBucket",
"Resource": "arn:aws:s3:::example-bucket"
}
]
}Refer to the exhibit. CloudWatch Logs log group: /aws/glue/jobs/error Log stream: job-run-12345 Log event: 2024-01-15T10:30:45.000Z ERROR [Executor task launch worker for task 0.0 in stage 0.0 (TID 0)] : java.lang.OutOfMemoryError: Java heap space 2024-01-15T10:30:45.001Z ERROR [Executor task launch worker for task 0.0 in stage 0.0 (TID 0)] : at org.apache.spark.sql.execution.datasources.FileFormatWriter$WriteTask.execute(FileFormatWriter.scala:247)
Refer to the exhibit.
```
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::example-bucket/*"
},
{
"Effect": "Deny",
"Action": "s3:PutObject",
"Resource": "arn:aws:s3:::example-bucket/secrets/*"
}
]
}
```Refer to the exhibit.
IAM Policy:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::example-bucket/*"
},
{
"Effect": "Allow",
"Action": "s3:ListBucket",
"Resource": "arn:aws:s3:::example-bucket"
}
]
}Refer to the exhibit. CloudWatch Logs Log Group: /aws/lambda/my-data-processor Log Stream: 2025/01/15/[$LATEST]123456789abc Log event: 2025-01-15T10:00:00.000Z 123456789abc ERROR Task timed out after 30.00 seconds 2025-01-15T10:00:00.000Z 123456789abc END RequestId: f1234567 2025-01-15T10:00:00.000Z 123456789abc REPORT RequestId: f1234567 Duration: 30001.23 ms Billed Duration: 30000 ms Memory Size: 128 MB Max Memory Used: 64 MB
Refer to the exhibit.
CloudFormation template snippet:
"MyTable": {
"Type": "AWS::DynamoDB::Table",
"Properties": {
"TableName": "Orders",
"AttributeDefinitions": [
{"AttributeName": "OrderID", "AttributeType": "S"}
],
"KeySchema": [
{"AttributeName": "OrderID", "KeyType": "HASH"}
],
"ProvisionedThroughput": {
"ReadCapacityUnits": 5,
"WriteCapacityUnits": 5
}
}
}Refer to the exhibit.
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": [
"arn:aws:s3:::example-bucket/*"
]
},
{
"Effect": "Allow",
"Action": [
"glue:StartJobRun",
"glue:GetJobRun"
],
"Resource": "*"
}
]
}Refer to the exhibit. 2024-03-15 10:23:45,678 ERROR [main] com.amazonaws.services.s3.AmazonS3Client : Unable to execute HTTP request: Connect to my-bucket.s3.us-west-2.amazonaws.com:443 [my-bucket.s3.us-west-2.amazonaws.com/10.0.0.1] failed: connect timed out
Refer to the exhibit.
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "s3:GetObject",
"Resource": "arn:aws:s3:::example-bucket/*",
"Condition": {
"IpAddress": {
"aws:SourceIp": "10.0.0.0/8"
}
}
}
]
}Refer to the exhibit.
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "iam:PassRole",
"Resource": "arn:aws:iam::123456789012:role/EMR_DefaultRole"
},
{
"Effect": "Allow",
"Action": "elasticmapreduce:*",
"Resource": "*"
}
]
}{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "s3:GetObject",
"Resource": "arn:aws:s3:::example-bucket/*"
},
{
"Effect": "Deny",
"Action": "s3:GetObject",
"Resource": "arn:aws:s3:::example-bucket/confidential/*"
}
]
}SELECT COUNT(*) FROM my_table WHERE ds = '2023-01-01'; Query results: 1073741824 bytes scanned SELECT COUNT(*) FROM my_table WHERE ds = '2023-01-01' AND product_id = 12345; Query results: 1073741824 bytes scanned
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::data-lake-bucket/*"
},
{
"Effect": "Deny",
"Action": "s3:*",
"Resource": "arn:aws:s3:::data-lake-bucket/confidential/*"
}
]
}2024-05-10T12:00:00Z ERROR 1234567890 Job failed: java.lang.OutOfMemoryError: Java heap space 2024-05-10T12:01:00Z INFO 1234567890 Job terminated with exit code 1
Refer to the exhibit.
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "s3:PutObject",
"Resource": "arn:aws:s3:::my-bucket/*",
"Condition": {
"StringEquals": {
"s3:x-amz-server-side-encryption": "AES256"
}
}
}
]
}Refer to the exhibit.
IAM Policy:
```json
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject",
"s3:DeleteObject"
],
"Resource": "arn:aws:s3:::data-lake-bucket/*"
},
{
"Effect": "Deny",
"Action": "s3:*",
"Resource": "arn:aws:s3:::data-lake-bucket/confidential/*"
}
]
}
```
A user with this policy tries to upload an object to `s3://data-lake-bucket/confidential/report.pdf`. What will happen?Error log from AWS Glue job: 2024-01-01 12:00:00 ERROR: An error occurred while calling o123.pyWriteDynamicFrame. Error: org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 1.0 failed 4 times, most recent failure: Lost task 0.3 in stage 1.0 (TID 123, ip-10-0-0-123.ec2.internal): ExecutorLostFailure (executor 2 exited caused by one of the running tasks) Reason: Container killed by YARN for exceeding memory limits. 10.0 GB of 10.0 GB physical memory used. Consider boosting spark.executor.memory.
IAM policy attached to an IAM role used by AWS Glue:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject"
],
"Resource": "arn:aws:s3:::my-bucket/*"
},
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": "arn:aws:s3:::my-bucket"
},
{
"Effect": "Allow",
"Action": [
"glue:Get*",
"glue:BatchGet*"
],
"Resource": "*"
}
]
}Refer to the exhibit.
IAM Policy JSON:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:GetObject",
"s3:PutObject",
"s3:DeleteObject"
],
"Resource": "arn:aws:s3:::data-lake-bucket/*"
},
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": "arn:aws:s3:::data-lake-bucket"
},
{
"Effect": "Allow",
"Action": [
"glue:StartJobRun"
],
"Resource": "*"
}
]
}