- All Exams Instant Download
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.A . True B. FalseView AnswerAnswer: B Explanation: By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each...
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?A . Create a zero-copy clone of the worksheet and grant permissions to teammates B. Create a private Data Exchange so that any teammate can use the worksheet...
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1; B. show grants of user USER1; C. describe user USER1; D. show grants on user USER1;View AnswerAnswer: A
What tasks can be completed using the copy command? (Select TWO)
What tasks can be completed using the copy command? (Select TWO)A . Columns can be aggregated B. Columns can be joined with an existing table C. Columns can be reordered D. Columns can be omitted E. Data can be loaded without the need to spin up a virtual warehouseView AnswerAnswer:...
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data values B. Larger micro-partitions are created for common data values to reduce the number of partitions that...
What is a responsibility of Snowflake's virtual warehouses?
What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure management B. Metadata management C. Query execution D. Query parsing and optimization E. Management of the storage layerView AnswerAnswer: C
What is a limitation of a Materialized View?
What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functions B. A Materialized View can only reference up to two tables C. A Materialized View cannot be joined with other tables D. A Materialized View cannot be defined with a JOINView AnswerAnswer: D...
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).A . ORC B. XML C. Avro D. Parquet E. JSONView AnswerAnswer: D, E Explanation: Semi-structured JSON, Parquet https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
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 execution B. Querying (select) the size of the stream content...
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 operations C. Clustering keys create a distributed, parallel data structure...
