Reboot Quiz

What clause allows SQL queries to return only unique values?

Which of the following is a type of SQL join?

• SIDE JOIN
• LEFT JOIN
• TOP JOIN
• CROSS LEFT

What Google Looker Studio feature allows you to create dynamic filters?

• Button
• Control
• Group
• Style

What is the function of Fivetran in the data stack?

• Data ingestion
• Data cleaning
• Data analysis
• Data visualization

Which chart type is best for showing trends over time?

In Fivetran, what is the term for pulling only new or changed data?

• Full refresh
• Snapshot
• Incremental
• Sync-all

What type of chart would be most appropriate to compare proportions?

• Line Chart
• Pie Chart
• Histogram
• Scatter Plot

Which SQL keyword is used to remove duplicate values?

Which of the following are aggregate functions in SQL?

• SUM
• JOIN
• COUNT
• WHERE

Which of the following is a valid Looker Studio chart type?

• Radar
• Scorecard
• Gauge
• Dial