- All Exams Instant Download
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 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...
Which command is used to unload data from a Snowflake table into a file in a stage?
Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTO B. GET C. WRITE D. EXTRACT INTOView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.
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...
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%2 0through%20Snowflake%20Time%20Travel.
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...
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stages B. Incremental backups C. Time Travel D. Zero-copy clones E. Fail-safeView AnswerAnswer: C,E Explanation: Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides...
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
