- All Exams Instant Download
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...
Which statement best describes '' clustering''?
Which statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitions B. The database administrator must define the clustering methodology for each Snowflake table. C. The clustering key must be included on the COPV command when loading data into Snowflake. D....
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)A . The validation_mode option is used when creating an Internal Stage B. validation_mode=return_all_errors is a parameter of the copy command C. The validation_mode option will validate data to be loaded by the copy statement while completing the...
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>) B. COPY C. SUM(<< column value >>) D. UPDATEView AnswerAnswer: B,C,D
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 Hour B. 3 Hours C. 12 hours D. 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
The FLATEEN function is used to query which type of data in Snowflake?
The FLATEEN function is used to query which type of data in Snowflake?A . Structured data B. Semi-structured data C. Both of the above D. None of the aboveView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by...
How many shares can be consumed by single Data Consumer?
How many shares can be consumed by single Data Consumer?A . 1 B. 10 C. 100, but can be increased by contacting support D. UnlimitedView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
What is a limitation of a Materialized View?
What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functions B. A Materialized View can only reference up to two tables C. A Materialized View cannot be joined with other tables D. A Materialized View cannot be defined with a JOINView AnswerAnswer: D...
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake Editions B. Is only available to customers with Business Critical Edition C. Restricts or enables access to specific IP addresses D. Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...
