Exam Code: LOOKML-DEVELOPER
Exam Name: LookML Developer
Updated: Apr 29, 2024
Q&As: 50
At Passcerty.com, we pride ourselves on the comprehensive nature of our LOOKML-DEVELOPER exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.
Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Google LOOKML-DEVELOPER exam.
Instant download
Latest update demo according to real exam
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 LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.
Which two actions can the LookML developer take to improve the user interface? (Choose two.)
A. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
B. Modify the business users’ roles so they do not have this model in their model set.
C. Combine the Explores into just a few Explores that each join to many views.
D. Apply the group_label parameter to organize the Explores under different headings.
E. Apply the fields parameter so that each Explore has fewer fields in it.
The code below shows a view order_items with its measures total_revenue and user_count
Which code correctly represents a new measure that calculates average revenue per user?
A. Option A
B. Option B
C. Option C
D. Option D
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.
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}} ;;
Viewing Page 2 of 3 pages. Download PDF or Software version with 50 questions