Microsoft Dynamics 365 Customer Insights – Data — Question 29

The marketing analytics team at your organization uses Dynamics 365 Customer Insights – Data. They need to quickly find metrics for marketing stakeholders in order to help stakeholders make decisions that impact digital advertising campaigns.

• Loyalty data is stored in a table named “Loyalty” and has been unified.
• The top tier is “Gold” and the column that holds tier information as string values is “LTier”.
• There are also columns for Street, City, and State address attributes.

The marketing analytics team member receives a question from a stakeholder on Microsoft Teams. The stakeholder asks, “How many top tier loyalty members are there in Seattle, Washington?”

You need to provide guidance on how to get a quick and accurate answer.

What should you recommend?

Answer options

• A. Use the Measures feature to create a measure with function Count, an expression for LTier column Value = Gold, and a filter for *City = Seattle.
• B. Use the Discovery page and type “Create a measure for Gold tier Loyalty Members in the City of Seattle in the State of Washington” into the prompt box.
• C. Use the Discovery page and type the question “In the Loyalty table how many Gold members are there in the LTier column with Seattle as City and Washington as State?” into the prompt box.
• D. Use the Discovery page and paste the question “How many top tier loyalty members are there in Seattle, Washington?” into the prompt box.

Correct answer: C

Explanation

Option C is correct because it directly addresses the query by specifying the relevant table and criteria. Option A is incorrect as it involves creating a measure rather than querying directly. Option B suggests a vague prompt that may not yield a specific answer, while Option D, although related, does not specify the necessary details to retrieve the exact count from the data.