- All Exams Instant Download
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: D
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimum B. Credits are used to pay for cloud data storage usage C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs D. Credits are consumed...
What data is stored in the Snowflake storage layer? (Select TWO).
What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parameters B. Micro-partitions C. Query history D. Persisted query results E. Standard and secure view resultsView AnswerAnswer: B, D
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: BCD
Which of the following objects can be shared through secure data sharing?
Which of the following objects can be shared through secure data sharing?A . Masking policy B. Stored procedure C. Task D. External tableView AnswerAnswer: D Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be...
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehouses B. The use of warehouse auto scaling C. The ability to resize warehouses D. Use of multi-clustered warehouses E. The use of warehouse indexingView AnswerAnswer: A, D
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;...
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An Aggregate Operacor node is present D. The...
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANT B. ARRAY C. VARCHAR D. XML E. BLOBView AnswerAnswer: A, B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length...
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta Verify B. Duo Mobile...
