DEA-C01 · Question #91
A data engineer creates an AWS Glue Data Catalog table by using an AWS Glue crawler that is named Orders. The data engineer wants to add the following new partitions: s3://transactions/orders/order_da
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
A data engineer creates an AWS Glue Data Catalog table by using an AWS Glue crawler that is named Orders. The data engineer wants to add the following new partitions:
s3://transactions/orders/order_date=2023-01-01 s3://transactions/orders/order_date=2023-01-02 The data engineer must edit the metadata to include the new partitions in the table without scanning all the folders and files in the location of the table. Which data definition language (DDL) statement should the data engineer use in Amazon Athena?
Options
- AALTER TABLE Orders ADD PARTITION(order_date='2023-01-01') LOCATION
- BMSCK REPAIR TABLE Orders;
- CREPAIR TABLE Orders;
- DALTER TABLE Orders MODIFY PARTITION(order_date='2023-01-01') LOCATION
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.