Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 591:

  When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  A. The Pipe load history is reset to empty

  B. The REFRESH parameter is set to TRUE

  C. Previously loaded files will be ignored

  D. All of the above

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

• Question 592:

  True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/constraints-overview.html

• Question 593:

  Which of the following statements about data sharing are true? choose 2 answers

  A. New objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts

  B. All database objects can be included In a shared database

  C. Reader Accounts are created and funded by Data Prowlers

  D. Shared databases are read-only

  Correct Answer: CD

• Question 594:

  Account-level storage usage can be monitored via:

  A. The snowflake wet Interface (UI) in the Databases section.

  B. The Snowflake web interface (UI) in the Account-> Billing a usage section

  C. The Information Schema-> ACCOUNT_USAGE_HISTORY View

  D. The Account usage Schema-> ACCOUNT_USAGE_METRICS View

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-usage-billing.html

• Question 595:

  Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy? Select one.

  A. Account-> Schema-> Database-> Table

  B. Account-> Database-> Schema-> Table

  C. Database-> Schema-> Table-> Account

  D. Database-> Table-> Schema-> Account

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 596:

  Fail-safe is unavailable on which table types?

  A. Temporary

  B. Transient

  C. Provisional

  D. Permanent

  Correct Answer: AB

  Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

• Question 597:

  True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 598:

  True or False: You can define multiple columns within a clustering key on a table.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 599:

  Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  A. The validation_mode option is used when creating an Internal Stage

  B. validation_mode=return_all_errors is a parameter of the copy command

  C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

  Correct Answer: BD

  Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

• Question 600:

  True or false: it is best practice to define a clustering key on every table.

  A. True

  B. False

  Correct Answer: B

  Reference: https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/