Google LookML-Developer Questions and Answers

dumps2021-11-01T03:40:26+08:00

Google LookML-Developer questions and answers are online, which are great material for you to learn. Each candidate has 100 minutes to complete all the questions. The exam price is $250. Google LookML-Developer exam language is English. Free Google LookML-Developer questions and answers are available below.

Page 1 of 2

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

Option A

Option B

Option C

Option D

2. 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 ameasure that meets these requirements? (Choose two.)

A)

Option A

Option B

Option C

Option D

Option E

3. The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores usedby the sales team need to be cached for one hour.

What is a scalable way to configure this caching logic?

Define two datagroups for the model. Apply persist_with at the model level with the datagroup for 1-hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.

Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.

Define two datagroups for the model. Create a persistent derived table (PDT) forthe daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.

Define for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.

4. A developer has User Specific Time Zones enabled fora Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don’t occur for these fields.

How can the developer determine to which fields this parameter should be applied through SQL Runner?

Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.

Open the Explore query in SQL Runner to determine which fields are converted.

Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.

Use the Describe feature in SQL Runner to determine which fields include time data.

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?

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.

6. Users report that every time they change the filter on their Explore, the filters take a very long time to populate.

How can the developer improve the filtering experience with this Explore?

Limit the filter suggestions using the suggestions parameter.

Add an always_filter parameter to restrict the filter suggestions.

Use an access_filter parameter to automatically apply filters.

Add persistence to the base view of the Explore.

7. A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.

What does this indicate?

A changehas been deployed to a shared branch.

A change has been committed in another developer’s personal branch

A change has been committed in another shared branch.

A change has been deployed to production.

8. A developer is defining the users table within a view file in Looker. Theusers table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.

How should the developer meet this requirement?

Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.

Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

Create two view files for the users table. One view file will have all possible fields for the users Explore, and theother will have only the fields required for the products Explore.

Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.

9. A developer defines the following measure in the order_items view:

The code must validate without errors.

Which action should thedeveloper take?

Join order_items and inventory_items in a derived table.

Join order_items and inventory_items in the same Explore.

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

Add the following to the order_itemsview file: include: “inventory_items,view.lkml”

10. 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?

Set definition

Join condition

Fields parameter

Hidden parameter

Page 2 of 2

11. A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count” in “category” available in the Explore section without any additional work done by the end user. For example:

The Count column represents the count for each combination of Category and Item.

The Count in Category column represents the count for each Category only.

How can the developer address this need with a LookML object?

Create a measure filtered on Category, and make the filter value controlled by a parameter.

Calculate the measure using a derived table, and then join that derived table back into the Explore.

Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.

Calculate the overall count using table calculations in the Explore.

12. 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:

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

required_access_grants: [can_view_financial_data]

required_access_grants: [leadership]

required_access_grants: [“000”,“999”]

required_access_grants: [total_revenue]

13. A developer would like to add a new dimension of type: yesno for the enabled column in

their users table. The column is of type: string in the database and returns yes and no values.

How should the developer define the yesno dimension?

A)

Option A

Option B

Option C

Option D

14. 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 onthe 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?

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

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

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

Create native derived tables using transactions as the explore_source.

15. 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?

An always_filter parameter

A front-end filter in the Explore

A sql_always_where parameter

A filtered measure

Google LookML-Developer Questions and Answers

Google LookML-Developer Questions and Answers

Share this post

Leave a Reply Cancel reply

Related Posts