Explore topic-wise InterviewSolutions in .

Which of the following media FILES can BigQuery API upload in GCP?
Choose the correct option from below list
(1)JPEG
(2)PDF
(3)All of the OPTIONS
(4)MP4
(5)ZIP

Answer:-(3)All of the options

Except "QUERY Job", the rest of the JOBS in BIGQUERY are asynchronous.
Choose the correct OPTION from below list
(1)False
(2)True

Answer:-(1)False

The data to be loaded into the BigQuery from the cloud storage can be of ______ format.
Choose the CORRECT option from below LIST
(1)CSV
(2)ORC
(3)All the OPTIONS
(4)JSON
(5)Avro
(6)Parquet

Answer:-(3)All the options

Which of the following option about Google BigQuery is INCORRECT?
Choose the correct option from below list
(1)BigQuery is an open source
(2)Neither RELATIONAL nor NoSQL
(3)Cloud-based analytical database
(4)SQL compatible

Answer:-(1)BigQuery is an open source

Google BigQuery is NEITHER RELATIONAL nor NoSQL.
Choose the CORRECT OPTION from below list
(1)False
(2)True

Answer:-(2)True

_______ accounts are recommended as a locally DEVELOPING or production application.
Choose the CORRECT OPTION from below list
(1)SERVICE Accounts
(2)User Accounts
(3)API keys

Answer:-(1)Service Accounts

Which property does BigQuery use to de-duplicate data in a streaming job?
Choose the correct OPTION from below list
(1)insertId
(2)ROWID
(3)insertKey
(4)rowKey

Answer:-(1)insertId

BigQuery JOBS are used for performing __ actions.
Choose the correct OPTION from below list
(1)Extract
(2)QUERY
(3)All of the OPTIONS
(4)COPY
(5)Load

Answer:-(3)All of the options

Who are allowed to change the access control LISTS on the datasets?
Choose the correct OPTION from below list
(1)Writers
(2)READERS
(3)Owners
(4)All of the options

Answer:-(3)Owners

For loading streaming data, BigQuery uses ____________ method.
Choose the correct option from below LIST
(1)tabledata().insert()
(2)tabledata().insertAll()
(3)tabledata().streamload()
(4)tabledata().streamAll()

ANSWER:-(2)tabledata().insertAll()

The SENT out information in Google BigQuery is composed as __________.
CHOOSE the correct option from below list
(1)Tables
(2)COLUMNS
(3)All of the OPTIONS
(4)Rows

Answer:-(3)All of the options

________ are responsible for controlling ACCESS to all the underlying tables.
Choose the correct OPTION from below list
(1)Schema
(2)Jobs
(3)Datasets
(4)All of the options

Answer:-(3)Datasets

The SENT out information in Google BIGQUERY is composed as _____.
Choose the correct option from below list
(1)Columns
(2)All of the OPTIONS
(3)TABLES
(4)Rows

Answer:-(2)All of the options

Which of the following part of a JOB contains errors and warnings?
Choose the correct option from below list
(1)Configuration
(2)STATUS
(3)Reference
(4)Job Statistics

Answer:-(2)Status

______ are considered as the PRIMARY UNIT of sharing in Google BigQuery.
Choose the correct option from below list
(1)DATASETS
(2)SCHEMA
(3)Jobs
(4)Both Datasets and Jobs

Answer:-(1)Datasets

Which of the following aggregate function RETURNS the average?
Choose the CORRECT OPTION from below list
(1)FIRST()
(2)MAX()
(3)COUNT()
(4)AVG()

Answer:-(4)AVG()

Which of the following options refer to the OBJECTS in Google BigQuery?
Choose the CORRECT OPTION from below list
(1)None of the options
(2)Identifiers
(3)Identifiers and REFERENCES
(4)References

Answer:-(3)Identifiers and References

A JSON OBJECT returned by the API to get the individual name components are known as _______.
Choose the CORRECT option from below list
(1)References
(2)Identifiers
(3)None of the options
(4)Identifiers and References

Answer:-(1)References

________________ in BigQuery get executed as soon as possible.
Choose the correct OPTION from below LIST
(1)None of the options
(2)Interactive Queries
(3)Both Interactive and Batch Queries
(4)Batch Queries

Answer:-(2)Interactive Queries

A logical collection of tables is known as _____.
CHOOSE the CORRECT option from below list
(1)DATASETS
(2)Jobs
(3)Collection
(4)Schema

Answer:-(1)Datasets

Which of the following JOIN returns the records that match the values for the join columns from both the tables on the join?
CHOOSE the correct option from below LIST
(1)Right outer join
(2)Inner joins
(3)Left outer join
(4)FULL outer join

Answer:-(2)Inner joins

BiQuery STREAM DATA loading is a SYNCHRONOUS job.
Choose the CORRECT option from below list
(1)False
(2)True

Answer:-(1)False

A logical collection of tables is KNOWN as _______.
CHOOSE the CORRECT option from below list
(1)Datasets
(2)Collection
(3)Jobs
(4)Schema

Answer:-(1)Datasets

Which of the following SQL statement sets the conditions in QUERY?
Choose the correct OPTION from below list
(1)SELECT
(2)FROM
(3)WHERE
(4)GROUP BY

Answer:-(3)WHERE

______ are the DEFAULT QUERIES in BigQuery.
Choose the correct option from below LIST
(1)Both Interactive and Batch Queries
(2)NONE of the options
(3)Interactive Queries
(4)Batch Queries

Answer:-(3)Interactive Queries

________ method/methods allows/allow you to run a query and get the RESULTS in a single API call.
Choose the CORRECT OPTION from below list
(1)Jobs.insert()
(2)Jobs.query() and Jobs.getQueryResults()
(3)Jobs.query()
(4)Jobs.getQueryResults()

Answer:-(2)Jobs.query() and Jobs.getQueryResults()

Which of the following aggregate FUNCTION returns the total number of values?
Choose the CORRECT OPTION from below list
(1)MAX()
(2)FIRST()
(3)AVG()
(4)COUNT()

ANSWER:-(4)COUNT()

Which of the following OPTION is responsible for binding the data between TWO or more tables?
Choose the CORRECT option from below list
(1)JOINS
(2)UNION
(3)None of the options
(4)Both JOINS and UNION

Answer:-(1)JOINS

Which of the FOLLOWING options/option are/is not supported while loading the data from a LOCAL data SOURCE using Web UI?
Choose the CORRECT option from below list
(1)Wildcards and commas
(2)Only Commas
(3)Only Wildcards
(4)dots

Answer:-(1)Wildcards and commas

Which of the following options are the primitive field types in Google BIGQUERY SCHEMA?
Choose the CORRECT option from below list
(1)All of the options
(2)FLOAT
(3)INTEGER
(4)TIMESTAMP
(5)STRING
(6)BOOLEAN

Answer:-(1)All of the options