Post Test ICT 8

1. What of these most accurately describes the goal of BigQuery

• BigQuery is a petabyte-scale data warehouse optimized for large amount of reading and processing data
• BigQuery is a gigabyte-scale data warehouse optimized for small amount of reading and processing data
• BigQuery is a petabyte-scale data warehouse optimized for small amount of reading and processing data
• BigQuery is a gigabyte-scale data warehouse optimized for large amount of reading and processing data

2. BigQuery utilizes … storage

• Graph
• Document
• Columnar
• Key-Value

3. A logical collection of tables is known as

• Jobs
• Schema
• Collection
• Dataset

4. From the following option which file format can’t be used in bigquery

• .db
• .avro
• .parquet
• .json

5. What is the correct statement about BigQuery

• Batch ingest is free without limit apply
• Batch ingest is free with limit apply
• Load jobs consume query capacity
• Load jobs consume memory capacity

6. You don’t need to load data into bigquery before running queries in the following situations, except

• Public datasets
• Shared datasets
• External datasources
• Internal datasources

7. What is the correct order of clauses?

• SELECT, WHERE, FROM, ORDER BY
• SELECT, FROM, WHERE, ORDER BY
• SELECT, FROM, ORDER BY, WHERE
• WHERE, FROM, SELECT, ORDER BY

8. The following SQL query will shows error, EXCEPT

• select * from customers where contactName = Ana Trujillo;
• Select customer_id, sales from customer_transaction group by customer_id
• select regionCode, regionName, sum(salesAmount) order by regionCode group by regionCode, regionName
• SELECT CustomerName,City FROM Customers where city not in ("Berlin","Mexico") ;

9. Below are true statements about aggregate function, EXCEPT

• Function that collecting single values and return one value
• Consist of min, max, count distinct, average, sum
• Usually followed with group by clause
• Usually followed with order by clause

10. Use which clause to FILTER data?

• HAVING
• ORDER BY
• WHERE
• FROM