- All Exams Instant Download
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
Which cache type is used to cache data output from SQL queries?
Which cache type is used to cache data output from SQL queries?A . Metadata cache B. Result cache C. Remote cache D. Local file cacheView AnswerAnswer: B Explanation: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations. B. Clustering keys sort the designated columns over time, without blocking DML operations C. Clustering keys create a distributed, parallel data structure...
Which of the following statements will return the required information?
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS; B.SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user()) C.SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY; D.SELECT EVENT_TIMESTAMP, USER_NAME...
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 . STRUCT B. OBJECT C. BINARY D. ARRAY E. CLOBView AnswerAnswer: B,D Explanation: Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is...
What tasks can be completed using the copy command? (Select TWO)
What tasks can be completed using the copy command? (Select TWO)A . Columns can be aggregated B. Columns can be joined with an existing table C. Columns can be reordered D. Columns can be omitted E. Data can be loaded without the need to spin up a virtual warehouseView AnswerAnswer:...
What is a best practice after creating a custom role?
What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role. B. Assign the custom role to the SYSADMIN role C. Assign the custom role to the PUBLIC role D. Add_CUSTOM to all custom role namesView AnswerAnswer: B Explanation: When creating roles...
What is a key feature of Snowflake architecture?
What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the original B. Software updates are automatically applied on a quarterly basis C. Snowflake eliminates resource contention with its virtual warehouse implementation D. Multi-cluster warehouses allow users to run...
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
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cache B. Query against a virtual warehouse cache C. Query against the most-recently created micro-partition D. Query against the metadata...
