- All Exams Instant Download
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 . ParquetC . CSV (Gzipped)D . ORCView AnswerAnswer: B Explanation: Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query...
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: B, C, D Explanation: The Information Schema and Account Usage Share in Snowflake provide metadata and historical usage data for various objects...
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reader accounts in Snowflake are designed to allow users to read data shared with them but do not have the capability to extract data...
What does the STRIP_OUTER_ARRAY file format do?
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array.B . It removes the outer array structure and loads...
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stagesB . Incremental backupsC . Time TravelD . Zero-copy clonesE . Fail-safeView AnswerAnswer: C, E Explanation: Snowflake’s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human...
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 stage type can be altered and dropped?
Which stage type can be altered and dropped?A . Database stageB . External stageC . Table stageD . User stageView AnswerAnswer: B Explanation: External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored....
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret SecureB . Automatic encryption of all dataC . Up to 90 days of data recovery through Time TravelD . Object-level access controlE . Column-level security to apply data masking policies...
User-level network policies can be created by which of the following roles? (Select TWO).
User-level network policies can be created by which of the following roles? (Select TWO).A . ROLEADMINB . ACCOUNTADMINC . SYSADMIND . SECURITYADMINE . USERADMINView AnswerAnswer: B, D Explanation: User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN...
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;C . GRANT MODIFY...
