- All Exams Instant Download
How can this data be shared?
A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?A . The healthcare company will need to change the institute’s Snowflake edition in the accounts...
Following objects can be cloned in snowflake
Following objects can be cloned in snowflakeA . Permanent table B. Transient table C. Temporary table D. External tables E. Internal stagesView AnswerAnswer: A,B,C Explanation: For tables, Snowflake supports cloning permanent and transient tables; temporary tables can be cloned only to a temporary table or a transient table. For databases...
Which permission sets must be granted to this role?
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db...
How can a Snowflake Architect meet this requirement with the LEAST amount of coding?
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding?...
Which command can be run to list all shares that have been created in your account or are available to consume by your account
Which command can be run to list all shares that have been created in your account or are available to consume by your accountA . SHOW SHARES B. LIST SHARES C. DESCRIBE SHARESView AnswerAnswer: A Explanation: SHOW SHARES Lists all shares available in the system: Outbound shares (to consumers) that...
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSVA . GZIP B. BZ2 C. BROTLI D. ZSTD E. DEFLATE F. RAW_DEFLATEView AnswerAnswer: A,B,D,E,F Explanation: AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use...
When would you usually consider to add clustering key to a table
When would you usually consider to add clustering key to a tableA . The performance of the query has deteriorated over a period of time. B. The number of users querying the table has increased C. it is a multi-terabyte size table D. The table has more than 20 columnsView...
You need to choose a high cardinality column for the clustering key
You need to choose a high cardinality column for the clustering keyA . TRUE B. FALSEView AnswerAnswer: B Explanation: A column with very low cardinality (e.g. a column that indicates only whether a person is male or female) might yield only minimal pruning. At the other extreme, a column with...
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
Which alter command below may affect the availability of column with respect to time travel?
Which alter command below may affect the availability of column with respect to time travel?A . ALTER TABLE...DROP COLUMN B. ALTER TABLE...SET DATA TYPE C. ALTER TABLE...SET DEFAULTView AnswerAnswer: B Explanation: If the precision of a column is decreased below the maximum precision of any column data retained in Time...
