Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

Snowflake SnowPro Advanced Architect Exam Actual Questions

The questions for SnowPro Advanced Architect were last updated on Nov. 1, 2024.
  • Viewing page 1 out of 28 pages.
  • Viewing questions 1-4 out of 109 questions
 

Topic 1 - Exam A

Question #1 Topic 1

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

  • A. The MERGE command
  • B. The UPSERT command
  • C. The CHANGES clause
  • D. A STREAM object
  • E. Thee CHANGE_DATA_CAPTURE command
Reveal Solution Hide Solution   Discussion   4

Correct Answer: CD 🗳️

Question #2 Topic 1

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

  • A. CSV
  • B. XML
  • C. Avro
  • D. JSON
  • E. Parquet
Reveal Solution Hide Solution   Discussion   4

Correct Answer: CD 🗳️

Question #3 Topic 1

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

  • A. Global
  • B. Database
  • C. Schema
  • D. Table
Reveal Solution Hide Solution   Discussion   13

Correct Answer: A 🗳️

Question #4 Topic 1

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.
Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

  • A. COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
  • B. COPY INTO tablea FROM @%tablea;
  • C. COPY INTO tablea FROM @%tablea FILES = ('file5.csv');
  • D. COPY INTO tablea FROM @%tablea FORCE = TRUE;
  • E. COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
  • F. COPY INTO tablea FROM @%tablea MERGE = TRUE;
Reveal Solution Hide Solution   Discussion   14

Correct Answer: BC 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel