- All Exams Instant Download
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.A . TrueB . FalseView AnswerAnswer: B
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
Which of the following are common use cases for zero-copy cloning? Choose 3 answersA . Quick provisioning of Dev and Test/QA environmentsB . Data backupsC . Point in time snapshotsD . Performance optimizationView AnswerAnswer: A,B,C
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:A . The primary duster in the virtual warehouseB . The entire Virtual WarehouseC . The database the Virtual Warehouse resides inD . The queries currently being run by the Virtual WarehouseView AnswerAnswer: B
The FLATEEN function is used to query which type of data in Snowflake?
The FLATEEN function is used to query which type of data in Snowflake?A . Structured dataB . Semi-structured dataC . Both of the aboveD . None of the aboveView AnswerAnswer: B
Which of the following statements are true of Snowflake data loading? Choose 3 answers
Which of the following statements are true of Snowflake data loading? Choose 3 answersA . VARIANT "nut" values are not the same as SQL Null valuesB . It is recommended to do frequent, single row DMLSC . It is recommended to validate the data before loading into the Snowflake target...
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.A . TrueB . false:View AnswerAnswer: B
which of the following are valid approaches to loading data into a snowflake table? select
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.A . Bulk copy from an External StageB . Continuous load using Snowpipe REST APIC . The Snowflake Web Interface (UT) data loading wizardD . Bulk copy from an Internal StageView...
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.A . TrueB . FalseView AnswerAnswer: B
True or False: All Snowflake table types include fail-safe storage.
True or False: All Snowflake table types include fail-safe storage.A . TrueB . FalseView AnswerAnswer: B
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?A . Account -> Schema -> Database -> TableB . Account -> Database -> Schema -> TableC . Database -> Schema -> Table -> AccountD . Database -> Table -> Schema -> AccountView AnswerAnswer: B
