ExamTopics Logo
Mail Us[email protected]
Menu
 

SnowPro Advanced Architect Actual Exam Questions

Last updated on Nov. 27, 2024.
Vendor:Snowflake
Exam Code:SnowPro Advanced Architect
Exam Name:SnowPro Advanced Architect
Exam Questions:109
97% Passed the exam with this material
 

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 🗳️

file Viewing page 1 out of 28 pages.
Viewing questions 1-4 out of 109 questions
Next Questions
Browse atleast 50% to increase passing rate cup
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.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago