Welcome to the School of Data – Data Engineering Second semester Exam.
Please take the time to read these instructions before you begin the test.
We recommend you have the following ready:
NB: Once you start the exam, you are not to open any other windows. If you do, the assessment will end immediately.
The test duration is 1hr. There will be no breaks once you start.
This test comprises 30 questions, you are to answer all questions. If you do not know the answer to a given question, please select a random one and proceed to the next question.
You cannot pause this test once you begin. If you run into internet issues, we will not be liable for any inconveniences you incur. We advise you to use a good and steady internet service. You can run a speed test on FAST.COM to check the speed of your internet provider.
If you do not submit your test before the testing window eclipses, your test will be automatically submitted, and all unanswered questions will be marked 0.
Even though you are reading this now, you do not have to take this test right away if you’re unprepared. You will have access to this test until 17th July, 2023
Goodluck
0 of 30 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 30 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Which of the following best describes Google BigQuery?
Which function in BigQuery is used to convert a Extracts a JSON value and converts it to a SQL JSON-formatted STRING or JSON value. type?
Which function in BigQuery is used to Extracts a JSON array of scalar values and converts it to a SQL ARRAY<STRING> value ?
Which of the following is not a type of partitioning on Bigquery?
What are the advantages of partitioning a table?
Which of the following is not needed to create an integer-range partitioned table.
What is the minimum storage duration for the standard storage class on gcs bucket.
Which of the following is NOT a windowing function provided by Beam?
Which of the following is a type of data format that can be stored in a gcs bucket ?
The following are types of cloud functions ?
Data can be transfer between tables in different locations on bigquery?
ELTs and ETLs can be used to achieve the same goals.
Pubsub can be classified as a HTTP trigger.
What type of event trigger is used to trigger a cloud function when a new object is created, or an existing object is overwritten and a new generation of that object is created.
What are the two major type of files needed to deploy an event driven cloud function via a command line?
What is the benefit of using clustering in Google BigQuery?
What type of storage class is needed for a bucket that is accessed at least once a quarter?
What is integer range partitioning in Google BigQuery?
How does Google Cloud Functions interact with Google BigQuery?
What of the following best describes Google Cloud Functions?
The following are the components of pubdub messaging service except?
A pubsub topic can publish messages to different subscriptions
In what format is a pubsub message published to a topic?
A subscription receive messages published to different to topics.
What are the two delivery methods of pubsub messages.
How does Google Cloud Pub/Sub handle message ordering within a topic?
How does Google Cloud Pub/Sub handle message delivery to subscribers in the event of a subscriber outage or disconnection?
What is the purpose of message acknowledgments in Google Cloud Pub/Sub?
Which Google Cloud Pub/Sub API method is used to publish multiple messages in a single API call?
Which Google Cloud Pub/Sub resource is used to track the status of message delivery attempts?