SAP Exam C_C4H630_34 Topic 1 Question 5 Discussion

Actual exam question for SAP's C_C4H630_34 exam

Question #: 5
Topic #: 1

[All C_C4H630_34 Questions]

Which query syntax is correct when searching for users in SAP Customer Data Platform?

ASelect * from accounts where profile. primaryEmail = 'someuseremail@emaildomain.com'

Bselect * from profile where profile.email = 'someuseremail@emaildomain.com'

Cselect * from contextualProfile where primaryEmail = 'someuseremail@emaildomain.com'

Dselect * from profile where attribute.primaryEmail = 'someuseremail@emaildomain.com'

Show Suggested Answer

Suggested Answer: A

by Gilma at Apr 09, 2024, 10:20 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Evangelina

11 days ago

Okay, let's think this through step-by-step. We're looking for a user's email address, right? So the table that would most likely contain that information is `contextualProfile`. Therefore, C is the correct answer. Unless, of course, the exam writers are trying to trick us...

upvoted 0 times

...

Sylvia

13 days ago

Haha, yeah, these SQL queries are no joke. It's like trying to navigate a maze blindfolded sometimes. I'm leaning towards C, but I'm keeping an open mind here.

upvoted 0 times

...

Eun

14 days ago

But wait, what about option D? It mentions `attribute.primaryEmail`, which sounds like it could be the right way to access the email address. This is making my head spin!

upvoted 0 times

...

Arlette

15 days ago

Hmm, I'm not so sure. Option B looks like it could be correct too. The `profile` table might have the email address we're looking for. I'd have to double-check the documentation to be sure.

upvoted 0 times

...

Peggie

17 days ago

Yeah, I agree with Lai. The instructions specifically mention 'searching for users', and the `contextualProfile` table is where that data is stored. Option C is the way to go.

upvoted 0 times

...

Lai

19 days ago

Whoa, this is a tricky one! I've been studying up on the SAP Customer Data Platform, and I'm pretty sure the correct answer is C. We need to search the `contextualProfile` table, not the `profile` table directly.

upvoted 0 times

...