Google Looker certifications LOOKML-DEVELOPER Questions & Answers

• Question 31:

  A developer wants to create 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?

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

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

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

  D. Calculate the overall count using table calculations in the Explore.

  Correct Answer: B

• Question 32:

  Business users report that 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?

  A. Use a conditional WHERE clause for Development Mode.

  B. Build a user attribute filter into the Explore.

  C. Use index distribution_key or sort_key for this derived table.

  D. Persist the derived table.

  Correct Answer: D

• Question 33:

  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. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 34:

  Only users with department attributes of Finance and Executive should be able to access the revenue view. Only users with the value of Executive for the department user attribute should be able to view the total_revenue field.

  Given the code snippet below: How should the required access grants be structured to set up this system of access?

  

  A. required_access_grants: [grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field

  B. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field

  C. required_access_grants: [grant_b] in the financial_data Explore, required_access_grants: [grant_a] in the total_revenue field

  D. required_access_grants: [grant_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field

  Correct Answer: B

• Question 35:

  The code below shows a view order_items with its measures total_revenue and user_count

  

  Which code correctly represents a new measure that calculates average revenue per user?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 36:

  Users report that the main dashboard has been slow to show results.

  Which two options should the developer evaluate to improve dashboard performance? (Сhoose two.)

  A. Number of databases used by dashboard elements

  B. Number of queries used by the dashboard

  C. Ratio of visualizations to text tiles D. Format used to deliver these reports

  E. Amount of data rendered for each query

  Correct Answer: BC

• Question 37:

  The developer has moved the orders Explore (shown below) from model_a to model_b, where both models are in the same project, and all users have access to both models.

  Connection: “demo” include: “.view” explore: orders {}

  What will happen after making this change?

  A. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.

  B. Dashboard tiles and Looks will redirect to the new database connection.

  C. Dashboard tiles and Looks that rely on this Explore will be deleted.

  D. Dashboard tiles and Looks that rely on this Explore will return an error.

  Correct Answer: C

• Question 38:

  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. An always_filter parameter

  B. A front-end filter in the Explore

  C. A sql_always_where parameter

  D. A filtered measure

  Correct Answer: B

• Question 39:

  A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.

  Which two actions can the LookML developer take to improve the user interface? (Choose two.)

  A. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

  B. Modify the business users’ roles so they do not have this model in their model set.

  C. Combine the Explores into just a few Explores that each join to many views.

  D. Apply the group_label parameter to organize the Explores under different headings.

  E. Apply the fields parameter so that each Explore has fewer fields in it.

  Correct Answer: BC

• Question 40:

  Users have built a popular dashboard and want to have change management built in for any edits made to the dashboard. The developer sets up version control for the model on which the dashboard is based.

  What should the developer build to meet the business requirement?

  A. A native derived table based on the dashboard.

  B. A dashboard LookML file included in the project.

  C. A link to the dashboard included in the project.

  D. An Explore LookML file based on the dashboard.

  Correct Answer: B