blog

Question 7Which of the following are valid join queries for Impala? Check all that apply. 1 point SELECT o.office_id as office, AVG(salary) AS avg_salary FROM california_emp e JOIN california_offices o…

Question 6The california_offices and california_emp tables each have a column named office_id. All other columns have unique names between the two tables. Which of the following are valid join queries…

Question 4The zip column (type INT) in the california_offices table has values from 90001 to 95899. The zip column (also type INT) in the oregon_offices table has values from 97030…

Question 3Choose the best query to run in Impala to return the distinct union of the columns zip_plus_4 (type STRING, has values like ‘94306-0001’) in the california_emp table and zip…

Question 2Which of these queries produces the same result set as the following query? SELECT * FROM table1 UNION SELECT * FROM table2; 1 point SELECT * FROM table1 UNION…

Question 10In what order does a SQL engine execute the clauses of a SELECT statement? 1 point FROM, WHERE, SELECT, GROUP BY, HAVING, ORDER BY, LIMIT FROM, WHERE, GROUP BY,…

Question 9Select the appropriate uses for the LIMIT clause. Check all that apply. 1 point Filter individual rows based on conditions Protect against returning an unexpectedly large number of rows…

Question 8Which clause should you use with Impala to return rows 1001 through 1050 of a result set? 1 point OFFSET 1001,1050 OFFSET 1001 LIMIT 1050 LIMIT 1001,1050 LIMIT 50…

Question 7Select the valid SQL queries. Check all that apply. 1 point SELECT arr_time, AVG(arr_delay) AS avg_arr_delay FROM flights WHERE origin = ‘LAX’ GROUP BY arr_time HAVING avg_arr_delay > 45…

Question 6Select the queries that will run without error in Hive. Check all that apply. 1 point SELECT model FROM fly.planes ORDER BY type; SELECT model, year FROM fly.planes ORDER…