This Quiz contains totally 25 Questions each carry 1 point for you.
1.What is Google BigQuery?
A data warehouse
A relational database
A non-relational database
An image recognition service
Correct!
Wrong!
2.What is the maximum amount of data that BigQuery can process?
1 TB
10 TB
100 TB
Petabytes of data
Correct!
Wrong!
3.Which of the following cannot be changed after a dataset in BigQuery is created?
Default table expiration
Default partition expiration
Dataset description
Dataset location
Correct!
Wrong!
4.Which of the following types of tables are supported by BigQuery?
Standard tables
Partitioned tables
External tables
All of the above
Correct!
Wrong!
5.Which SQL standard does BigQuery use?
ANSI SQL
T-SQL
PL/SQL
MySQL
Correct!
Wrong!
6.How do you limit the number of rows returned in a BigQuery SQL query?
USING LIMIT
BY LIMIT
WITH LIMIT
LIMIT
Correct!
Wrong!
7.How can you improve the performance of a BigQuery query?
By using denormalized data
By using normalized data
By using a smaller dataset
By increasing the number of nodes
Correct!
Wrong!
8.What is the maximum number of slots available per project in BigQuery?
1000
2000
5000
No limit
Correct!
Wrong!
9.Which of the following is not a method of controlling access to data in BigQuery?
IAM roles
Access control lists (ACLs)
IP whitelisting
Authorized views
Correct!
Wrong!
10.How can you monitor BigQuery usage?
Using Google Cloud Monitoring
Using the BigQuery console
Using logs in BigQuery
All of the above
Correct!
Wrong!
11.What does BigQuery ML (BQML) enable users to do?
Create and execute machine learning models in BigQuery
Import machine learning models into BigQuery
Export machine learning models from BigQuery
None of the above
Correct!
Wrong!
12.How can data in BigQuery tables be partitioned?
By date
By integer range
Both a) and b)
None of the above
Correct!
Wrong!
13.Which function is used to extract a part of a STRING in BigQuery SQL?
SUBSTR
STRSUB
STRCUT
CUTSTR
Correct!
Wrong!
14.Why is it beneficial to use partitioned tables in BigQuery?
They improve query performance and reduce costs
They increase the storage capacity of BigQuery
They automatically delete old data
They allow for more concurrent queries
Correct!
Wrong!
15.Which of the following is not a type of audit logs in BigQuery?
Admin activity logs
Data access logs
System event logs
User activity logs
Correct!
Wrong!
16.What is the primary unit for billing in BigQuery?
Gigabytes (GB)
Terabytes (TB)
Queries
Storage
Correct!
Wrong!
17.How can you copy a table structure without copying the data in BigQuery?
Using the CREATE TABLE AS SELECT statement
Using the INSERT INTO statement
Using the CREATE TABLE statement with a schema definition
It is not possible to copy only the table structure
Correct!
Wrong!
18.Which aggregate function can be used to calculate the average of a column in BigQuery?
AVG
SUM
COUNT
MAX
Correct!
Wrong!
19.What is the purpose of caching in BigQuery?
To improve query performance by storing results
To reduce storage costs by compressing data
To secure data access by encrypting results
To automate data backups for disaster recovery
Correct!
Wrong!
20.What does the concept of "least privilege" mean in the context of BigQuery security?
Granting users with the fewest permissions required
Granting users with full administrative access
Granting users with read-only access
Granting users with unrestricted access to all data
Correct!
Wrong!
21.What is the maximum size of a single query result in BigQuery?
1 GB
10 GB
100 GB
1 TB
Correct!
Wrong!
22.Which statement is true about schema updates in BigQuery?
Schema updates are not allowed after a table is created
Schema updates can only be made by BigQuery administrators
Schema updates can be performed on existing tables
Schema updates can only be made during table creation
Correct!
Wrong!
23.What is the purpose of the GROUP BY clause in BigQuery SQL?
To filter rows in a table
To sort the query result
To group rows based on a specified column
Correct!
Wrong!
24.Which option can help reduce query costs in BigQuery?
Using cached query results
Increasing the number of virtual CPUs
Enabling audit logs
Storing data in separate projects
Correct!
Wrong!
25.What is the purpose of customer-managed encryption keys (CMEK) in BigQuery?
To provide an additional layer of data encryption
To manage user access and permissions
To monitor query performance and resource utilization
To control access to BigQuery resources
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
GCP Data Engineering BigQuery – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...