Exam Associate-Data-Practitioner Topic 2 Question 27 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 27
Topic #: 2

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.

Suggested Answer: B Vote an answer

Defining a new measure in LookML to calculate the profit margin using the existing revenue and cost fields is the most efficient and straightforward solution. This approach allows you to dynamically compute the profit margin directly within your Looker Explores and dashboards without needing to pre-calculate or create additional tables. The measure can be defined using LookML syntax, such as:
measure: profit_margin {
type: number
sql: (revenue - cost) / revenue ;;
value_format: "0.0%"
}
This method is quick to implement and integrates seamlessly into your existing Looker model, enabling accurate visualization of profit margins across your products.

by Tony at Feb 06, 2026, 11:14 AM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business