COF-R02

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....

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.A . More micro-partitions B. Better query scheduling C. Double the numbers of servers In the compute duster D. Higher storage costsView AnswerAnswer: C

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution B. Querying (select) the size of the stream content...

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)A . JDBC B. SnowSQL C. Snowflake Web Interface (UI) D. ODBC E. PythonView AnswerAnswer: A,B,C,D,E Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?A . Standard B. Premier C. Enterprise D. Business Critical EditionView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

Which of the following statements are true of Snowflake releases: (Choose two.)A . They happen approximately weekly B. They roll up and release approximately monthly, but customers can request early release application C. During a release, new customer requests/queries/connections transparently move over to the newer version D. A customer is...

True or False: During data unloading, only JSON and CSV files can be compressed.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)A . Number of users B. Warehouse size C. Amount of data processed D. # of clusters for the WarehouseView AnswerAnswer: B,D Explanation: https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how...

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more Databases B. A Database may contain one or more Schemas C. A Schema is a logical grouping of Database Objects D. Each Schema is contained within a WarehouseView AnswerAnswer:...