- All Exams Instant Download
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 filesB . Use OBJECT_CONSTRUCT ( * ) when using ParquetC . Avoid the use of the CAST functionD . Define an individual file formatView AnswerAnswer: D Explanation: When...
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of valuesB . Micro-partitions are immutable objects that support the use of Time Travel.C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehousesD . Rows are automatically stored...
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the...
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 operationsC . Clustering keys create a distributed, parallel data structure...
Which Snowflake feature is used for both querying and restoring data?
Which Snowflake feature is used for both querying and restoring data?A . Cluster keysB . Time TravelC . Fail-safeD . CloningView AnswerAnswer: B Explanation: Snowflake’s Time Travel feature is used for both querying historical data in tables and restoring and cloning historical data in databases, schemas, and tables3. It allows...
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 Explanation: The correct command to view all roles granted to a...
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: Snowflake’s architecture allows for the use of a query result cache that stores the results of queries for a period...
What happens when an external or an internal stage is dropped? (Select TWO).
What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is droppedB . When dropping an external stage, both the stage and the files within the stage are removedC . When dropping...
In which use cases does Snowflake apply egress charges?
In which use cases does Snowflake apply egress charges?A . Data sharing within a specific regionB . Query result retrievalC . Database replicationD . Loading data into SnowflakeView AnswerAnswer: C Explanation: Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region...
Which statements will provide this access?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;...
