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
  FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Comment: *

Name: *

Email: *

Verification: *

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• A.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
• B.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;
• D.GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

• A.Secure functions
• B.Secure views
• C.Object tagging
• D.Row-level security

Comment: *

Name: *

Email: *

Verification: *

Which function unloads data from a relational table to JSON?

• A.TRUNC<ID_NUMBER, -6)
• B.TRUNC(ID_NUMBER, 5)
• C.ID_NUMBER*100
• D.TO_CHAR<ID NUMBER)

Comment: *

Name: *

Email: *

Verification: *

Which task is supported by the use of Access History in Snowflake?

• A.Data backups
• B.Cost monitoring
• C.Compliance auditing
• D.Performance optimization

Comment: *

Name: *

Email: *

Verification: *