Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Alibaba ACA-BigData1 Exam - Topic 4 Question 46 Discussion

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.
D) alter table log drop partition(dt='20180101')
A) delete from log where dt='20180101'
B) truncate table where dt='20180101'
C) drop partition log (dt='20180101')

Alibaba ACA-BigData1 Exam - Topic 4 Question 46 Discussion

Actual exam question for Alibaba's ACA-BigData1 exam
Question #: 46
Topic #: 4
[All ACA-BigData1 Questions]

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.

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Lili
9 months ago
Wait, can you really drop a partition like that? Sounds too easy!
upvoted 0 times
...
Noel
9 months ago
I'm pretty sure C is wrong, it's D that you need.
upvoted 0 times
...
Tequila
9 months ago
I thought truncating would work too, but I guess not!
upvoted 0 times
...
Amina
9 months ago
Definitely not A or B, those won't work for partitions.
upvoted 0 times
...
Delsie
9 months ago
You can use "alter table log drop partition(dt='20180101')" to delete the partition.
upvoted 0 times
...
Laura
10 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
10 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
...

Save Cancel