Google LookML-Developer 問題集

質問 1：
The code below shows a view order_items with its measures total_revenue and user_count

Which code correctly represents a new measure that calculates average revenue per user?
A)

B)

C)

D)

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 2：
A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need to use these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.
Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?
A)

B)

C)

D)

A. Option A
B. Option C
C. Option D
D. Option B
正解：A

質問 3：
Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.
Which access filter should the developer use to meet this requirement?
A)

B)

C)

D)

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 4：
A developer needs to model out LookML to convert existing reports into Looker. The existing reports are:
Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices.
Report 2: A report with order and order_items data, which finds the order with the largest total number of products ordered.
Report 3: A report with data on every product, whether or not it has been ordered.
Each database table used is updated in real time as orders are made.
How should the developer construct an Explore using the order_items view as the base view?
A. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
B. Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.
C. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
D. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.
正解：B

質問 5：
Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.
Which three LookML options should a developer use to curate the business user's experience? (Choose three.)
A. Create a separate project for each business unit containing only the fields that the unit needs.
B. Add a group_label parameter to relevant fields to organize them into logical categories.
C. Use the hidden parameter to remove irrelevant fields from the Explore.
D. Add a description parameter to each field with context so that users can search key terms.
E. Use a derived table to show only the relevant fields.
正解：B,D,E