最新なGoogle LookML-Developer問題集（51題）、真実試験の問題を全部にカバー！

質問 1：
A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.
What does this indicate?
A. A change has been deployed to a shared branch.
B. A change has been committed in another developer's personal branch
C. A change has been deployed to production.
D. A change has been committed in another shared branch.
正解：B

質問 2：
A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.
How should the Explore be defined to meet this requirement?
A)

B)

C)

D)

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

質問 3：
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 Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.
B. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
C. 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.
D. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
正解：A

質問 4：
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 C
B. Option A
C. Option D
D. Option B
正解：A

質問 5：
A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.
Which two actions can the LookML developer take to improve the user interface? (Choose two.)
A. Modify the business users' roles so they do not have this model in their model set.
B. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
C. Combine the Explores into just a few Explores that each join to many views.
D. Apply the fields parameter so that each Explore has fewer fields in it.
E. Apply the group_label parameter to organize the Explores under different headings.
正解：A,C