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 B
• B.Option C
• C.Option A
• D.Option D

Comment: *

Name: *

Email: *

Verification: *

A user needs to create a report that shows a count of all orders and of orders over $100.
Which solution should the developer implement to meet these requirements?

• A.A filtered measure
• B.A front-end filter in the Explore
• C.A sql_always_where parameter
• D.An always_filter parameter

Comment: *

Name: *

Email: *

Verification: *

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 the primary key from the base view, and look for duplicates.
• D.Create a query that selects all the fields from the table, and sort by primary key.

Comment: *

Name: *

Email: *

Verification: *

A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.

Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?

• A.Change the orders_rollup view reference to the literal table name from the database's scratch schema.
• B.Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
• C.Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
• D.Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.

Comment: *

Name: *

Email: *

Verification: *

A developer is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.
Which type of Git connection should be utilized to meet this business requirement?

• A.SSH
• B.A bare Git repository
• C.Multiple account HTTPS
• D.Single account HTTPS

Comment: *

Name: *

Email: *

Verification: *