← Back to exam page

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

Loading demo links...

Showing 1–3 of 20 questions

Question 1 (Topic 1)

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

Select an option, then click Submit answer.

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

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

Select an option, then click Submit answer.

  • ○ Stage integration
  • ○ Security integration
  • ○ Storage integration
  • ○ API integration
Question 3 (Topic 1)

A group of Data Analysts have been granted the role ANALYST_ROLE. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data. How should these requirements be met?

Select an option, then click Submit answer.

  • ○ Grant ANALYST_ROLE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.
  • ○ Grant SYSADMIN OWNERSHIP of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
  • ○ Make every schema in the database a MANAGED ACCESS schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
  • ○ Grant ANALYST_ROLE OWNERSHIP on the database, but grant the OWNERSHIP ON FUTURE [object type]s in database privilege to SYSADMIN.