Google LOOKML-DEVELOPER Online Practice Questions and Exam Preparation

Google LOOKML-DEVELOPER Online Questions & Answers

• Question 41:

  Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute. Which access filter should the developer use to meet this requirement?

  

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

• Question 42:

  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. A bare Git repository
  B. Multiple account HTTPS
  C. Single account HTTPS
  D. SSH
  D. SSH

• Question 43:

  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
  B. A front-end filter in the Explore

• Question 44:

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

• Question 45:

  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?

  A. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.
  B. Copy the name of the database table in the scratch schema for the user_facts derived table.
  C. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).
  D. Write a subquery in the FROM clause and alias with ${user_facts}.
  C. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

• Question 46:

  After running the Content Validator, a developer can see the error “Unknown field”. Which two changes could cause this issue? (Choose two.)

  A. View name was changed from users to customers.
  B. Field type was changed from number to string.
  C. Model name was changed from e_commerce to reporting.
  D. Explore label was changed from users to customers.
  E. Field name was changed from id to user_id.
  B. Field type was changed from number to string.
  E. Field name was changed from id to user_id.

• Question 47:

  The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores used by the sales team need to be cached for one hour. What is a scalable way to configure this caching logic?

  A. 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.
  B. Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.
  C. Define two datagroups for the model. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.
  D. 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.
  A. 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.

• Question 48:

  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 the table 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?

  A. persist_with: “12 hours”
  B. datagroup: 12_hours { max_cache_age: “12 hours” }
  C. persist_for: “12 hours”
  D. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;
  A. persist_with: “12 hours”

• Question 49:

  A developer wants to create a new Explore based on the order_items view. The developer creates an Explore in the ecommerce model file with the following definition:

  explore: order_items {}

  After saving and validations, the developer receives this LookML validator error:

  Inaccessible view “inventory_items”, “inventory_items” is not accessible in explore” “order_items”. Check for typos and missing joins in explore “order_items”.

  What caused this error to appear?

  A. A field in the order_items view references a field in the inventory_items view.
  B. A field in the inventory_items view references a field in the order_items view.
  C. There is an Explore named inventory_items which references the order_items view.
  D. There is another Explore named order_items which references the inventory_items view.
  A. A field in the order_items view references a field in the inventory_items view.

• Question 50:

  Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared. Which parameter should be added to the country dimension to create a connection to this other associated Explore?

  A. url_encode
  B. drill_fields
  C. tags
  D. link
  D. link