Loading provider exams...
Join Us Among the Stars
Sign Up & unlock 100% of Exam Questions
1304Practice Questions
3Study Modes
Free
Question 1
Data Protection and Data SharingAsk AstroTutor
What role has the privileges to create and manage data shares by default?
- A ACCOUNTADMIN
- B SECURITYADMIN
- C SYSADMIN
- D USERADMIN
Question 2
Snowflake ArchitectureQuestion 3
Performance and Cost OptimizationQuestion 4
Performance and Cost OptimizationQuestion 5
Account and SecurityWhich 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
Question 6
Data ProcessingQuestion 7
Account and SecurityQuestion 8
Performance and Cost OptimizationQuestion 9
Snowflake ArchitectureQuestion 10
Data ProcessingQuestion 11
Data ProcessingQuestion 12
Data Protection and Data SharingQuestion 13
Data ProcessingQuestion 14
Snowflake ArchitectureQuestion 15
Data ProcessingQuestion 16
Snowflake ArchitectureQuestion 17
Data ProcessingQuestion 18
Data ProcessingQuestion 19
Performance and Cost OptimizationQuestion 20
Data ProcessingQuestion 21
Data ProcessingQuestion 22
Data ProcessingQuestion 23
Account and SecurityQuestion 24
Data Protection and Data SharingQuestion 25
Data ProcessingAsk AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
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.
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
Ask AstroTutor
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.
