Google Cloud Associate Data Practitioner — Question 70

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because defining a new measure to calculate the profit margin directly utilizes existing revenue and cost fields, allowing for real-time analysis. The other options either involve pre-calculation (A), categorization (C), or filtering (D), which do not provide the most efficient and immediate solution for visualizing profit margins across all products.