- All Exams Instant Download
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query timeB . Partitions scanned is equal to partitions totalC . An AggregateOperacor node is presentD . The query...
Which command can be used to stage local files from which Snowflake interface?
Which command can be used to stage local files from which Snowflake interface?A . SnowSQLB . Snowflake classic web interface (Ul)C . SnowsightD . .NET driverView AnswerAnswer: A Explanation: SnowSQL is the command-line client for Snowflake that allows users to execute SQL queries and perform all DDL and DML operations,...
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO) A. VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A, B Explanation: Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types...
What is the default File Format used in the COPY command if one is not specified?
What is the default File Format used in the COPY command if one is not specified?A . CSVB . JSONC . ParquetD . XMLView AnswerAnswer: A Explanation: The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for...
Which of the following can be executed/called with Snowpipe?
Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF)B . A stored procedureC . A single copy_into statementD . A single insert__into statementView AnswerAnswer: C Explanation: Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within...
Which data type can be used to store geospatial data in Snowflake?
Which data type can be used to store geospatial data in Snowflake?A . VariantB . ObjectC . GeometryD . GeographyView AnswerAnswer: D Explanation: Snowflake supports two geospatial data types: GEOGRAPHY and GEOMETRY. The GEOGRAPHY data type is used to store geospatial data that models the Earth as a perfect sphere,...
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 clauseB . Incoming data can be joined with other tablesC . Columns can be reorderedD . Columns can be omittedE . Row level access...
Which Snowflake technique can be used to improve the performance of a query?
Which Snowflake technique can be used to improve the performance of a query?A . ClusteringB . IndexingC . FragmentingD . Using INDEX__HINTSView AnswerAnswer: A Explanation: Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on...
What is a responsibility of Snowflake's virtual warehouses?
What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure managementB . Metadata managementC . Query executionD . Query parsing and optimizationE . Management of the storage layerView AnswerAnswer: C Explanation: The primary responsibility of Snowflake’s virtual warehouses is to execute queries. Virtual warehouses are one of the key components...
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehousesB . The use of warehouse auto scalingC . The ability to resize warehousesD . Use of multi-clustered warehousesE . The use of warehouse indexingView AnswerAnswer: B, D Explanation: Snowflake’s architecture...
