Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

• A.ORC
• B.XML
• C.Avro
• D.Parquet
• E.JSON

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

What type of account can be used to share data with a consumer who does have a Snowflake account?

• A.Data provider
• B.Data consumer
• C.Reader
• D.Organization

Comment: *

Name: *

Email: *

Verification: *

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

• A.INSERT
• B.PUT
• C.GET
• D.COPY

Comment: *

Name: *

Email: *

Verification: *

What can the Snowflake SCIM API be used to manage? (Select TWO).

• A.Integrations
• B.Network policies
• C.Session policies
• D.Roles
• E.Users

Comment: *

Name: *

Email: *

Verification: *