- All Exams Instant Download
How long is Snowpipe data load history retained?
How long is Snowpipe data load history retained?A . As configured in the create pipe settingsB . Until the pipe is droppedC . 64 daysD . 14 daysView AnswerAnswer: C Explanation: Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the...
True or False: Fail-safe can be disabled within a Snowflake account.
True or False: Fail-safe can be disabled within a Snowflake account.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach....
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...
