PROFESSIONAL-DATA-ENGINEER · Question #277
PROFESSIONAL-DATA-ENGINEER Question #277: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #277. The question stem and answer options stay visible for context.
Question
Your company wants to be able to retrieve large result sets of medical information from your current system, which has over 10 TBs in the database, and store the data in new tables for further query. The database must have a low-maintenance architecture and be accessible via SQL. You need to implement a cost-effective solution that can support data analytics for large result sets. What should you do?
Options
- AUse Cloud SQL, but first organize the data into tables. Use JOIN in queries to retrieve data.
- BUse BigQuery as a data warehouse. Set output destinations for caching large queries.
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.