- (Topic 6)
Which data type can be used for floating-point numbers without losing precision?

1. A. BINARY
2. B. VARIANT
3. C. INTEGER
4. D. DOUBLE

Correct Answer: D
In Snowflake, theDOUBLEdata type is used for floating-point numbers and can represent a wide range of values without losing precision. This data type is ideal for storing numerical values that require decimal precision.
✑ Define the Column:When creating a table, specify the column with theDOUBLEdata type to store floating-point numbers. CREATE TABLE example_table (
id INTEGER,
value DOUBLE
);
✑ Insert Data:Insert floating-point numbers into theDOUBLEcolumn. INSERT INTO example_table (id, value) VALUES (1, 123.456); References:
✑ Snowflake Documentation: Data Types
✑ Snowflake Documentation: Numeric Data Types

- (Topic 5)
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

1. A. 0 days
2. B. 1 day
3. C. 7 days
4. D. 14 days

Correct Answer: B
By default, the standard retention period for Time Travel in Snowflake is 1 day across all Snowflake accounts. Time Travel enables users to access historical data within this retention window, allowing for point-in-time data analysis and recovery. This feature is a significant aspect of Snowflake's data management capabilities, offering flexibility in handling data changes and accidental deletions.
References:
✑ Snowflake Documentation: Using Time Travel

- (Topic 5)
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

1. A. View
2. B. Secure view
3. C. Materialized view
4. D. External table

Correct Answer: C
A materialized view in Snowflake denotes a pre-computed data set derived from a SELECT query specification and stored for later use. Unlike standard views, which dynamically compute the data each time the view is accessed, materialized views store the result of the query at the time it is executed, thereby speeding up access to the data, especially for expensive aggregations on large datasets.
References:
✑ Snowflake Documentation: Materialized Views

- (Topic 4)
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

1. A. The user will be unable to enter a password.
2. B. The user will encounter an error, and will not be able to log in.
3. C. The user will be able to log into Snowflake successfully.
4. D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Correct Answer: A
When federated authentication is activated in Snowflake, users authenticate via an external identity provider (IdP) rather than using Snowflake-managed credentials. Therefore, a user with a password defined by Snowflake will be unable to enter a password and must use their IdP credentials to log in.

- (Topic 3)
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).

1. A. Rename listings.
2. B. Delete provider profiles.
3. C. Modify listings properties.
4. D. Modify incoming listing access requests.
5. E. Submit listings for approval/publishing.

Correct Answer: CE
With the create data EXCHANGE listing privilege, a Snowflake user can modify the properties of listings and submit them for approval or publishing on the Data Exchange. This allows them to manage and share data sets with consumers effectively. References: Based on general data exchange practices in cloud services as of 2021.