2.2 Visualize Data and Create Dashboards in Looker Given Business Requirements ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A LookML developer is working on a model with a view 'orders' that has a dimension 'created_date' and a measure 'total_revenue'. The developer wants to create a new Explore that only shows orders from the last 30 days by default, but still allows users to see all data if they remove the filter. What is the best approach?

   • ACreate a new view with a derived table that only contains the last 30 days of data.
   • BAdd a filter-only field to the Explore and set a default value of '30 days'.
   • CModify the 'created_date' dimension to only show the last 30 days.
   • DAdd a condition to the Explore's sql_always_where parameter.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A small business owner wants to create a simple report showing sales by month. The owner has a Google Sheet with the data and wants to share the report with a few partners via a link. The owner does not need advanced data modeling or embedded analytics. Which tool should they use?

   • ABigQuery
   • BLooker Studio
   • CGoogle Data Studio (legacy)
   • DLooker
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A LookML developer needs to add a new field that calculates profit as revenue minus cost. The developer wants this field to be available in the Explore for business users to use in dashboards. Where should this calculation be defined?

   • AAs a dimension in the view file that uses a SQL expression.
   • BAs a filter in the model file that restricts the Explore data.
   • CAs a measure in the view file that references the revenue and cost dimensions.
   • DAs a new Explore in the model file that joins the revenue and cost views.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A Looker dashboard has tiles that are too small for the data they display. What is the correct way to resize a tile to make it larger?

   • AChange the tile's width in the LookML model
   • BUse the 'Zoom' option on the tile
   • CEdit the dashboard and drag the tile's corner handle to resize it
   • DRecreate the Look with a larger visualization type
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A data analyst needs to create a Looker dashboard that answers a specific business question about monthly sales trends. What is the primary way to add a visualization to a new Looker dashboard?

   • AUse the dashboard API to embed a third-party chart
   • BCreate a new Look and then add it as a tile to the dashboard
   • CUpload a CSV file and attach it to the dashboard
   • DWrite a SQL query directly in the dashboard editor
   Reveal Solution Discussion Select an answer first