← Back to exam page

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

Loading demo links...

Showing 13–15 of 20 questions

Question 13 (Topic 1)

An Architect is using SnowCD to investigate a connectivity issue. Which system function will provide a list of endpoints that the network must be able to access to use a specific Snowflake account, leveraging private connectivity?

Select an option, then click Submit answer.

  • ○ SYSTEM$ALLOWLIST()
  • ○ SYSTEM$GET_PRIVATELINK
  • ○ SYSTEM$AUTHORIZE_PRIVATELINK
  • ○ SYSTEM$ALLOWLIST_PRIVATELINK()
Question 14 (Topic 1)

A company needs to adopt a data modeling technique that fits this business model: 1. A virtual data warehouse is needed to support data analytics 2. Data comes from diverse sources 3. Data has frequent structural changes 4. Need the ability to audit each structural change as it happens at the source Which modeling technique will meet the company’s requirements?

Select an option, then click Submit answer.

  • ○ Data Vault modeling
  • ○ Dimensional data modeling
  • ○ Star schema modeling
  • ○ Snowflake schema modeling
Question 15 (Topic 1)

A company’s management has requested insights concerning their Snowflake usage. An Architect needs to quickly build a reporting framework for a web application which stores its data in JSON format. How can this requirement be met with the LEAST operational overhead?

Select an option, then click Submit answer.

  • ○ Define a schema for the data before it is loaded from the application, so that it is loaded in a structured way and easy to build reports on top.
  • ○ Load the semi-structured data into Snowflake and after minimal transformations, query it for the reports.
  • ○ For the data that only has top-level key-value pairs and no nesting, load it in semi-structured format. For more complex data, define a schema and then load it in a structured table.
  • ○ Share the data in the third normal form (3NF). Load the data in semi-structured format and apply transformations to normalize the data for reporting.