Google LookML-Developer 問題集

質問 1：
A user needs to create a report that shows a count of all orders and of orders over $100.
Which solution should the developer implement to meet these requirements?
A. An always_filter parameter
B. A front-end filter in the Explore
C. A filtered measure
D. A sql_always_where parameter
正解：B

質問 2：
A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.
Which two methods can be used to create a measure that meets these requirements? (Choose two.)

B)

C)

D)

E)

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

質問 3：
Business users report that an ephemeral derived table tile on the dashboard is slow.
Information about the dashboard includes:
The dashboard filter is linked to the user attributes.
This tile usually takes approximately 5 minutes to complete running.
Which solution should be used to improve the dashboard load time?
A. Persist the derived table.
B. Build a user attribute filter into the Explore.
C. Use index distribution_key or sort_key for this derived table.
D. Use a conditional WHERE clause for Development Mode.
正解：A

質問 4：
A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.
How should the developer meet this requirement?
A. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
B. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.
C. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.
D. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
正解：D

質問 5：
A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.
Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?
A. Copy the name of the database table in the scratch schema for the user_facts derived table.
B. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).
C. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
D. Write a subquery in the FROM clause and alias with ${user_facts}.
正解：B