Google LookML-Developer Exam Questions Free Practice Test

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Questions # 1:

A retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value “000” for executives and “999” for storemanagers. The developer creates three access grant objects and one dimension:

Question # 1

How should the developer ensure that only authorized users see the data in the Total Revenue dimension?

Options:

required_access_grants: [can_view_financial_data]

required_access_grants: [leadership]

required_access_grants: [“000”,“999”]

required_access_grants: [total_revenue]

Questions # 2:

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?

Options:

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

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

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

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

Questions # 3:

A user reports that, when a date dimension is filtered to “before now” results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue.

Which LookML parameter should be used to resolve this issue?

Options:

Week_start_day

Convert_tz

Datatype

Fiscal_month_offset

Questions # 4:

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

Options:

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

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

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

Use the hidden parameter to remove irrelevant fields from the Explore.

Use a derived table to show only the relevant fields.

Questions # 5:

Business users reportthat an ephemeral derived table tile on the dashboard is slow.

Information about the dashboard includes:

The dashboard filter is linked to the user attributes.

This tile usually takes approximately 5 minutes to complete running.

Which solution should be used to improve the dashboard load time?

Options:

Use a conditional WHERE clause for Development Mode.

Build a user attribute filter into the Explore.

Use index distribution_key or sort_key for this derived table.

Persist the derived table.

Questions # 6:

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 arealso 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?

Question # 6

Options:

Option A

Option B

Option C

Option D

Questions # 7:

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?

Options:

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

Create a query that selects the primary key from the base view, and look forduplicates.

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

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

Questions # 8:

A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View fromTable functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.

What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?

Options:

Set definition

Join condition

Fields parameter

Hidden parameter

Questions # 9:

A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants thetable to be cached for 12 hours, but only when a user has queried it.

Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?

Options:

persist_with: “12 hours”

datagroup: 12_hours {

max_cache_age: “12 hours”

}

persist_for: “12 hours”

sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

Questions # 10:

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.

Question # 10

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

Options:

Change the sql_trigger_value parameter of user_facts toselect the current date plus one hour, so it triggers an hour after orders_rollup.

Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.

Change the orders_rollup view reference to the literal table name from the database’s scratch schema.

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Pass the Google Looker certifications LookML-Developer Questions and answers with CertsForce