- All Exams Instant Download
Which are true of Snowflake roles?
Which are true of Snowflake roles?A . All grants to objects are given to roles, and never to users B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation C. The public role controls at...
When unloading to a stage, which of the following is a recommended practice or approach?
When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger files B. Use OBJECT_CONSTRUCT ( * ) when using Parquet C. Avoid the use of the CAST function D. Define an individual file formatView AnswerAnswer: C
What is the MOST performant file format for loading data in Snowflake?
What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped) B. Parquet C. CSV (Gzipped) D. ORCView AnswerAnswer: A
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . True B. FalseView AnswerAnswer: B
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clause B. Incoming data can be joined with other tables C. Columns can be reordered D. Columns can be omitted E. Row level access...
