Google LookML-Developer 問題集

質問 1：
A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.
What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?
A. Fields parameter
B. Set definition
C. Hidden parameter
D. Join condition
正解：D

質問 2：
After running the Content Validator, a developer can see the error "Unknown field".
Which two changes could cause this issue? (Choose two.)
A. Explore label was changed from users to customers.
B. Field type was changed from number to string.
C. Field name was changed from id to user_id.
D. Model name was changed from e_commerce to reporting.
E. View name was changed from users to customers.
正解：B,C

質問 3：
A developer has User Specific Time Zones enabled for a Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don't occur for these fields.
How can the developer determine to which fields this parameter should be applied through SQL Runner?
A. Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
B. Open the Explore query in SQL Runner to determine which fields are converted.
C. Use the Describe feature in SQL Runner to determine which fields include time data.
D. Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
正解：D

質問 4：
A user reports an error message on an Explore: "Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum".
What should the LookML developer check for in the joined views of the Explore?
A. Symmetric_aggregates: no is not present in the Explore definition.
B. The sum measure used is defined correctly.
C. A unique primary key is defined in each view.
D. No concatenated primary keys are used.
正解：A

質問 5：
A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}.
How should developer define a new Explore for completed orders and keep all field references working correctly?
A)

B)

C)

D)

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