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?
Answer(s): A
https://help.looker.com/hc/en-us/articles/360038371614--Error-Measures-with-Looker-Aggregations-Sum-Average-Min-Max-List-Types-May-Not-Reference-Other-Measures
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?
Answer(s): D
https://help.looker.com/hc/en-us/articles/360037732513-Error-Non-Unique-value-primary-key-or-sql-distinct-key-value-overflow-or-collision-when-computing-sum
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?
https://docs.looker.com/reference/explore-params/persist_for-for-explore
A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?
Answer(s): C
https://docs.looker.com/reference/view-params/sql_trigger_value
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?
https://community.looker.com/technical-tips-tricks-1021/how-to-use-and-troubleshoot-access-grants-field-permissions-23986
Share your comments for Google LookML Developer exam with other users:
questions seem helpful
good content
question 21 answer is alerts
am preparing for exam
good one thanks
only got thru 5 questions, need more to evaluate
q26 should be b
the aaa triad in information security is authentication, accounting and authorisation so the answer should be d 1, 3 and 5.
need to attend this
these are free brain dumps i understand, how can one get free pdf
provide access
good morning
please upload the ncp-mci 6.5 dumps, really need to practice this one. thanks guys
question 16: https://help.salesforce.com/s/articleview?id=sf.care_console_overview.htm&type=5
yes i m prepared exam
my experience was great with this site as i studied for the ms-900 from here and got 900/1000 on the test. my main focus was on the tutorials which were provided and practice questions. thanks!
great course
very good question
question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
highly recommend just passed my exam.
great practice! thanks
anyone who wrote this exam recently?
kindly share the dump
could you please upload cfe fraud prevention and deterrence questions? it will be very much helpful.
this is really very very helpful for mcd level 1
very helpful!
question #18s answer should be a, not d. this should be corrected. it should be minvalidityperiod
thanks for the exact solution
need to refer the questions and have to give the exam
i need it right now if it was possible please
i need it very much please share it in the fastest time.
correct answer is d for student.java program
q:37 c is correct
q6 exam topic: terramearth, c: correct answer: copy 1petabyte to encrypted usb device ???
Keeping this site free takes real effort. We constantly battle automated scraping and unauthorized content copying. A quick account helps us protect the community and keep the site free.
To continue studying for your LookML Developer, please sign in or create a free account.