Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.

Joins between the orders and users views should not incur high performance costs.

Users of this Explore will primarily be looking at data from the orders view.

Users of this Explore should only be able to see orders from the retailer “Fashion.ly”.

The onlyfield the users need from the products view is product.name.

Which LookML should the developer use?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 5

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 A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 6

A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.

Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?

A.

Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.

B.

Copy the name of the database table inthe scratch schema for the user_facts derived table.

C.

Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

D.

Write a subquery in the FROM clause and alias with ${user_facts}.

Full Access
Question # 7

Users report that the main dashboard has been slow toshow results.

Which two options should the developer evaluate to improve dashboard performance? (Choose two.)

A.

Number of databases used by dashboard elements

B.

Number of queries used by the dashboard

C.

Ratio of visualizations to text tiles

D.

Format used to deliver these reports

E.

Amount of data rendered for each query

Full Access