厳密検証されたLookML-Developer試験問題集と解答で無料提供のLookML-Developer問題と正解付き
あなたを合格させるLookML-Developer問題集で無料最新Google練習テスト
質問 24
The developer has moved the orders Explore (shown below) from model_a to model_b, where both models are in the same project, and all users have access to both models.
Connection: "demo"
include: ".view"
explore: orders {}
What will happen after making this change?
- A. Dashboard tiles and Looks that rely on this Explore will return an error.
- B. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.
- C. Dashboard tiles and Looks that rely on this Explore will be deleted.
- D. Dashboard tiles and Looks will redirect to the new database connection.
正解: C
質問 25
A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:
SELECT * FROM users.
What should the developer do to improve the performance of the query in the Explore?
- A. Add persist_for: "24 hours" to the orders Explore.
- B. Create a persistent derived table from the user's query.
- C. Create an ephemeral derived table from the user's query.
- D. Create an Explore with users as the base table.
正解: D
質問 26
After running the Content Validator, a developer can see the error "Unknown field".
Which two changes could cause this issue? (Choose two.)
- A. Explore label was changed from users to customers.
- B. Model name was changed from e_commerce to reporting.
- C. Field type was changed from number to string.
- D. Field name was changed from id to user_id.
- E. View name was changed from users to customers.
正解: C,D
質問 27
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. Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
- B. Combine the Explores into just a few Explores that each join to many views.
- C. Modify the business users' roles so they do not have this model in their model set.
- D. Apply the group_label parameter to organize the Explores under different headings.
- E. Apply the fields parameter so that each Explore has fewer fields in it.
正解: B,C
質問 28
A developer wants to create a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this "count" in "category" available in the Explore section without any additional work done by the end user. For example:
The Count column represents the count for each combination of Category and Item.
The Count in Category column represents the count for each Category only.
How can the developer address this need with a LookML object?
- A. Calculate the measure using a derived table, and then join that derived table back into the Explore.
- B. Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.
- C. Create a measure filtered on Category, and make the filter value controlled by a parameter.
- D. Calculate the overall count using table calculations in the Explore.
正解: A
質問 29
A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.
What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?
- A. Join condition
- B. Hidden parameter
- C. Set definition
- D. Fields parameter
正解: A
質問 30
A developer needs to model out LookML to convert existing reports into Looker. The existing reports are:
Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices.
Report 2: A report with order and order_items data, which finds the order with the largest total number of products ordered.
Report 3: A report with data on every product, whether or not it has been ordered.
Each database table used is updated in real time as orders are made.
How should the developer construct an Explore using the order_items view as the base view?
- A. Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.
- B. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
- C. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.
- D. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.
正解: A
質問 31
The code below shows a view order_items with its measures total_revenue and user_count
Which code correctly represents a new measure that calculates average revenue per user?
A)
B)
C)
D)
- A. Option C
- B. Option D
- C. Option B
- D. Option A
正解: A
質問 32
A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need to use these two dimensions in the sql_start and sql_end parameters of a dimension group of type: duration.
Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?
A)
B)
C)
D)
- A. Option D
- B. Option C
- C. Option B
- D. Option A
正解: D
質問 33
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 B
- B. Option D
- C. Option C
- D. Option A
正解: A
質問 34
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 are also 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 C
- B. Option D
- C. Option B
- D. Option A
正解: A
質問 35
A developer is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.
Which type of Git connection should be utilized to meet this business requirement?
- A. Single account HTTPS
- B. A bare Git repository
- C. SSH
- D. Multiple account HTTPS
正解: C
質問 36
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?
- A. The users do not have permission to access this dashboard.
- B. The developer has not added users to the new model set.
- C. The new model is missing an Explore definition.
- D. The developer has not pushed the new model to Production Mode.
正解: B
質問 37
A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.
How can the developer use SQL Runner to troubleshoot quickly?
- A. Create a query that selects the primary key from the base view, and look for duplicates.
- B. Create a query that concatenates two columns to create a compound primary key.
- C. Create a query that selects all the fields from the table, and sort by primary key.
- D. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.
正解: B
質問 38
Only users with department attributes of Finance and Executive should be able to access the revenue view. Only users with the value of Executive for the department user attribute should be able to view the total_revenue field.
Given the code snippet below:
How should the required access grants be structured to set up this system of access?
- A. required_access_grants: [grant_b] in the financial_data Explore, required_access_grants: [grant_a] in the total_revenue field
- B. required_access_grants: [grant_a, grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
- C. required_access_grants: [grant_a] in the revenue view, required_access_grants: [grant_a, grant_b] in the total_revenue field
- D. required_access_grants: [grant_b] in the revenue view, required_access_grants: [grant_a] in the total_revenue field
正解: C
質問 39
A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.
How can the LookML developer model these requirements and minimize the amount of code rewriting?
- A. Add measures to the transactions view of type: number to apply the required functions.
- B. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.
- C. Create native derived tables using transactions as the explore_source.
- D. Create a constant for each measure so it can be reused across other areas of the LookML project.
正解: C
質問 40
A user reports an error message on an Explore: "Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum".
What should the LookML developer check for in the joined views of the Explore?
- A. No concatenated primary keys are used.
- B. Symmetric_aggregates: no is not present in the Explore definition.
- C. The sum measure used is defined correctly.
- D. A unique primary key is defined in each view.
正解: B
質問 41
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 order_items view references a field in the inventory_items view.
- B. There is another Explore named order_items which references the inventory_items view.
- C. A field in the inventory_items view references a field in the order_items view.
- D. There is an Explore named inventory_items which references the order_items view.
正解: A
質問 42
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 D
- B. Option C
- C. Option B
- D. Option A
正解: D
質問 43
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 B
- B. Option D
- C. Option C
- D. Option A
正解: A
質問 44
......
無料でゲット！高評価Google LookML-Developer試験問題集今すぐダウンロード！：https://www.goshiken.com/Google/LookML-Developer-mondaishu.html