support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. SnowPro Advanced Architect

Free SnowPro Advanced Architect Exam Braindumps
SnowPro Advanced Architect Questions 36–40 (page: 9)

Updated On: 10-Feb-2026
Page 9 of 23
PDF with 254 Questions

An Architect would like to save quarter-end financial results for the previous six years.

Which Snowflake feature can the Architect use to accomplish this?

  1. Search optimization service
  2. Materialized view
  3. Time Travel
  4. Zero-copy cloning
  5. Secure views

Answer(s): D



A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps:

Confirmed Private Link URLs are working by logging in with a username/password account

Verified DNS resolution by running nslookups against Private Link URLs

Validated connectivity using SnowCD

Disabled public access using a network policy set to use the company's IP address range

However, the following error message is received when using SSO to log into the company account:

IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.

What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

  1. Alter the Azure security integration to use the Private Link URLs.
  2. Add the IP address in the error message to the allowed list in the network policy.
  3. Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
  4. Update the configuration of the Azure AD SSO to use the Private Link URLs.
  5. Open a case with Snowflake Support to authorize the Private Link URLs' access to the account.

Answer(s): B,C



Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

  1. Choose columns that are frequently used in join predicates.
  2. Choose lower cardinality columns to support clustering keys and cost effectiveness.
  3. Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
  4. Choose cluster columns that are most actively used in selective filters.
  5. Choose cluster columns that are actively used in the GROUP BY clauses.

Answer(s): A,D



Which Snowflake data modeling approach is designed for BI queries?

  1. 3 NF
  2. Star schema
  3. Data Vault
  4. Snowflake schema

Answer(s): D



How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

  1. A task scheduled in a UTC-based schedule will have no issues with the time changes.
  2. Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
  3. A task will move to a suspended state during the daylight savings time change.
  4. A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
  5. A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Answer(s): B,D



  PDF
Viewing page 9 of 23
Viewing questions 41 - 45 out of 254 questions


Post your Comments and Discuss Snowflake SnowPro Advanced Architect exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!