← Back to exam page

Free SNOWPRO-ADVANCED-ARCHITECT – Snowflake SNOWPRO-ADVANCED-ARCHITECT Practice Test Question

Loading demo links...

Showing 7–9 of 20 questions

Question 7 (Topic 1)

Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Choose two.)

Select an option, then click Submit answer.

  • ○ Snowflake cannot handle the joins implied in a 3NF data model.
  • ○ The Architect wants to remove data duplication from the data stored in Snowflake.
  • ○ The Architect is designing a landing zone to receive raw data into Snowflake.
  • ○ The BI tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.
  • ○ The Architect wants to present a simple flattened single view of the data to a particular group of end users.
Question 8 (Topic 1)

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.)

Select an option, then click Submit answer.

  • ○ Use a Business Intelligence tool for in-memory computation to improve performance.
  • ○ Configure a dedicated virtual warehouse for the Store Manager team.
  • ○ Configure the virtual warehouse to be multi-clustered.
  • ○ Configure the virtual warehouse to size 4-XL.
  • ○ Advise the Store Manager team to defer report execution to off-business hours.
Question 9 (Topic 1)

When using the COPY INTO [table] command with the CSV file format, how does the MATCH_BY_COLUMN_NAME parameter behave?

Select an option, then click Submit answer.

  • ○ It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
  • ○ The parameter will be ignored.
  • ○ The command will return an error.
  • ○ The command will return a warning stating that the file has unmatched columns.