Which persistence parameter should be added to the derived table’s definition in order to satisfy this use case?

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 thetable to be cached for 12 hours, but only when a user has queried it. Which persistence parameter should be added to the derived...

November 23, 2021 No Comments READ MORE +

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

The code below shows a vieworder_items with its measures total_revenue and user_count Which code correctly represents a new measure that calculates average revenue per user? A) B) C) D) A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: C

November 22, 2021 No Comments READ MORE +

How should the Explore be defined to meet this requirement?

A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed...

November 19, 2021 No Comments READ MORE +

Which LookML parameter should be used to resolve this issue?

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_dayB . Convert_tzC . DatatypeD . Fiscal_month_offsetView...

November 19, 2021 No Comments READ MORE +

How can the developer use SQL Runner to troubleshoot quickly?

A user is seeing an error in the Explore that indicates the primary key defined for a one- million-row table is not unique. How can the developer use SQL Runner to troubleshoot quickly?A . Create a query that selects all the fields from the table, and sort by primary key.B...

November 18, 2021 No Comments READ MORE +

How should the developer construct an Explore using the order_items view as the base view?

A developer needs to model out LookML to convert existing reports into Looker. The existing reports are: Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices. Report 2: A report with order and order_items data, which finds...

November 18, 2021 No Comments READ MORE +

Which parameter should be added to the country dimension to create a connection to this other associated Explore?

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_encodeB . drill_fieldsC . tagsD . linkView...

November 17, 2021 No Comments READ MORE +

What should the developer build to meet the business requirement?

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 isbased. What should the developer build to meet the business requirement?A . A native derived table...

November 16, 2021 No Comments READ MORE +

Which LookML parameter should the developer use to meet this requirement?

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

November 14, 2021 No Comments READ MORE +

Which solution should the developer implement to meet these requirements?

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 parameterB . A front-end filter in the ExploreC . A sql_always_where parameterD . A filtered measureView AnswerAnswer: B

November 11, 2021 No Comments READ MORE +