Exam Associate Data Practitioner topic 1 question 53 discussion

Actual exam question from Google's Associate Data Practitioner

Question #: 53
Topic #: 1

[All Associate Data Practitioner Questions]

Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company’s products in your Looker Explores and dashboards. You need to implement a solution quickly and efficiently. What should you do?

A. Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
B. Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
C. Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
D. Apply a filter to only show products with a positive profit margin.

Show Suggested Answer

Suggested Answer: B 🗳️

by n2183712847 at March 6, 2025, 5:49 a.m.

Comments

Submit Cancel

n2183712847

1 month, 4 weeks ago

Selected Answer: B

The best option is B. Define a new measure. Option B is best: Measures are for on-the-fly calculations in Looker, quick & efficient. Option A (Derived table) is incorrect: Slower, pre-calculation not needed. Option C (New dimension) is incorrect: Dimensions are for categories, not metrics. Option D (Apply filter) is incorrect: Filter restricts data, doesn't calculate margin. Therefore, Option B, new measure, is the fastest, most efficient LookML solution.

upvoted 1 times

...

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam

Exam Associate Data Practitioner topic 1 question 53 discussion

Comments

n2183712847

SY0-701