nerdexam
SnowflakeSnowflake

ARA-C01 · Question #151

ARA-C01 Question #151: Real Exam Question with Answer & Explanation

Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.

Performance Optimization

Question

A retail company has 2000+ stores spread across the country. Store Managers report that they are having trouble running key reports related to inventory management, sales targets, payroll, and staffing during business hours. The Managers report that performance is poor and time-outs occur frequently. Currently all reports share the same Snowflake virtual warehouse. How should this situation be addressed? (Select TWO).

Options

  • AUse a Business Intelligence tool for in-memory computation to improve performance.
  • BConfigure a dedicated virtual warehouse for the Store Manager team.
  • CConfigure the virtual warehouse to be multi-clustered.
  • DConfigure the virtual warehouse to size 4-XL
  • EAdvise the Store Manager team to defer report execution to off-business hours.

Unlock ARA-C01 to see the answer

You've previewed enough free ARA-C01 questions. Unlock ARA-C01 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

#Virtual Warehouses#Multi-cluster Warehouses#Workload Management#Concurrency
Full ARA-C01 PracticeBrowse All ARA-C01 Questions