A user creates a stage using the following command:

What will be the outcome?

• A.An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
• B.A stage with a directory table set to automatically refresh will be created.
• C.The command will fail to run because the name of the directory table is not specified.
• D.A stage with a directory table that has metadata that must be manually refreshed will be created.

Comment: *

Name: *

Email: *

Verification: *

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

• A.(12,2)
• B.(10,4)
• C.(14,8)
• D.(15,9)

Comment: *

Name: *

Email: *

Verification: *

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A.4 minutes
• B.10 minutes
• C.14 minutes
• D.24 minutes

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake's search optimization service support?

• A.External tables
• B.Materialized views
• C.Tables and views that are not protected by row access policies
• D.Casts on table columns (except for fixed-point numbers cast to strings)

Comment: *

Name: *

Email: *

Verification: *

What information does the Query Profile provide?

• A.Graphical representation of the data model
• B.Statistics for each component of the processing plan
• C.Detailed Information about I he database schema
• D.Real-time monitoring of the database operations

Comment: *

Name: *

Email: *

Verification: *