exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 64 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 64
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

The following code is executed in a Snowflake environment with the default settings:

What will be the result of the select statement?

  • A. SQL compilation error: Object 'CUSTOMER' does not exist or is not authorized.
  • B. John
  • C. 1
  • D. 1John
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
BigDataBB
9 months, 3 weeks ago
is impossible to read the code : (((((
upvoted 2 times
...
Maicas
10 months, 2 weeks ago
Selected Answer: C
Asumming the table is created after the transaction has begun, the DDL operation will autocommit the transaction and the Rollback won't have any effect. https://docs.snowflake.com/en/sql-reference/transactions#ddl
upvoted 1 times
...
azure_bimonster
11 months, 1 week ago
Selected Answer: A
I assume there is a Rollback in that scripting, if that's the case A would be correct.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago