Free Access Snowflake.COF-C02.v2025-06-30.q512 Practice Test (Page 39)

Question 186

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 ACCOUNT_USAGE.ACCESS_HISTORY;

C.SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

D.SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

Question 187

What is the recommended way to change the existing file format type in my format from CSV to JSON?

A.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

B.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

C.REPLACE FILE FORMAT my format TYPE-JSON;

D.ALTER FILE FORMAT my_format SET TYPE=JSON;

Question 188

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.A directory table is a separate database object.

B.Directory tables store data file metadata.

C.A directory table will be automatically added to a stage.

D.Directory tables do not have their own grantable privileges.

E.Directory table data can not be refreshed manually.

Question 189

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A.SHOW STORAGE BY TABLE;

B.SHOW TABLES;

C.Information Schema -> TABLE_HISTORY

D.Information Schema -> TABLE_FUNCTION

E.Information Schema -> TABLE_STORAGE_METRICS

Question 190

Which REST API can be used with unstructured data?

A.inscrtFilcs

B.insertReport

C.loadHistoryScan

D.GET /api/tiles/

Other Version: 1083Snowflake.COF-C02.v2023-09-01.q136; 1030Snowflake.COF-C02.v2023-02-20.q85

Latest Upload: 118Genesys.GCX-GCD.v2025-09-13.q25; 116Huawei.H12-725_V4.0.v2025-09-13.q21; 122Oracle.1z0-1196-25.v2025-09-12.q18; 113NetworkAppliance.NS0-162.v2025-09-12.q86; 387OCEG.GRCP.v2025-09-11.q211; 125HP.HPE0-V27.v2025-09-11.q78; 138Oracle.1Z0-1057-23.v2025-09-10.q47; 194Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 149SAP.C-S4EWM-2023.v2025-09-08.q83; 303TheSecOpsGroup.CNSP.v2025-09-08.q20

Question 186

Question 187

Question 188

Question 189

Question 190

Download PDF File