MENU
You need to populate a fact table with the corresponding surrogate keys from each dimension table
Which two steps accomplish this task? (Choose two.)
Choose 2 answers
Suggested Answer: B
Get Premium HCE-5920 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
35 comments · newest first
SH
Shanice
10 months ago
C doesn’t sound right to me, I’d go with A and B.
LU
Luke
11 months ago
I agree with B, but A seems a bit iffy.
LE
Leonardo
11 months ago
Wait, is D really not an option? That seems off.
GA
Galen
11 months ago
I think A and B are the right choices.
DU
Dulce
11 months ago
Definitely B and C for sure!
JA
Janey
12 months ago
I definitely recall that we need to look up the surrogate keys, so 'Dimension lookup/update' seems right, but I can't remember the second step clearly.
WY
Wynell
12 months ago
I’m a bit confused; I thought 'Select values' was important, but now I’m not so sure if it fits here.
AL
Alonzo
12 months ago
I remember practicing a similar question, and I feel like the 'Combination lookup/update' step might be correct too.
CA
Carri
1 year ago
I think the 'Dimension lookup/update' step is definitely one of the answers, but I'm not sure about the second one.
MA
Maryln
1 year ago
I think the key here is to focus on the dimension tables and how to link them to the fact table. The 'Dimension lookup/update' step seems like a no-brainer, but I'm not 100% sure about the other one.
CR
Crista
1 year ago
I'm a bit confused on this one. There are a few different steps mentioned, and I'm not sure which two are the right ones. I'll have to re-read the question carefully.
JO
Johnetta
1 year ago
Okay, let's see. I think the 'Dimension lookup/update' step is definitely one of the key steps here. But I'm not sure about the other one - maybe the 'Combination lookup/update' step?
CA
Carmen
1 year ago
Hmm, this looks like a tricky one. I'll need to think carefully about the steps involved in populating a fact table from dimension tables.
CA
Casie
1 year ago
I've got this! The two steps are the 'Dimension lookup/update' and the 'Combination lookup/update'. Easy peasy.
MI
Michal
1 year ago
I'm a bit unsure about this one. The wording is a bit vague, so I'll need to really analyze the options to figure out the best answer.
PE
Peggie
1 year ago
Okay, let's see. We've got RDS farms, Instant Clone desktops, and persistent desktops. I bet the key is figuring out the unique requirements for each of those.
JO
Jolene
1 year ago
The Transactions dashboard might have the information we need, but I'm not confident that's the right choice here.
CA
Carmela
1 year ago
Wait, did they just say 'Choose two'? I guess that rules out the 'Filter rows' step. Bummer, I was feeling confident about that one.
NO
Norah
1 year ago
B) the Dimension lookup/update' step
HA
Haley
1 year ago
A) the 'Combination lookup/update' step
AL
Alonzo
1 year ago
B) the Dimension lookup/update' step
FE
Felicitas
1 year ago
A) the 'Combination lookup/update' step
LE
Lenna
1 year ago
This is too easy. 'Dimension lookup/update' and 'Filter rows' all the way. Gotta make sure you're getting the right data in there!
LI
Lindy
1 year ago
'Filter rows' is also important to ensure only the necessary data is being populated in the fact table.
CH
Cherelle
1 year ago
I agree, 'Dimension lookup/update' is crucial for getting the correct surrogate keys.
CL
Clarence
1 year ago
I'm going with 'Select values' and 'Dimension lookup/update'. Gotta grab those keys from the dimensions and then populate the fact table. Easy peasy!
NO
Novella
1 year ago
Definitely the 'Combination lookup/update' step. You need to combine the data from the fact table with the dimension tables to get those keys.
EL
Elliot
1 year ago
B) the Dimension lookup/update' step
MA
Mari
1 year ago
A) the 'Combination lookup/update' step
DA
Dannette
1 year ago
I believe the 'Select values' step could also be helpful in populating the fact table.
MA
Maryann
1 year ago
Hmm, I think the 'Dimension lookup/update' step is crucial here. You need to get those surrogate keys from the dimension tables, right?
AL
Aleisha
1 year ago
User 2: Definitely, that step helps populate the fact table with the correct keys.
VI
Viva
1 year ago
User 1: I agree, the 'Dimension lookup/update' step is important for getting the surrogate keys.
OR
Ora
2 years ago
I agree with Claribel, the 'Combination lookup/update' step is also crucial for this task.
CL
Claribel
2 years ago
I think the 'Dimension lookup/update' step is important for populating the fact table.