← Back to exam page

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

Loading demo links...

Showing 19–20 of 20 questions

Question 19 (Topic 1)

A data ingestion pipeline loads data to a table randomly throughout the day. A requirement states that the data must be processed through a transformation pipeline within 10 minutes from the time that it lands in Snowflake. What is the MOST cost-effective way to meet this requirement?

Select an option, then click Submit answer.

  • ○ Use a third-party orchestration tool to execute the transformation pipeline at 5 minute intervals.
  • ○ Create a series of views that contain the transformation logic, so that the user can query the views and have access to new data as soon as it arrives.
  • ○ Create a task that runs at 5 minute intervals and executes a merge statement that queries the table. Then process any rows that have arrived since the last time the pipeline was executed.
  • ○ Create a stream on the landing table. Then create a task to run a transformation pipeline at 5 minute intervals using the SYSTEM$STREAM_HAS_DATA function.
Question 20 (Topic 1)

A global company with operations in North America, Europe, and Asia needs to secure its Snowflake environment, focus on data privacy, secure connectivity, and access control. The company uses AWS as their primary cloud provider and needs to ensure that all data transfers are secure and comply with regional regulations. How can these requirements be met? (Choose two).

Select an option, then click Submit answer.

  • ○ Configure SAML 2.0 to authenticate users in the Snowflake environment.
  • ○ Configure detailed logging and monitoring of all network traffic to and from Snowflake using Snowflake’s native capabilities.
  • ○ Use public endpoints with SSL encryption to secure data transfers between Snowflake and the company’s AWS infrastructure.
  • ○ Configure network policies to restrict access to Snowflake based on IP ranges corresponding to corporate offices.
  • ○ Use AWS PrivateLink to establish private connectivity between the company’s Snowflake account and its AWS VPCs.