SnowPro Advanced Architect Practice Test

SnowPro Advanced Architect Practice Test practice questions, page 4 of 10, with answer review and explanations.

Question 16

A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins. What Snowflake functionality should be used to meet these requirements? (Choose two.)

  1. Set up replication to allow users to connect from outside the company VPN.
  2. Provision a unique company Tri-Secret Secure key.
  3. Use private connectivity from a cloud provider.
  4. Set up SSO for federated authentication.
  5. Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Question 17

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

  1. Shared databases are read-only.
  2. Shared databases must be refreshed in order for new data to be visible.
  3. Shared databases cannot be cloned.
  4. Shared databases are not supported by Time Travel.
  5. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
  6. Shared databases can also be created as transient databases.

Question 18

What integration object should be used to place restrictions on where data may be exported?

  1. Stage integration
  2. Security integration
  3. Storage integration
  4. API integration

Question 19

The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

  1. The warehouse MY_WH will be made active every five minutes to check the stream.
  2. The warehouse MY_WH will only be active when there are results in the stream.
  3. The warehouse MY_WH will never suspend.
  4. The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Question 20

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

  1. The Connector only works in Snowflake regions that use AWS infrastructure.
  2. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
  3. The Connector creates and manages its own stage, file format, and pipe objects.
  4. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.