SnowPro Core
Free trial
Verified
Question 1
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
- A: Micro-partitions
- B: Clustering keys
- C: Key partitions
- D: Clustered partitions
Question 2
Which statement best describes clustering?
- A: Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
- B: The database administrator must define the clustering methodology for each Snowflake table
- C: The clustering key must be included on the COPY command when loading data into Snowflake
- D: Clustering can be disabled within a Snowflake account
Question 3
What is the most granular object that the Time Travel retention period can be defined on?
- A: Account
- B: Database
- C: Schema
- D: Table
Question 4
Which task is supported by the use of Access History in Snowflake?
- A: Data backups
- B: Cost monitoring
- C: Compliance auditing
- D: Performance optimization
Question 5
Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?
- A: Fail-safe
- B: Network policies
- C: End-to-end encryption
- D: Multi-Factor Authentication (MFA)
Question 6
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
- A: File URL
- B: Scoped URL
- C: Relative URL
- D: Pre-Signed URL
Question 7
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
- A: Column compression
- B: Data clustering
- C: Micro-partitioning
- D: Metadata management
Question 8
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
- A: CREATE TABLE [table_name] LIKE TABLE_A;
- B: CREATE VIEW [view_name] AS SELECT * FROM TABLE_A;
- C: CREATE TABLE [table_name] AS SELECT * FROM TABLE_A;
- D: CREATE MATERIALIZED VIEW [view_name] AS SELECT * FROM TABLE_A;
Question 9
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
- A: READ
- B: REFERENCES
- C: REFERENCE_USAGE
- D: USAGE
Question 10
Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?
- A: FLATTEN
- B: OBJECT_AS
- C: OBJECT_CONSTRUCT
- D: TO_VARIANT
Question 11
Which type of role can be granted to a share?
- A: Account role
- B: Custom role
- C: Database role
- D: Secondary role
Question 12
When unloading data with the COPY INTO [location] command, what is the purpose of the PARTITION BY parameter option?
- A: To sort the contents of the output file by the specified expression.
- B: To delimit the records in the output file using the specified expression.
- C: To include a new column in the output using the specified window function expression.
- D: To split the output into multiple files, one for each distinct value of the specified expression.
Question 13
What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?
- A: Faster query performance and increased storage consumption
- B: Slower query performance and increased storage consumption
- C: Faster query performance and decreased storage consumption
- D: Slower query performance and decreased storage consumption
Question 14
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
Question 15
Which views are included in the DATA_SHARING_USAGE schema? (Choose two.)
- A: ACCESS_HISTORY
- B: DATA_TRANSFER_HISTORY
- C: WAREHOUSE_METERING_HISTORY
- D: MONETIZED_USAGE_DAILY
- E: LISTING_TELEMETRY_DAILY
Question 16
What does a table with a clustering depth of 1 mean in Snowflake?
- A: The table has only 1 micro-partition.
- B: The table has 1 overlapping micro-partition.
- C: The table has no overlapping micro-partitions.
- D: The table has no micro-partitions.
Question 17
Which Snowflake object contains all the information required to share a database?
- A: Private listing
- B: Secure view
- C: Sequence
- D: Share
Question 18
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
- A: The type of SQL statements executed
- B: The number of tables or databases queried
- C: The amount of data stored in the warehouse
- D: The length of time the compute resources in each cluster run
Question 19
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
- A: BUILD_SCOPED_FILE_URL
- B: BUILD_STAGE_FILE_URL
- C: GET_ABSOLUTE_PATH
- D: GET_PRESIGNED_URL
Question 20
When a Snowflake user loads CSV data from a stage, which COPY INTO [table] command guideline should they follow?
- A: The CSV field delimiter must be a comma character (‘,’).
- B: The number of columns in each row should be consistent.
- C: The data file in the stage must be in a compressed format.
- D: The data file must have the same number of columns as the target table.
Question 21
A user creates a stage using the following command:
CREATE STAGE mystage -
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
What will be the outcome?
- A: A stage with a directory table set to automatically refresh will be created.
- B: A stage with a directory table that has metadata that must be manually refreshed will be created.
- C: An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
- D: The command will fail to run because the name of the directory table is not specified.
Question 22
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)
- A: Partitions scanned
- B: Partitions total
- C: Bytes scanned
- D: Bytes spilled
- E: Bytes written
Question 23
Which operation can be performed on Snowflake external tables?
- A: INSERT
- B: JOIN
- C: RENAME
- D: ALTER
Question 24
A user wants to access files stored in a stage without authenticating into Snowflake.
Which type of URL should be used?
- A: File URL
- B: Staged URL
- C: Scoped URL
- D: Pre-signed URL
Question 25
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A: True
- B: False
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!