LOOKER-BUSINESS-ANALYST Online Practice Questions and Answers

An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.

Which action should the analyst take to download all results?

A. Request that the admin user download this Look and share the file.

B. Change the table calculation to use an offset() function.

C. Contact the developer to create the percentage as a measure.

D. Apply a custom limit to the download.

An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet.

What should the analyst do to enable the team's access?

A. Give all users view access to the personal folder.

B. Move the dashboard to a shared folder and provide access only to the users from the team.

C. Give view access to the individual dashboards.

D. Create a subfolder in the personal folder and given view access to the users from the team.

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

A. Display row totals for each category.

B. Series type customization on budgeted spend.

C. Grouped series positioning on budgeted spend.

D. Transpose table to separate out budgeted spend.

An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading "All Results Unavailable."

What are three causes of this message? (Choose three.)

A. The Row Limit chosen in the Look is too high.

B. There is a table calculation in the Look.

C. Unlimited results are unsupported by CSV format.

D. The Row Totals option is turned on in the Look.

E. There is a Running Total measure in the Look.

F. The Totals option is turned on in the Look.

A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.

What is a possible cause of this discrepancy?

A. There is a row limit applied.

B. There is a filter on a dimension.

C. There is a problem with the underlying LookML.

D. There is a column limit applied.

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

A. 7 days from now

B. After Today's Date for 7 days

C. Today for 7 days

D. For 7 days

A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

A. X-axis settings

B. Column settings

C. Explore settings

D. Row settings

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.

How should the analyst ensure that the PDF shows all available results in the UI dashboard?

A. Select the Expand Tables option.

B. Select the All Results option

C. Select the Allow Scroll option and specify each table.

D. Select the Paper Size option and specify a large size.

The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.

Which access settings should be applied to the folder?

A. Admins: Manage Access, Edit Sales analyst: Edit Sales group: View

B. Admins: View Sales analyst: Edit Sales group: View

C. Admins: View Sales analyst: Manage Access, Edit Sales group: View

D. Admins: Manage Access, Edit Sales analyst: Manage Access, Edit Sales group: View

An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.

There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.

What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?

A. Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.

B. Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.

C. Use the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.

D. Use the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.