Google LookML-Developer Real Exam Questions Guaranteed Updated Dump from Actual4Dumps
Verified Pass LookML-Developer Exam in First Attempt Guaranteed
NEW QUESTION 28
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 adds up other measures in the sql parameter.
- C. A measure of type: sum has a SUM function written in the sql parameter.
- D. A measure of type: number has a SUM function written in the sql parameter.
Answer: A
NEW QUESTION 29
A LookML developer creates an Explore that joins two views. The base view has information about users' interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.
What should the developer add to the Explore in the model to achieve these requirements?
- A. The sql_always_where parameter
- B. A filtered measure
- C. The hidden parameter
- D. A relationship definition
Answer: D
NEW QUESTION 30
A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need to use these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.
Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?
A)
B)
C)
D)
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: C
NEW QUESTION 31
A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.
What does this indicate?
- A. A change has been committed in another developer's personal branch
- B. A change has been deployed to production.
- C. A change has been committed in another shared branch.
- D. A change has been deployed to a shared branch.
Answer: A
NEW QUESTION 32
The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.
Joins between the orders and users views should not incur high performance costs.
Users of this Explore will primarily be looking at data from the orders view.
Users of this Explore should only be able to see orders from the retailer "Fashion.ly".
The only field the users need from the products view is product.name.
Which LookML should the developer use?
A)
B)
C)
D)
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: A
NEW QUESTION 33
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. There is another Explore named order_items which references the inventory_items view.
- C. A field in the inventory_items view references a field in the order_items view.
- D. There is an Explore named inventory_items which references the order_items view.
Answer: A
NEW QUESTION 34
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 ephemeral derived table from the user's query.
- B. Add persist_for: "24 hours" to the orders Explore.
- C. Create an Explore with users as the base table.
- D. Create a persistent derived table from the user's query.
Answer: C
NEW QUESTION 35
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 model to Production Mode.
- B. The developer has not added users to the new model set.
- C. The new model is missing an Explore definition.
- D. The users do not have permission to access this dashboard.
Answer: B
NEW QUESTION 36
A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.
How can the LookML developer model these requirements and minimize the amount of code rewriting?
- A. Create native derived tables using transactions as the explore_source.
- B. Create a constant for each measure so it can be reused across other areas of the LookML project.
- C. Add measures to the transactions view of type: number to apply the required functions.
- D. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.
Answer: A
NEW QUESTION 37
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 field references working correctly?
A)
B)
C)
D)
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: D
NEW QUESTION 38
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. Datatype
- B. Fiscal_month_offset
- C. Convert_tz
- D. Week_start_day
Answer: B
NEW QUESTION 39
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. tags
- B. url_encode
- C. link
- D. drill_fields
Answer: C
NEW QUESTION 40
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 max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.
- B. 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.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION 41
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 redirect to the new database connection.
- B. Dashboard tiles and Looks that rely on this Explore will be deleted.
- C. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.
- D. Dashboard tiles and Looks that rely on this Explore will return an error.
Answer: B
NEW QUESTION 42
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. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;
- B. datagroup: 12_hours {
max_cache_age: "12 hours"
} - C. persist_for: "12 hours"
- D. persist_with: "12 hours"
Answer: D
NEW QUESTION 43
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. Symmetric_aggregates: no is not present in the Explore definition.
- B. A unique primary key is defined in each view.
- C. The sum measure used is defined correctly.
- D. No concatenated primary keys are used.
Answer: A
NEW QUESTION 44
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 filtered measure
- D. A sql_always_where parameter
Answer: B
NEW QUESTION 45
A retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value "000" for executives and "999" for store managers. The developer creates three access grant objects and one dimension:
How should the developer ensure that only authorized users see the data in the Total Revenue dimension?
- A. required_access_grants: [can_view_financial_data]
- B. required_access_grants: [leadership]
- C. required_access_grants: ["000","999"]
- D. required_access_grants: [total_revenue]
Answer: A
NEW QUESTION 46
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. Persist the derived table.
- B. Use index distribution_key or sort_key for this derived table.
- C. Build a user attribute filter into the Explore.
- D. Use a conditional WHERE clause for Development Mode.
Answer: A
NEW QUESTION 47
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. access_grant
- B. access_filter
- C. always_filter
- D. sql_always_where
Answer: A
NEW QUESTION 48
......
Download Real Google LookML-Developer Exam Dumps Test Engine Exam Questions: https://www.actual4dumps.com/LookML-Developer-study-material.html