- All Exams Instant Download
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...
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....
What is the purpose of an External Function?
What is the purpose of an External Function?A . To call code that executes outside of SnowflakeB . To run a function in another Snowflake databaseC . To share data in Snowflake with external partiesD . To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: The purpose of an...
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable;B . list @%raytable;C . list @ %m.ystage;D . list @mystage;View AnswerAnswer: D Explanation: The command...
Which of the following describes external functions in Snowflake?
Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF).B . They contain their own SQL code.C . They call code that is stored inside of Snowflake.D . They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...
