Snowflake SnowPro Core Certification - SnowPro-Core FREE EXAM DUMPS QUESTIONS & ANSWERS

A. Assign the custom role to the SYSADMIN role B. Add__CUSTOM to all custom role names C. Assign the custom role to the PUBLIC role D. Create the custom role using the SYSADMIN role.

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

A. The consumer account acquires the data share through a private data exchange. B. The objects in the data share are being deleted and the grant pattern is not re-applied systematically. C. The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every
24 hours. D. The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

A. GET_PRESIGNED_URL B. GET STAGE LOCATION C. BUILD_STAGE_FILE_URL D. BUILD_SCOPED_FILE_URL

A. Index values B. Null values C. Sorted values D. Range of values E. Distinct values

A. If User2 has the securityadmin role they will be able to see the results. B. If User2 has the ACCOUNTADMIN role they will be able to see the results. C. User2 will be unable to view the result set of the query executed by User1. D. If User2 has the sysadmin role they will be able to see the results.

A. Metadata management B. Query parsing and optimization C. Query execution D. Infrastructure management E. Permanent storage of micro-partitions

A. Continuous Data Protection (CDP) B. Dynamic Data Masking C. External Tokenization D. Row access policies E. Key pair authentication

A. Metadata cache B. Remote cache C. Local file cache D. Result cache

A. It skips rows with null values during the loading process. B. It converts null values to empty strings during loading. C. It removes object or array elements containing null values. D. It removes null values from all columns in the data.