929 お客様のコメント
質問 1：
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. Modify the business users' roles so they do not have this model in their model set.
B. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
C. Combine the Explores into just a few Explores that each join to many views.
D. Apply the fields parameter so that each Explore has fewer fields in it.
E. Apply the group_label parameter to organize the Explores under different headings.
正解：A,C
質問 2：
Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.
Which access filter should the developer use to meet this requirement?
A)
B)
C)
D)
A. Option C
B. Option A
C. Option D
D. Option B
正解：D
質問 3：
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?
A. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
B. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
D. Change the orders_rollup view reference to the literal table name from the database's scratch schema.
正解：C
質問 4：
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 inventory_items view references a field in the order_items view.
B. A field in the order_items view references a field in the inventory_items view.
C. There is an Explore named inventory_items which references the order_items view.
D. There is another Explore named order_items which references the inventory_items view.
正解：B
質問 5：
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
正解：B
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. Modify the business users' roles so they do not have this model in their model set.
B. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
C. Combine the Explores into just a few Explores that each join to many views.
D. Apply the fields parameter so that each Explore has fewer fields in it.
E. Apply the group_label parameter to organize the Explores under different headings.
正解：A,C
質問 2：
Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.
Which access filter should the developer use to meet this requirement?
A)
B)
C)
D)
A. Option C
B. Option A
C. Option D
D. Option B
正解：D
質問 3：
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?
A. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
B. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.
C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
D. Change the orders_rollup view reference to the literal table name from the database's scratch schema.
正解：C
質問 4：
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 inventory_items view references a field in the order_items view.
B. A field in the order_items view references a field in the inventory_items view.
C. There is an Explore named inventory_items which references the order_items view.
D. There is another Explore named order_items which references the inventory_items view.
正解：B
質問 5：
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
正解：B
Namiki -
最小限の対策で合格をめざすLookML-Developer参考書だぜ。問題数も増えた感じで内容も充実している。無事、合格することができました。感謝感激です。