Google LookML-Developer 問題集

質問 1：
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

質問 2：
The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.
Joins between the orders and users views should not incur high performance costs.
Users of this Explore will primarily be looking at data from the orders view.
Users of this Explore should only be able to see orders from the retailer "Fashion.ly".
The only field the users need from the products view is product.name.
Which LookML should the developer use?
A)

B)

C)

D)

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

質問 3：
Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.
Which parameter should be added to the country dimension to create a connection to this other associated Explore?
A. link
B. tags
C. url_encode
D. drill_fields
正解：A

質問 4：
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

質問 5：
A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.

Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?
A. Change the orders_rollup view reference to the literal table name from the database's scratch schema.
B. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
D. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
正解：C