- All Exams Instant Download
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answersA . SnowSQLB . ODBCC . RD . HIVEView AnswerAnswer: A,B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?A . To accommodate more queriesB . To accommodate more usersC . To accommodate fluctuations in workloadD . To accommodate a more complex workloadView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
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 StageView...
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
True or False: You can define multiple columns within a clustering key on a table.
True or False: You can define multiple columns within a clustering key on a table.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSEB . START_AFTCR_CREATE = TRUE/FALSEC . START_TTIME = 60 // (seconds from now)D . STARE . TIME = CURRENF . DATE()View AnswerAnswer: A
True or False: Once created, a micro-partition will never be changed.
True or False: Once created, a micro-partition will never be changed.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/
How would you determine the size of the virtual warehouse used for a task?
How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...
What are ways to create and manage data shares in Snowflake? (Select TWO)
What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul)B . Through the DATA_SHARE=TRUE parameterC . Through SQL commandsD . Through the enable__share=true parameterE . Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: C,D
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
