- All Exams Instant Download
What are ways to create and manage data shares in Snowflake? (Select TWO)
What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul) B. Through the DATA_SHARE=TRUE parameter C. Through SQL commands D. Through the enable__share=true parameter E. Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: A C
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resources B. Query execution C. Authentication D. Data storage E. MetadataView AnswerAnswer: C, E Explanation: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the...
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...
When unloading to a stage, which of the following is a recommended practice or approach?
When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger files B. Use OBJECT_CONSTRUCT ( * ) when using Parquet C. Avoid the use of the CAST function D. Define an individual file formatView AnswerAnswer: B
Which Snowflake feature is used for both querying and restoring data?
Which Snowflake feature is used for both querying and restoring data?A . Cluster keys B. Time Travel C. Fail-safe D. CloningView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: You can experiment the same with snowflake UI.
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD; B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING; C. GRANT MODIFY...
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....
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 affected B. When reducing the size of a warehouse the compute resources are removed only when they are no longer...
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...
