To retrieve users who have subscribed to the "Fitness Newsletter" from email accounts, you need to query theemailAccountstable and filter based on the subscription status. The correct query is:
D:SELECT * FROM emailAccounts WHERE subscriptions.<Fitness>.email.isSubscribed=trueThis query checks if the user is subscribed (isSubscribed=true) to the "Fitness" newsletter specifically for email accounts.
The other options are incorrect:
A:hasFullAccount=trueis unnecessary because the query is focused on email accounts, not full accounts.
B: AddinghasFullAccount=trueis redundant and incorrect for this use case.
C: QueryingfullAccountsis irrelevant because the requirement specifies retrieving users fromemail accounts, not full accounts.
SAP Customer Data Cloud References:
SAP Customer Data Cloud - Query Language.
Subscription Management.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit