nerdexam
AmazonAmazon

DEA-C01 · Question #145

DEA-C01 Question #145: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.

Data Ingestion and Transformation

Question

A data engineer is using an AWS Glue crawler to catalog data that is in an Amazon S3 bucket. The S3 bucket contains both .csv and json files. The data engineer configured the crawler to exclude the .json files from the catalog. When the data engineer runs queries in Amazon Athena, the queries also process the excluded .json files. The data engineer wants to resolve this issue. The data engineer needs a solution that will not affect access requirements for the .csv files in the source S3 bucket. Which solution will meet this requirement with the SHORTEST query times?

Options

  • AAdjust the AWS Glue crawler settings to ensure that the AWS Glue crawler also excludes .json
  • BUse the Athena console to ensure the Athena queries also exclude the .json files.
  • CRelocate the .json files to a different path within the S3 bucket.
  • DUse S3 bucket policies to block access to the .json files.

Unlock DEA-C01 to see the answer

You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#AWS Glue#Amazon Athena#Amazon S3#Query Optimization
Full DEA-C01 PracticeBrowse All DEA-C01 Questions