Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Snowflake SnowPro Advanced Architect

Snowflake SnowPro Advanced Architect Exam Practice Questions (P. 4)

  • Full Access (109 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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. A
    Set up replication to allow users to connect from outside the company VPN.
  2. B
    Provision a unique company Tri-Secret Secure key.
  3. C
    Use private connectivity from a cloud provider.
  4. D
    Set up SSO for federated authentication.
  5. E
    Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Correct Answer:
BE

Question #17
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
  1. A
    Shared databases are read-only.
  2. B
    Shared databases must be refreshed in order for new data to be visible.
  3. C
    Shared databases cannot be cloned.
  4. D
    Shared databases are not supported by Time Travel.
  5. E
    Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
  6. F
    Shared databases can also be created as transient databases.

Correct Answer:
ACE

Question #18
What integration object should be used to place restrictions on where data may be exported?
  1. A
    Stage integration
  2. B
    Security integration
  3. C
    Storage integration
  4. D
    API integration

Correct Answer:
C

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. A
    The warehouse MY_WH will be made active every five minutes to check the stream.
  2. B
    The warehouse MY_WH will only be active when there are results in the stream.
  3. C
    The warehouse MY_WH will never suspend.
  4. D
    The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Correct Answer:
A

Question #20
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?
  1. A
    The Connector only works in Snowflake regions that use AWS infrastructure.
  2. B
    The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
  3. C
    The Connector creates and manages its own stage, file format, and pipe objects.
  4. D
    Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Correct Answer:
C

Previous Questions Next Questions

All Pages