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

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

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 EVENT_TIMESTAMP, USER_NAME
  FROM table(information_schema.login_history_by_user())
• B.SELECT EVENT_TIMESTAMP, USER_NAME
  FROM ACCOUNT_USAGE.LOGIN_HISTORY;
• C.SELECT EVENT_TIMESTAMP, USER_NAME
  FROM ACCOUNT_USAGE.ACCESS_HISTORY;
• D.SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
  FROM ACCOUNT_USAGE.USERS;

Comment: *

Name: *

Email: *

Verification: *

Which file format will keep floating-point numbers from being truncated when data is unloaded?

• A.CSV
• B.JSON
• C.ORC
• D.Parquet

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true of Snowflake micro-partitioning?

• A.Micro-partitioning has been known to introduce data skew
• B.Micro-partitioning: requires a partitioning schema to be defined up front
• C.Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
• D.Micro-partitioning can be disabled within a Snowflake account

Comment: *

Name: *

Email: *

Verification: *

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.Partitions scanned is equal to partitions total
• B.An AggregateOperacor node is present
• C.A single join node uses more than 50% of the query time
• D.The query is spilling to remote storage

Comment: *

Name: *

Email: *

Verification: *