ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

Exam SnowPro Advanced Architect topic 1 question 32 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 32
Topic #: 1
[All SnowPro Advanced Architect Questions]

Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.
How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

  • A. Use Snowpipe with auto-ingest.
  • B. Use a COPY command with a task.
  • C. Use a materialized view on an external table.
  • D. Use the COPY INTO command.
  • E. Use a combination of a task and a stream.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by hillcat111 at June 9, 2023, 12:11 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
MSIDDIQUI18
7 months, 1 week ago
According to following statement "C" is correct, but I am not 100% sure, if this logic applied here: "In many cases, the Materialized view on an external table can provide performance that is faster than equivalent queries over the underline External table. "
upvoted 1 times
...
KindleAce
7 months, 1 week ago
AC Task is using cronjob syntax, which means minimum interval is 60 seconds
upvoted 1 times
...
h8er
1 year, 1 month ago
Selected Answer: AE
A&E is my guess
upvoted 2 times
...
chiiiik
1 year, 3 months ago
Selected Answer: AE
A is definitely valid Correct me if I'm wrong. E is also valid because if we set STREAM_HAS_DATA it will trigger the task to run to insert data although schedule has been set.
upvoted 2 times
ivanjs44
1 year, 2 months ago
I think this is also true but the question says: with the LEAST amount of coding
upvoted 1 times
ivanjs44
1 year, 2 months ago
Sorry, I think STREAM_HAS_DATA can not change the scheduling of a task: This function is intended to be used in the WHEN expression in the definition of tasks. If the specified stream contains no change data, the task skips the current run. And this can not be correct because of the charemski comment.
upvoted 1 times
...
...
...
charemski
1 year, 11 months ago
Selected Answer: AC
Minimum schedule time for a task is 60 seconds, so in this case only Snowpipe or Materialized View on External Table, in either case using event notification service https://docs.snowflake.com/en/user-guide/tables-external-intro#materialized-views-over-external-tables
upvoted 3 times
...
hillcat111
1 year, 11 months ago
Answer is A,B and is validated
upvoted 1 times
dormin
1 year, 10 months ago
COPY command does not exist (option b).
upvoted 1 times
...
...
starkbi
1 year, 12 months ago
Selected Answer: AB
A: Just define one object: the Pipe object with included COPY INTO ... FROM Stage ... command B: Just define one object: the scheduled Task object with included COPY INTO ... FROM Stage ... command
upvoted 1 times
...
hillcat111
2 years ago
I think A & C are the answers
upvoted 2 times
hillcat111
2 years ago
A & E is the right answer
upvoted 1 times
...
...
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