Snowflake Questions with Complete Solutions

Snowflake Questions with Complete Solutions When unloading (or extracting) data using a Query, you can extract data from Multiple tables joined together a view a single table What are some of the ways to improve performance of an external table? Partition the external table (if the logical folder structure permits) Create materialized views on top of the external table You can unload (or extract) data from Snowflake using which of the following mechanisms? Unload/Extract using a query Unload/extract from a table Which of the following statements are true about Encryption in Snowflake? All files stored in internal stages automatically encrypted Supports encryption using customer provided keys all data inside snowflake is automatically encrypted Which of the following statements are true when data is UNLOADED into a Snowflake stage (internal or external). The customer downloads data from the internal stage and decrypts the data on their own machine if the data is unloaded into an external stage the data is not automatically encrypted however the customer can choose to encrypt as an option if the data is unloaded into an internal stage the data is automatically encrypted Which of the following are valid Snowflake stage types? Table stage Internal Stage External Stage Select what are the features of External tables in Snowflake? views can be created on top of external tables they can be joined with other tables they are read only When unloading data from Snowflake, what are the places where an output format of the file can be specified? in the definition of the named stage in the definition of a table itself specified as an option directly in the copy command Which of the following data types are treated as VARCHAR "under the covers" by Snowflake? char text string character A string constant in Snowflake can be enclosed by single quotes $ symbol Which of the following are supported file formats when UNLOADING data from Snowflake? Parquet json delimited text Which of the following are options when creating a new virtual warehouse. Select all that apply auto resume auto suspend A consumer of a shared database can add new tables or views in the shared database? False What is the lowest snowflake edition that allows customer dedicated virtual warehouses? standard Which of the following will contribute to your account level storage usage? UDF // Database // Views // Snowflake External Stages // Snowflake internal stage Snowflake internal stage // Database Which minimum Snowflake license allows Mulitcluster data virtual warehouse capability? enterprise Users created in a reader account can not do which of the following? Update // Select // Insert // Load data update load data insert Which of the following is true regarding Roles in Snowflake? A snowflake user can have one or many roles users in snowflake can only have a max of 10 roles assigned in addition to roles privileges may be directly assigned to a named user for an active user session only one role can be the active role at a given time A snowflake user can have one or many roles for an active user session only one role can be the active role at a given time The "load metadata" (which maintains which files have already been loaded) for a table expires after how many days? 64 Which of the following actions can not be performed by the consumer of a shared database? create a new table in the shared database view the list of tables in a shared database use shared data in complex queries insert data in a shared table create a new table in the shared database insert data in a shared table What are some of the ways to improve performance in Snowflake? Select all that apply secondary indices multi clustering virtual warehouse query result caching dedicated virtual warehouse clustering keys multi clustering virtual warehouse query result caching dedicated virtual warehouse clustering keys What are some of the ways to improve performance in Snowflake? Select all that apply Secondary indices Multi Clustering virtual warehouse query result caching dedicated virtual warehouse Multi Clustering virtual warehouse query result caching dedicated virtual warehouse