Free Google LookML-Developer Exam Dumps Questions & Answers

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 only field the users need from the products view is product.name.
Which LookML should the developer use?
A)

B)

C)

D)

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

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 the literal table name from the database's scratch schema.
• 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 ${orders_rollup.DERVIED_TABLE_NAME}

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?
A)

B)

C)

D)

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

Users have built a popular dashboard and want to have change management built in for any edits made to the dashboard. The developer sets up version control for the model on which the dashboard is based.
What should the developer build to meet the business requirement?

• A.An Explore LookML file based on the dashboard.
• B.A link to the dashboard included in the project.
• C.A native derived table based on the dashboard.
• D.A dashboard LookML file included in the project.

A retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value "000" for executives and "999" for store managers. The developer creates three access grant objects and one dimension:

How should the developer ensure that only authorized users see the data in the Total Revenue dimension?

• A.required_access_grants: [total_revenue]
• B.required_access_grants: [leadership]
• C.required_access_grants: ["000","999"]
• D.required_access_grants: [can_view_financial_data]