Free Google LookML-Developer Exam Dumps Questions & Answers

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.  Persist the derived table.
• C.  Use index distribution_key or sort_key for this derived table.
• D.  Build a user attribute filter into the Explore.

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.  There is another Explore named order_items which references the inventory_items view.
• B.  There is an Explore named inventory_items which references the order_items view.
• C.  A field in the order_items view references a field in the inventory_items view.
• D.  A field in the inventory_items view references a field in the order_items view.

Users report that the main dashboard has been slow to show results.
Which two options should the developer evaluate to improve dashboard performance? (Choose two.)

• A.  Number of databases used by dashboard elements
• B.  Ratio of visualizations to text tiles
• C.  Amount of data rendered for each query
• D.  Number of queries used by the dashboard
• E.  Format used to deliver these reports

A user reports an error message on an Explore: "Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum".
What should the LookML developer check for in the joined views of the Explore?

• A.  A unique primary key is defined in each view.
• B.  The sum measure used is defined correctly.
• C.  No concatenated primary keys are used.
• D.  Symmetric_aggregates: no is not present in the Explore definition.

A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.
Which LookML parameter should the developer use to meet this requirement?

• A.  sql_always_where
• B.  access_filter
• C.  access_grant
• D.  always_filter