Alibaba ACA-BigData1 Exam - Topic 4 Question 46 Discussion

Actual exam question for Alibaba's ACA-BigData1 exam

Question #: 46
Topic #: 4

A Log table named log in MaxCompute is a partition table, and the partition key is dt. Anew partition is created daily to store the new data of that day. Now we have one month's data, starting from dt='20180101' to dt='20180131', and we may use ________ to delete the data on 20180101.

Adelete from log where dt='20180101'

Btruncate table where dt='20180101'

Cdrop partition log (dt='20180101')

Dalter table log drop partition(dt='20180101')

Show Suggested Answer

Suggested Answer: D

by Kati at May 04, 2022, 09:47 AM

Limited Time Offer

25%

Off

Get Premium ACA-BigData1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lili

5 months ago

Wait, can you really drop a partition like that? Sounds too easy!

upvoted 0 times

...

Noel

5 months ago

I'm pretty sure C is wrong, it's D that you need.

upvoted 0 times

...

Tequila

5 months ago

I thought truncating would work too, but I guess not!

upvoted 0 times

...

Amina

5 months ago

Definitely not A or B, those won't work for partitions.

upvoted 0 times

...

Delsie

5 months ago

You can use "alter table log drop partition(dt='20180101')" to delete the partition.

upvoted 0 times

...

Laura

6 months ago

Hmm, this looks like a tricky one. I'll need to carefully review the options and think through the data-only upgrade process.

upvoted 0 times

...

Shawna

6 months ago

Accurate supplier reporting, prevention of incorrect returns, prevention of duplicate receipts, and prevention of duplicate invoices - those seem like the key benefits to me.

upvoted 0 times

...