SnowPro Core Practice Exam — Free 1304+ Questions | ExamCademy1304Practice Questions
3Study Modes
FreeTo Get Started
Question 2
Ask AstroTutor
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
What role has the privileges to create and manage data shares by default?
- A ACCOUNTADMIN
- B SECURITYADMIN
- C SYSADMIN
- D USERADMIN
Which activities are included in the Cloud Services layer? (Choose two.)
- A Data storage
- B Dynamic data masking
- C Partition scanning
- D User authentication
- E Infrastructure management
What does the “percentage scanned from cache” represent in the Query Profile?
- A The percentage of data scanned from the query cache
- B The percentage of data scanned from the result cache
- C The percentage of data scanned from the remote disk cache
- D The percentage of data scanned from the local disk cache
What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?
- A All statements being executed are queued.
- B All statements being executed are restarted.
- C All statements being executed are cancelled.
- D All statements being executed are completed.
Which user preferences can be set for a user profile in Snowsight? (Choose two.)
- A Multi-Factor Authentication (MFA)
- B Default database
- C Default schema
- D Notifications
- E Username
What is the recommended way to change the existing file format type in my_format from CSV to JSON?
- A ALTER FILE FORMAT my_format SET TYPE=JSON;
- B ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;
- C CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;
- D REPLACE FILE FORMAT my_format TYPE=JSON;
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
- A ACCOUNTADMIN
- B SECURITYADMIN
- C SYSADMIN
- D USERADMIN
What type of query will benefit from the query acceleration service?
- A Queries without filters or aggregation
- B Queries with large scans and selective filters
- C Queries where the GROUP BY has high cardinality
- D Queries of tables that have search optimization service enabled
What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)
- A A count of the number of total values in the micro-partition
- B The range of values for each partition in the micro-partition
- C The range of values for each of the rows in the micro-partition
- D The range of values for each of the columns in the micro-partition
- E The number of distinct values for each column in the micro-partition
Which function determines the kind of value stored in a VARIANT column?
- A CHECK_JSON
- B IS_ARRAY
- C IS_JSON
- D TYPEOF
What does the VARIANT data type impose a 16 MB size limit on?
- A All rows
- B All columns
- C Individual rows
- D Individual columns
Which role has the ability to create a share from a shared database by default?
- A ACCOUNTADMIN
- B SECURITYADMIN
- C SYSADMIN
- D ORGADMIN
Which object-level parameters can be set to help control query processing and concurrency? (Choose two).
- A MAX_CONCURRENCY_LEVEL
- B DATA_RETENTION_TIME_IN_DAYS
- C MIN_DATA_RETENTION_TIME_IN_DAYS
- D STATEMENT_TIMEOUT_IN_SECONDS
- E STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
What metadata does Snowflake store for rows in micro-partitions? (Choose two.)
- A Range of values
- B Distinct values
- C Index values
- D Sorted values
- E Null values
What are valid sub-clauses to the OVER clause for a window function? (Choose two.)
- A GROUP BY
- B LIMIT
- C ORDER BY
- D PARTITION BY
- E UNION ALL
Which kind of Snowflake table stores file-level metadata for each file in a stage?
- A Directory
- B External
- C Temporary
- D Transient
What column type does a Kafka connector store formatted information in a single column?
- A ARRAY
- B OBJECT
- C VARCHAR
- D VARIANT
Which SQL command will list the files in a named stage?
- A list @~;
- B get @%mytable;
- C list @my_stage;
- D get @my_stage;
What is the effect of configuring a virtual warehouse auto-suspend value to ‘0’?
- A The warehouse will never suspend.
- B The warehouse will suspend immediately upon work completion.
- C The warehouse will not resume automatically.
- D All clusters in the multi-cluster warehouse will resume immediately.
Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
- A ARRAY
- B BLOB
- C CLOB
- D JSON
- E VARIANT
Which types of subqueries does Snowflake support? (Choose two.)
- A Uncorrelated scalar subqueries in WHERE clauses
- B Uncorrelated scalar subqueries in any place that a value expression can be used
- C EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
- D EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
- E EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated
While attempting to avoid data duplication, which COPY INTO [location] option should be used to load files with expired load metadata?
- A LOAD_UNCERTAIN_FILES
- B FORCE
- C VALIDATION_MODE
- D LAST_MODIFIED
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
- A Duo Security
- B OAuth
- C Okta
- D Single Sign-On (SSO)
What tasks can an account administrator perform in the Data Exchange? (Choose two.)
- A Add and remove members.
- B Delete data categories.
- C Approve and deny listing approval requests.
- D Transfer listing ownership.
- E Transfer ownership of a provider profile.
What consideration should be made when loading data into Snowflake?
- A Create small data files and stage them in cloud storage frequently.
- B Create large data files to maximize the processing overhead for each file.
- C The number of load operations that run in parallel can exceed the number of data files to be loaded.
- D The number of data files that are processed in parallel is determined by the virtual warehouse.
