After running the LookML Validator, a developer sees the following error message in the Looker development env
After running the LookML Validator, a developer sees the following error message in the Looker development environment: “Measures with Looker aggregations (sum, average, min, max, list types) may not reference other measures”. What could be causing this error? A. A measure of type: count has a sql parameter defined. B. A measure of type: sum […]
A LookML developer creates a new model and a test dashboard from the model.
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 […]
A developer has User Specific Time Zones enabled for a Looker instance, but wants to ensure that queries run i
A developer has User Specific Time Zones enabled for a 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 […]
A user reports that a query run against the orders Explore takes a long time to run
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 […]
Business users report that they are unable to build useful queries because the list of fields in the Explore i
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 […]
A developer needs to add an Explore built off of the orders view, which surfaces only completed orders.
A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}. How should developer define a new Explore for completed orders and keep all […]
A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard
A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values. What happens in this situation? A. The filter values of both filters will combine in an additive manner and both filters […]
Users find it difficult to distinguish the dashboards they need for tracking sales performance.
Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder. What should the analyst do to improve the navigation experience? A. Pin the dashboards into boards and grant user access to the individual dashboards. B. Add descriptions to the dashboards […]
An analyst pins a dashboard from a personal folder to the team board.
An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet. What should the analyst do to enable the team’s access? A. Give all users view access to […]
An analyst creates a column chart showing the count of total orders and the count of returned orders on each d
An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually. How […]