Google LOOKML-DEVELOPER Online Practice Questions and Exam Preparation

Google LOOKML-DEVELOPER Online Questions & Answers

• Question 1:

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

  

  

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  A. Option A
  C. Option C

• Question 2:

  A LookML developer creates a new model and a test dashboard from the model. The developer shares the link to the new dashboard with users, but the users report that all they see is the “Model Not Found” error. What is a possible cause of this issue?

  A. The developer has not pushed the new model to Production Mode.
  B. The developer has not added users to the new model set.
  C. The users do not have permission to access this dashboard.
  D. The new model is missing an Explore definition.
  B. The developer has not added users to the new model set.

• Question 3:

  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.
  B. Calculate the measure using a derived table, and then join that derived table back into the Explore.

• Question 4:

  A developer defines the following measure in the order_items view:

  

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

  A. Join order_items and inventory_items in a derived table.
  B. Join order_items and inventory_items in the same Explore.
  C. Copy the cost definition from inventory_items to the order_items view file.
  D. Add the following to the order_items view file: include: “inventory_items,view.lkml”
  A. Join order_items and inventory_items in a derived table.

• Question 5:

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

  A. Add a description parameter to each field with context so that users can search key terms.
  B. Create a separate project for each business unit containing only the fields that the unit needs.
  C. Add a group_label parameter to relevant fields to organize them into logical categories.
  D. Use the hidden parameter to remove irrelevant fields from the Explore.
  E. Use a derived table to show only the relevant fields.
  A. Add a description parameter to each field with context so that users can search key terms.
  C. Add a group_label parameter to relevant fields to organize them into logical categories.
  E. Use a derived table to show only the relevant fields.

• Question 6:

  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?

  A. Week_start_day
  B. Convert_tz
  C. Datatype
  D. Fiscal_month_offset
  D. Fiscal_month_offset

• Question 7:

  A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and

  quickly receives results:

  SELECT * FROM users.

  What should the developer do to improve the performance of the query in the Explore?

  A. Create an Explore with users as the base table.
  B. Create a persistent derived table from the user's query.
  C. Create an ephemeral derived table from the user's query.
  D. Add persist_for: “24 hours” to the orders Explore.
  A. Create an Explore with users as the base table.

• Question 8:

  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
  B. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field

• Question 9:

  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.
  C. Dashboard tiles and Looks that rely on this Explore will be deleted.

• Question 10:

  Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production. Where should the developers write the LookML for this view?

  A. In the master branch, with both users writing to the branch
  B. In one user's personal branch, with both users writing to the branch
  C. In a new shared branch created from the master branch
  D. In each of their personal branches, with each user writing code separately
  C. In a new shared branch created from the master branch