Practice Free SnowPro Core Exam Online Questions
Which command can be used to stage local files from which Snowflake interface?
- A . SnowSQL
- B . Snowflake classic web interface (Ul)
- C . Snowsight
- D . .NET driver
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
- A . Authy
- B . Duo Security
- C . One Login
- D . RSA SecurlD Access
What is the difference between a stored procedure and a User-Defined Function (UDF)?
- A . Stored procedures can execute database operations while UDFs cannot.
- B . Returning a value is required in a stored procedure while returning values in a UDF is optional.
- C . Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
- D . Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
Which command can be used to load data files into a Snowflake stage?
- A . JOIN
- B . COPY INTO
- C . PUT
- D . GET
How long is the Fail-safe period for temporary and transient tables? There is no Fail-safe period for these tables.
- A . 1 day
- B . 7 days
- C . 31 days
- D . 90 days
How can a user change which columns are referenced in a view?
- A . Modify the columns in the underlying table
- B . Use the ALTER VIEW command to update the view
- C . Recreate the view with the required changes
- D . Materialize the view to perform the changes
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;
How often are the Account and Table master keys automatically rotated by Snowflake?
- A . 30 Days
- B . 60 Days
- C . 90 Days
- D . 365 Days.
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
- A . TSV
- B . JSON
- C . PDF
- D . Avro
- E . Parquet
- F . JPEG
Which statement accurately describes a characteristic of a materialized view?
- A . A materialized view can query only a single table.
- B . Data accessed through materialized views can be stale.
- C . Materialized view refreshes need to be maintained by the user.
- D . Querying a materialized view is slower than executing a query against the base table of the view.