- All Exams Instant Download
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.A . True B. FalseView AnswerAnswer: B Explanation: By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each...
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 Secure B. Automatic encryption of all data C. Up to 90 days of data recovery through Time Travel D. Object-level access control E. Column-level security to apply data masking policies...
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 cardinality B. DML statements that are being issued against the table are blocked C. The table has a small number...
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 minutes B. Create...
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 . Users B. Tables C. Databases D. Internal StagesView AnswerAnswer: A,B,C
What is the recommended file sizing for data loading using Snowpipe?
What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MB B. A compressed file size greater than 100 GB, and up to 250 GB C. A compressed file size greater than 10 MB, and up...
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)A . Reader B. Consumer C. Vendor D. Standard E. PersonalizedView AnswerAnswer: D,E
How would you determine the size of the virtual warehouse used for a task?
How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution B. Querying (select) the size of the stream content...
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 . Pipe B. External stage C. Task D. StreamView AnswerAnswer: A Explanation: Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load...
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 . ROLEADMIN B. ACCOUNTADMIN C. SYSADMIN D. SECURITYADMIN E. USERADMINView AnswerAnswer: D,E Explanation: By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can...
