LookML-Developer試験無料問題集（51題）「Google Looker 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 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.

C. 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.

D. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

正解：C 解答を投票する

出題：2

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.
How can the LookML developer model these requirements and minimize the amount of code rewriting?

A. Add measures to the transactions view of type: number to apply the required functions.

B. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

C. Create native derived tables using transactions as the explore_source.

D. Create a constant for each measure so it can be reused across other areas of the LookML project.

正解：C 解答を投票する

出題：3

A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.
How can the developer use SQL Runner to troubleshoot quickly?

A. Create a query that concatenates two columns to create a compound primary key.

B. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.

C. Create a query that selects all the fields from the table, and sort by primary key.

D. Create a query that selects the primary key from the base view, and look for duplicates.

正解：A 解答を投票する

出題：4

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. tags

B. url_encode

C. link

D. drill_fields

正解：C 解答を投票する

出題：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. Use the hidden parameter to remove irrelevant fields from the Explore.

B. Create a separate project for each business unit containing only the fields that the unit needs.

C. Add a group_label parameter to relevant fields to organize them into logical categories.

D. Use a derived table to show only the relevant fields.

E. Add a description parameter to each field with context so that users can search key terms.

正解：C,D,E 解答を投票する

出題：6

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 committed in another shared branch.

B. A change has been deployed to production.

C. A change has been deployed to a shared branch.

D. A change has been committed in another developer's personal branch

正解：D 解答を投票する

LookML-Developer試験無料問題集「Google Looker LookML Developer 認定」