Free Access Google.LookML-Developer.v2022-02-08.q17 Practice Test (Page 2)

Question 1

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?
A)

A.Option C

B.Option A

C.Option D

D.Option B

Question 2

A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.
Which LookML parameter should the developer use to meet this requirement?

A.sql_always_where

B.access_grant

C.always_filter

D.access_filter

Question 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 selects all the fields from the table, and sort by primary key.

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

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

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

Question 4

After validating LookML code, a developer receives the following error message:
"Unknown or Inaccessible Field users.name"
What is causing this error?

A.The join relationship is incorrect.

B.There is a missing join.

C.The field uses incorrect SQL syntax.

D.The field is set to "hidden".

Question 5

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)