nerdexam
AmazonAmazon

DAS-C01 · Question #188

DAS-C01 Question #188: Real Exam Question with Answer & Explanation

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

Storage and Data Management

Question

A company is using an AWS Lambda function to run Amazon Athena queries against a cross- account AWS Glue Data Catalog. A query returns the following error: HIVE_METASTORE_ERROR The error message states that the response payload size exceeds the maximum allowed size. The queried table is already partitioned, and the data is stored in an Amazon S3 bucket in the Apache Hive partition format. Which solution will resolve this error?

Options

  • AModify the Lambda function to upload the query response payload as an object into the S3 bucket.
  • BRun the MSCK REPAIR TABLE command on the queried table.
  • CCreate a separate folder in the S3 bucket. Move the data files that need to be queried into that folder.
  • DCheck the schema of the queried table for any characters that Athena does not support. Replace any

Unlock DAS-C01 to see the answer

You've previewed enough free DAS-C01 questions. Unlock DAS-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

#Athena query errors#Glue Data Catalog limits#Lambda data handling#S3 integration
Full DAS-C01 PracticeBrowse All DAS-C01 Questions