- All Exams Instant Download
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 are value types that a VARIANT column can store? (Select TWO)
What are value types that a VARIANT column can store? (Select TWO)A . STRUCTB . OBJECTC . BINARYD . ARRAYE . CLOBView AnswerAnswer: B, D Explanation: A VARIANT column in Snowflake can store semi-structured data types. This includes: B. OBJECT: An object is a collection of key-value pairs in JSON,...
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?A . PipeB . External stageC . TaskD . StreamView AnswerAnswer: A Explanation: In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as...
What Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake. This role has the highest level of privileges and is...
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...
What is a limitation of a Materialized View?
What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functionsB . A Materialized View can only reference up to two tablesC . A Materialized View cannot be joined with other tablesD . A Materialized View cannot be defined with a JOINView AnswerAnswer: D...
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...
What would be the MOST efficient way to get the files into Snowflake?
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutesB . Create...
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).A . The table contains a column that has very low cardinalityB . DML statements that are being issued against the table are blockedC . The table has a small number...
What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affectedB . When reducing the size of a warehouse the compute resources are removed only when they are no longer...
