Data Analysis And Presentation

You are building a Looker dashboard and need to calculate the year-over-year growth rate. Which feature should you use to perform this without modifying the underlying SQL?

You are analyzing query performance in BigQuery. You notice that your queries are spilling to disk. What is the most likely cause?

A data scientist is using Vertex AI Workbench and needs to share a notebook with a team member who only needs read access. What is the most secure way to do this?

Your team wants to visualize BigQuery data in Looker Studio. What is the most efficient way to ensure the dashboard reflects fresh data without manual refreshes?

You are identifying trends in a large dataset using BigQuery. Which SQL function is best suited to identify the top 5 products sold per region?

A marketing manager needs to see daily sales trends in Looker. The underlying data is in BigQuery and is updated every 6 hours. What is the best way to visualize this?

You are using Vertex AI Workbench and want to ensure your notebook environment persists after the instance is stopped. Where should you save your work?

You need to analyze a petabyte-scale dataset in BigQuery. To optimize cost, you must ensure that users only query relevant partitions. How should you enforce this?

A user needs to see the distribution of values in a column in BigQuery. Which visualization approach is most effective for this?

You are developing a dashboard in Looker. You notice that the 'Explore' menu is missing a specific set of fields. What should you check in the LookML model?

When optimizing a Looker model, you want to prevent users from accidentally running very expensive queries. Which parameter should you use in LookML?

In BigQuery, you want to improve query performance for a table that is frequently filtered by a `customer_id` column. What is the recommended strategy?

When creating a Looker visualization, which chart type is best for showing the relationship between two numerical variables?

You are writing a Python script in Vertex AI Workbench. You want to query BigQuery and load the result into a pandas DataFrame. Which library should you use?

You have a dashboard in Looker Studio and you want to allow users to dynamically change the date range without editing the report. What should you add?

A user is running a query on a BigQuery table with nested data (JSON). How do you access a field named 'city' inside a record field named 'address'?

You are working in a Vertex AI Workbench notebook and want to list the files in your current working directory. What command should you run?

A BigQuery table has 10 billion rows. You notice a query performing a cross-join is timing out. What should you do?

When designing a Looker dashboard, you need to display a value that is the average of a specific metric across the entire dashboard. What is the best method?

A user wants to see the top 10 products sold, but also an 'Other' category for the rest. How can you achieve this in a Looker Explore?

You have a Looker dashboard that loads slowly. What is the first thing you should check in the 'Looker System Activity' or 'Query History'?

You need to perform a time-series analysis in BigQuery. Your data contains timestamps at a millisecond level, but you need to aggregate by hour. What is the most performant way to truncate the timestamp?

In BigQuery, what does the 'Data Preview' tab show?

Which service is the primary tool for managing and running Jupyter notebooks in a managed environment within Google Cloud?

When reviewing a Looker dashboard, which icon do you click to reload the data?

In Looker, what is the impact of defining a 'primary_key' in a LookML view?

You are using Vertex AI Workbench. You want to install a new Python library, `seaborn`, for visualization. What is the correct way to install it in the notebook instance?

You want to share a BigQuery dataset with a partner who uses a different Google Cloud project. What is the most secure way to grant them access?

You need to export query results from BigQuery to a Google Sheet. What is the easiest way to do this?

You have a query that processes 500GB of data. You want to reduce the cost of this query. What is the most effective approach?

A data analyst is working in a Vertex AI Workbench notebook. They want to connect to a private BigQuery dataset. How should they authenticate?

You are creating a Looker report with a 'measure' that calculates the total revenue. You notice it is summing correctly but the format is wrong. Where do you change the format?

Which BigQuery feature allows you to monitor query usage and identify expensive queries?

You want to automate the export of a BigQuery table to Cloud Storage on a daily basis. What should you use?

Which TWO of the following are valid ways to visualize BigQuery data within the Google Cloud ecosystem?

Which THREE factors should you consider when choosing a partitioning strategy for a BigQuery table?

You need to change the color palette of your Looker dashboard charts. Where should you make this change?

You are building a Looker model and want to create a measure that calculates the count of distinct customers. Which type of measure should you use?

You are querying a dataset in BigQuery that uses partitioning. Your query doesn't use the partitioning column. What is the consequence?

Which TWO actions can help reduce the time it takes to build a Jupyter notebook in Vertex AI Workbench?

Which THREE items can be added to a Looker Studio report to enhance interactivity?

Which THREE features does Looker offer to support data governance?

Which TWO types of data sources can be used to create a dashboard in Looker Studio?

Which THREE of these are valid ways to monitor or analyze BigQuery performance?

What is the primary function of a Looker Explore?

In LookML, which parameter is used to define how a table should join to another?

Which TWO of the following SQL techniques in BigQuery are best for optimizing performance on large tables?

Which of the following describes the purpose of 'BigQuery ML'?

You have a large table in BigQuery that is updated constantly. You need to perform a query that is consistent. What should you use?

A colleague has shared a Vertex AI Workbench notebook with you. How can you run it?

What is the benefit of using 'Scheduled Reports' in Looker?

You notice your Looker dashboard is showing duplicate data. What is the most likely cause?

When creating a dashboard in Looker Studio, which connector type allows you to connect to an arbitrary SQL query?

You are writing a complex BigQuery query and need to define a temporary table to use later in the same query. What is the most efficient syntax?