- (Exam Topic 2)
Which copy INTO command outputs the data into one file?

1. A. SINGLE=TRUE
2. B. MAX_FILE_NUMBER=1
3. C. FILE_NUMBER=1
4. D. MULTIPLE=FAISE

Correct Answer: A

- (Exam Topic 1)
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

- (Exam Topic 2)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

1. A. Data can be filtered by an optional where clause
2. B. Incoming data can be joined with other tables
3. C. Columns can be reordered
4. D. Columns can be omitted
5. E. Row level access can be defined

Correct Answer: CD

- (Exam Topic 3)
Which of the following is the Snowflake Account_Usage.Metering_History view used for?

1. A. Gathering the hourly credit usage for an account
2. B. Compiling an account's average cloud services cost over the previous month
3. C. Summarizing the throughput of Snowpipe costs for an account
4. D. Calculating the funds left on an account's contract

Correct Answer: A

- (Exam Topic 1)
What happens when a Data Provider revokes privileges to a Share on an object in their source database?

1. A. The object immediately becomes unavailable for all Data Consumers
2. B. Any additional data arriving after this point in time will not be visible to Data Consumers
3. C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
4. D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

Correct Answer: A