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

LookML-Developer Exam Question 1

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 counts how many occurrences of the primary key value are in the base view, and sort by count.

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

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

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

LookML-Developer Exam Question 2

A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:

A.Remove everything between "<<<<<< HEAD" and "======", and ">>>>>> branch 'master'"

B.Remove everything between "<<<<<< HEAD" and ">>>>>> branch 'master'"

C.Remove "<<<<<< HEAD", "======", and everything following "======"

D.Remove "<<<<<< HEAD", "======", and ">>>>>> branch 'master'"

LookML-Developer Exam Question 3

A developer defines the following measure in the order_items view:

The code must validate without errors.
Which action should the developer take?

A.Add the following to the order_items view file: include: "inventory_items,view.lkml"

B.Join order_items and inventory_items in a derived table.

C.Join order_items and inventory_items in the same Explore.

D.Copy the cost definition from inventory_items to the order_items view file.

LookML-Developer Exam Question 4

A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.
Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?

A.Write a subquery in the FROM clause and alias with ${user_facts}.

B.Copy the name of the database table in the scratch schema for the user_facts derived table.

C.Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.

D.Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

LookML-Developer Exam Question 5

A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order is available on the underlying datasource table my tablename or at least every 24 hours.
Which datagroup definition will refresh the cache as expected?
A)