Skip to main content
ITPrepCerts
Login
Exams Free Samples About Contact
Login Create an account

SnowPro-Advanced-Architect SnowPro Advanced, Architect

  • Snowflake
  • 5 free sample questions

About this exam

SnowPro-Advanced-Architect is the Snowflake exam SnowPro Advanced, Architect. Paid practice material for this exam is not available yet, but you can try its free sample questions.

Exam code
SnowPro-Advanced-Architect
Vendor
Snowflake
Practice questions
Not available yet
Free sample questions
5
Question bank last updated
Not available yet

Try 2 sample questions

Taken from the free sample set for SnowPro-Advanced-Architect.

Question 1 (choose 4)

COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV

  1. Option A:

    GZIP

  2. Option B:

    BZ2

  3. Option C:

    BROTLI

  4. Option D:

    ZSTD

  5. Option E:

    DEFLATE

  6. Option F:

    RAW_DEFLATE

Show answer and explanation

Correct answer: A, B, D, F

AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use BROTLI instead of AUTO. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv 

Question 2

Which statement is not true about shared database?

  1. Option A:

    Shared databases are read only

  2. Option B:

    Shared databases cannot be cloned

  3. Option C:

    Time travel is not supported on a shared database 

  4. Option D:

    Shared databases can be re-shared with other accounts

Show answer and explanation

Correct answer: D

General Limitations for Shared Databases Shared databases have the following limitations for consumers: Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Shared databases and all the objects in the database cannot be forwarded (i.e. re-shared with other accounts). https://docs.snowflake.com/en/user-guide/data-share-consumers.html#general-limitations-for- shareddatabases

See all 5 free sample questions