Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 96 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 96
Topic #: 1
[All SnowPro Advanced Architect Questions]

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? (Choose two.)

  • A. Use a Business Intelligence tool for in-memory computation to improve performance.
  • B. Configure a dedicated virtual warehouse for the Store Manager team.
  • C. Configure the virtual warehouse to be multi-clustered.
  • D. Configure the virtual warehouse to size 4-XL.
  • E. Advise the Store Manager team to defer report execution to off-business hours.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
NachoPrendes
4 months ago
Selected Answer: BC
Agree with the answer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...