nerdexam
Amazon

DEA-C01 · Question #46

A data engineer needs to use an Amazon QuickSight dashboard that is based on Amazon Athena queries on data that is stored in an Amazon S3 bucket. When the data engineer connects to the QuickSight dash

The correct answer is C. QuickSight does not have access to the S3 bucket. D. QuickSight does not have access to decrypt S3 data.. Insufficient permissions errors when Amazon QuickSight queries Athena data in S3 typically stem from QuickSight lacking access to the S3 bucket or lacking decryption permissions for encrypted S3 data.

Data Security and Governance

Question

A data engineer needs to use an Amazon QuickSight dashboard that is based on Amazon Athena queries on data that is stored in an Amazon S3 bucket. When the data engineer connects to the QuickSight dashboard, the data engineer receives an error message that indicates insufficient permissions. Which factors could cause to the permissions-related errors? (Choose two.)

Options

  • AThere is no connection between QuickSight and Athena.
  • BThe Athena tables are not cataloged.
  • CQuickSight does not have access to the S3 bucket.
  • DQuickSight does not have access to decrypt S3 data.
  • EThere is no IAM role assigned to QuickSight.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    19% (5)
  • C
    70% (19)
  • E
    7% (2)

Why each option

Insufficient permissions errors when Amazon QuickSight queries Athena data in S3 typically stem from QuickSight lacking access to the S3 bucket or lacking decryption permissions for encrypted S3 data.

AThere is no connection between QuickSight and Athena.

If there were no connection between QuickSight and Athena, the error would likely be a connection failure or resource not found, not specifically an 'insufficient permissions' error related to data access.

BThe Athena tables are not cataloged.

If Athena tables were not cataloged, the query would fail due to unknown schema or table not found, rather than a permissions error on the underlying data itself.

CQuickSight does not have access to the S3 bucket.Correct

Amazon QuickSight, or the underlying service role it uses for Amazon Athena, must have read access permissions to the specific Amazon S3 bucket where the data files are stored. Without this permission, Athena cannot read the data, leading to an 'insufficient permissions' error.

DQuickSight does not have access to decrypt S3 data.Correct

If the data in the S3 bucket is encrypted (e.g., using SSE-KMS), the QuickSight execution role (or the role Athena assumes) must be granted permissions to decrypt the data using the associated AWS KMS key. Lack of decryption permissions will also result in access denied errors.

EThere is no IAM role assigned to QuickSight.

QuickSight operates with service-linked roles or explicitly configured IAM roles; if no role was assigned, QuickSight itself might not function, but the error specifically points to data access permissions rather than QuickSight's operational status.

Concept tested: Amazon QuickSight, Athena, S3, and KMS permissions

Source: https://docs.aws.amazon.com/quicksight/latest/user/s3-permission-policy.html

Topics

#QuickSight Permissions#Athena Permissions#S3 Access Control#KMS Decryption

Community Discussion

No community discussion yet for this question.

Full DEA-C01 Practice