MENU
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.
Suggested Answer: D
Get Premium ACA-BigData1 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
7 comments · newest first
LI
Lili
12 months ago
Wait, can you really drop a partition like that? Sounds too easy!
NO
Noel
1 year ago
I'm pretty sure C is wrong, it's D that you need.
TE
Tequila
1 year ago
I thought truncating would work too, but I guess not!
AM
Amina
1 year ago
Definitely not A or B, those won't work for partitions.
DE
Delsie
1 year ago
You can use "alter table log drop partition(dt='20180101')" to delete the partition.
LA
Laura
1 year ago
Hmm, this looks like a tricky one. I'll need to carefully review the options and think through the data-only upgrade process.
SH
Shawna
1 year 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.