Google LookML-Developer Exam Questions Instant Access

Question 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.)

AApply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

BModify the business users' roles so they do not have this model in their model set.

CCombine the Explores into just a few Explores that each join to many views.

DApply the group_label parameter to organize the Explores under different headings.

EApply the fields parameter so that each Explore has fewer fields in it.

Answer : B, C

Question 2

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?

Apersist_with: ''12 hours''

Bdatagroup: 12_hours {
max_cache_age: ''12 hours''
}

Cpersist_for: ''12 hours''

Dsql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

Answer : A

Question 3

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?

AThe developer has not pushed the new model to Production Mode.

BThe developer has not added users to the new model set.

CThe users do not have permission to access this dashboard.

DThe new model is missing an Explore definition.

Answer : B

Question 4

A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.

How should the Explore be defined to meet this requirement?

AOption A

BOption B

COption C

DOption D

Answer : B

Question 5

A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.

How should the developer meet this requirement?

AUse the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.

BCreate duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

CCreate two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.

DUse the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.

Answer : A

Question 6

A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.

Which two methods can be used to create a measure that meets these requirements? (Choose two.)

AOption A

BOption B

COption C

DOption D

EOption E

Answer : A, C

Question 7

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?

AWeek_start_day

BConvert_tz

CDatatype

DFiscal_month_offset

Answer : D

Google Looker LookML Developer LookML-Developer Exam Questions