Google Looker LookML Developer 是由 Google 官方舉辦的認證考試，在業界具有高度公信力，也是許多企業篩選人才的重要依據。想在 2026 年取得這張證照，Fast2test 的 LookML-Developer 題庫（51 題）會是你值得信賴的備考夥伴。

Google LookML-Developer 考試概覽:

Google LookML-Developer 考試大綱主題:

Google Looker LookML Developer 考生最常問的問題

最新的 Looker certifications LookML-Developer 免費考試真題：

問題 #1

A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order is available on the underlying datasource table my tablename or at least every 24 hours.
Which datagroup definition will refresh the cache as expected?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option C
D. Option A

問題 #2

A developer needs to implement three persistent derived tables (PDTs) as described below.
The PDTs need to be refreshed after the daily ETL pipeline adds incremental loads to the underlying tables.
Each PDT is built off of one underlying table in the database (one PDT per table).
The underlying tables for each PDT are updated one after the other, and a new row is added to an ETL log table each time a table is updated.
Due to the unpredictable nature of the ETL pipeline, each PDT does not refresh at the same time from day to day.
Each PDT takes over an hour to build, and to save on compute costs each PDT should only be refreshed once per day.
How can the developer set up the PDTs according to these requirements?

A. Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.
B. Create three separate datagroups tied to three PDTs that run when each corresponding table's row count changes.
C. Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.
D. Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.

問題 #3

A developer needs to build a new dimension that offers an age-based cohort representation of users.
Which LookML code should the developer use to meet the requirement?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option C
D. Option A

問題 #4

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. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;
D. persist_for: "12 hours"

問題 #5

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. A filtered measure
B. The hidden parameter
C. The sql_always_where parameter
D. A relationship definition

問題與答案：