Google LookML-Developer Exam Practice Test Instant Access

Question 1

A developer wants to create a new Explore based on the order_items view. The developer creates an Explore in the ecommerce model file with the following definition:

explore: order_items {}

After saving and validations, the developer receives this LookML validator error:

Inaccessible view ''inventory_items'', ''inventory_items'' is not accessible in explore'' ''order_items''. Check for typos and missing joins in explore ''order_items''.

What caused this error to appear?

AA field in the order_items view references a field in the inventory_items view.

BA field in the inventory_items view references a field in the order_items view.

CThere is an Explore named inventory_items which references the order_items view.

DThere is another Explore named order_items which references the inventory_items view.

Answer : A

Question 2

A LookML developer creates an Explore that joins two views. The base view has information about users' interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.

What should the developer add to the Explore in the model to achieve these requirements?

AA filtered measure

BThe hidden parameter

CThe sql_always_where parameter

DA relationship definition

Answer : D

Question 3

A developer needs to build a new dimension that offers an age-based cohort representation of users.

Which LookML code should the developer use to meet the requirement?

AOption A

BOption B

COption C

DOption D

Answer : B

Question 4

After validating LookML code, a developer receives the following error message:

''Unknown or Inaccessible Field users.name''

What is causing this error?

AThere is a missing join.

BThe field is set to ''hidden''.

CThe join relationship is incorrect.

DThe field uses incorrect SQL syntax.

Answer : A

Question 5

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

AOption A

BOption B

COption C

DOption D

EOption E

Answer : A, C

Question 6

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?

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

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

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

DCreate native derived tables using transactions as the explore_source.

Answer : D

Question 7

A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should the developer take?

AJoin order_items and inventory_items in a derived table.

BJoin order_items and inventory_items in the same Explore.

CCopy the cost definition from inventory_items to the order_items view file.

DAdd the following to the order_items view file: include: ''inventory_items,view.lkml''

Answer : A

Google LookML-Developer Looker LookML Developer Exam Practice Test