nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #153

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #153: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.

Designing and Implementing Data Ingestion Solutions

Question

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do-

Options

  • AUse Datastream to connect to your on-premises database and create a stream. Have Datastream
  • BUse Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data
  • CUse Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create
  • DCreate extracts from your on-premises databases periodically, and push these extracts to Cloud

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-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.

Topics

#Data Ingestion#Real-time Data Transfer#BigQuery#On-premises Integration
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions