PROFESSIONAL-DATA-ENGINEER · Question #5
PROFESSIONAL-DATA-ENGINEER Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Question
An external customer provides you with a daily dump of data from their database. The data flows into Google Cloud Storage GCS as comma-separated values (CSV) files. You want to analyze this data in Google BigQuery, but the data could have rows that are formatted incorrectly or corrupted. How should you build this pipeline?
Options
- AIssue a command to restart the database servers.
- BRetry the query with exponential backoff, up to a cap of 15 minutes.
- CRetry the query every second until it comes back online to minimize staleness of data.
- DReduce the query frequency to once every hour until the database comes back online.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.