MENU
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Suggested Answer: A, D
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
15 comments · newest first
JA
Jamal
11 months ago
I’m not sure about E, GROUP BY isn’t always a priority for clustering.
DE
Delsie
11 months ago
Totally agree with A, it's all about those join predicates!
AN
Annita
12 months ago
Wait, TIMESTAMP columns? That seems a bit specific...
TR
Truman
12 months ago
I think B makes sense too, lower cardinality is key.
LE
Leonie
12 months ago
A and D are definitely the way to go!
HA
Hayley
1 year ago
Choosing cluster columns that are actively used in selective filters seems like a solid strategy. I think I saw a practice question on that!
AR
Arlene
1 year ago
I feel like using TIMESTAMP columns could be a good idea, but I'm not convinced it’s the best choice for clustering keys.
HA
Harley
1 year ago
I'm not entirely sure, but I remember something about lower cardinality columns being more cost-effective for clustering.
AL
Alyce
1 year ago
I think we should definitely consider columns that are frequently used in join predicates, right? That sounds familiar.
MA
Maira
1 year ago
I vaguely remember something about TIMESTAMP columns, but I’m not sure if they’re really the best option for clustering. I might lean towards the selective filters instead.
CA
Caprice
1 year ago
I feel like selecting cluster columns that are actively used in selective filters is a good practice. It aligns with what we discussed in class.
IR
Ira
1 year ago
I'm a bit unsure about the lower cardinality columns. I remember something about cost effectiveness, but I can't recall if it's the best choice for clustering keys.
LE
Leslie
1 year ago
I think we should definitely consider choosing columns that are frequently used in join predicates. That seems like a solid strategy.
JA
Janine
1 year ago
Okay, I think I've got a good handle on this. The key things to focus on are the limitations around querying event messages and creating Lightning record pages.
EL
Elvis
1 year ago
This question seems a bit tricky. I'm not entirely sure about the right approach, but I think defining the user stories with just enough details so the team can collaborate continuously might be the best option.