PROFESSIONAL-DATA-ENGINEER · Question #396
PROFESSIONAL-DATA-ENGINEER Question #396: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #396. The question stem and answer options stay visible for context.
Question
You are administering a BigQuery on-demand environment. Your business intelligence tool is submitting hundreds of queries each day that aggregate a large (50 TB) sales history fact table at the day and month levels. These queries have a slow response time and are exceeding cost expectations. You need to decrease response time, lower query costs, and minimize maintenance. What should you do?
Options
- ABuild materialized views on top of the sales table to aggregate data at the day and month level.
- BBuild authorized views on top of the sales table to aggregate data at the day and month level.
- CEnable Bl Engine and add your sales table as a preferred table.
- DCreate a scheduled query to build sales day and sales month aggregate tables on an hourly basis.
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.