Which data type can be used to store geospatial data in Snowflake?

• A.Variant
• B.Object
• C.Geometry
• D.Geography

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

• A.SCIM
• B.Federated authentication
• C.TLS 1.2
• D.Key-pair authentication
• E.OAuth
• F.OCSP authentication

Comment: *

Name: *

Email: *

Verification: *

When loading data into Snowflake, how should the data be organized?

• A.Into single files with 1-100 MB of compressed data per file
• B.Into files of maximum size of 1 GB of compressed data per file
• C.Into single files with 100-250 MB of compressed data per file
• D.Into files of maximum size of 4 GB of compressed data per file

Comment: *

Name: *

Email: *

Verification: *

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: *

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

• A.READ
• B.REFERENCES
• C.REFERENCEJJSAGE
• D.USAGE

Comment: *

Name: *

Email: *

Verification: *