Which of the following is true of Snowpipe via REST API? Choose 2 answersA . you can only use it on internal StagesB . All COPY INTO options are available fluting pipe creationC . Snowflake automatically manages the compute required to execute the Pipe’s copy into commandsD . Snowpipe keeps track of which files...
What command is used to load files into an Internal Stage within Snowflake?
What command is used to load files into an Internal Stage within Snowflake?A . PUTB . COPY INTOC . TRANSFERD . INSERT View Answer Answer: A Explanation: You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command...
True or False: All Snowflake table types include fail-safe storage.
True or False: All Snowflake table types include fail-safe storage.A . TrueB . False View Answer Answer: B...
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.B . Clustering keys sort the designated columns over time, without blocking DML operationsC . Clustering keys create a distributed, parallel data structure of pointers to a...
What are the default Time Travel and Fail-safe retention periods for transient tables?
What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel – 1 day. Fail-safe – 1 dayB . Time Travel – 0 days. Fail-safe – 1 dayC . Time Travel – 1 day. Fail-safe – 0 daysD . Transient tables are retained in neither Fail-safe nor Time Travel...
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul)B . Via the data_share=true parameterC . Via SQL commandsD . Via Virtual Warehouses View Answer Answer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html...
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two)B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are...
What privileges are required to create a task?
What privileges are required to create a task?A . The global privilege create task is required to create a new task.B . Tasks are created at the Application level and can only be created by the Account Admin role.C . Many Snowflake DDLs are metadata operations only, and create task DDL can be executed...
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
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 Stage View Answer Answer: A,B,C...
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.A . TrueB . False View Answer Answer: B...