Halloween Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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 arealso 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 A

B.

Option B

C.

Option C

D.

Option D

A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:

A.

Remove “<<<<<< HEAD”, “======”, and “>>>>>> branch ‘master’”

B.

Remove “<<<<<< HEAD”, “======”, and everything following “======”

C.

Remove everything between “<<<<<< HEAD” and “======”, and “>>>>>> branch ‘master’”

D.

Remove everything between “<<<<<< HEAD” and “>>>>>> branch ‘master’”

A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.

How should the developer define the yesno dimension?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

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 sql_trigger_value parameter of user_facts toselect the current date plus one hour, so it triggers an hour after orders_rollup.

B.

Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

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.

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.

Week_start_day

B.

Convert_tz

C.

Datatype

D.

Fiscal_month_offset