Practice More Questions From: Performance Optimization
Q:
Which of the below would not be considered a key element of work for BigQuery?
Q:
True or False: Tables stored in Google Cloud Storage (external connections) have intelligence built-in to SQL queries ran like automatic predicate pushdown (e.g. BigQuery will move your WHERE clause higher in your long query)
Q:
What is one of the best ways to handle data skew in your datasets?
Q:
When should you use self-joins (queries that join a table on itself)?
Q:
Why is performing a GROUP BY on columns with many distinct values a bad idea?
Q:
What is the best way to handle manually sharding table rows?
Q:
What is the filter command to filter on a date-partitioned table?
Q:
True or False: By default, BigQuery automatically ingests billing logs for queries and other Google Cloud products which you can then analyze
Q:
True or False: New Project-level Owners that are added to your Google Cloud account will automatically be added as dataset owners to your BigQuery tables and resources by default
Q:
True or False: You can monitor query logs and access through Cloud Monitoring (a tool that visualizes Google Cloud logs)
Subscribe
0 Comments
