The Best Practice Test Preparation for the SnowPro-Core Certification Exam
SnowPro-Core Exam Dumps, Practice Test Questions BUNDLE PACK
Snowflake SnowPro-Core (SnowPro Core Certification) Exam is a challenging exam that requires a deep understanding of Snowflake's cloud-based data warehousing platform. Passing the exam demonstrates a high level of expertise and knowledge in Snowflake's platform, which is highly valued by employers and clients alike. SnowPro Core Certification Exam certification also provides a solid foundation for further certifications in Snowflake, such as the SnowPro Advanced or Specialty certifications.
SnowPro-Core certification validates your level of expertise with Snowflake's data warehousing solution, which is used by top companies worldwide. With an official certificate, you are assured of a higher chance of securing a successful and lucrative career in the technology industry. SnowPro Core Certification Exam certification enables one to showcase their knowledge, proficiency, and credibility in the usage of Snowflake's data warehousing and management services. Furthermore, individuals who achieve SnowPro-Core certification are added to Snowflake's certified SnowPro Community, which provides exclusive interactions and access to Snowflake's resource and community events.
Snowflake SnowPro-Core certification exam is a comprehensive test that covers all aspects of Snowflake, including data loading, querying, design, security, and administration. SnowPro-Core exam consists of 70 multiple-choice questions and is timed for 90 minutes. Candidates must achieve a passing score of 300 out of 500 to earn the certification. SnowPro-Core exam is proctored, and candidates must have a reliable internet connection and a computer with a camera and microphone to take the test.
NEW QUESTION # 77
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. Python
- B. SnowSQL
- C. ODBC
- D. JDBC
- E. Snowflake Web Interface (UI)
Answer: A,B,C,D,E
Explanation:
D18912E1457D5D1DDCBD40AB3BF70D5D
NEW QUESTION # 78
Which parameter prevents streams on tables from becoming stale?
- A. MAXDATAEXTENSIONTIMEINDAYS
- B. MTN_DATA_RETENTION_TTME_TN_DAYS
- C. STALE_AFTER
- D. LOCK_TIMEOUT
Answer: A
NEW QUESTION # 79
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
- A. SHOW GRANTS FOR ROLE MY_ROLE
- B. SHOW GRANTS TO ROLE MY_ROLE
- C. SHOW GRANTS OF ROLE MY_ROLE
- D. SHOW GRANTS ON ROLE MY_ROLE
Answer: B
NEW QUESTION # 80
Which features make up Snowflake's column level security? (Select TWO).
- A. Dynamic Data Masking
- B. Continuous Data Protection (CDP)
- C. Row access policies
- D. External Tokenization
- E. Key pair authentication
Answer: A,C
NEW QUESTION # 81
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Optimized
- B. Custom
- C. Economy
- D. Standard
Answer: C,D
Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
NEW QUESTION # 82
What is the MAXIMUM size limit for a record of a VARIANT data type?
- A. 16MB
- B. 8MB
- C. 128MB
- D. 32MB
Answer: A
NEW QUESTION # 83
Which Snowflake architectural layer is responsible for a query execution plan?
- A. Data storage
- B. Cloud services
- C. Compute
- D. Cloud provider
Answer: D
NEW QUESTION # 84
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
- A. Secure view
- B. Clustered table
- C. Transient table
- D. Materialized view
- E. Sequence
Answer: B,C
NEW QUESTION # 85
Which Snowflake feature is used for both querying and restoring data?
- A. Cluster keys
- B. Cloning
- C. Fail-safe
- D. Time Travel
Answer: D
Explanation:
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.
NEW QUESTION # 86
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.
- A. 1 Hour
- B. 3 Hours
- C. 24 hours
- D. 12 hours
Answer: C
Explanation:
Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION # 87
What is the lowest Snowflake edition that offers Time Travel up to 90 days?
- A. standard Edition
- B. Premier Edition
- C. Business Critical Edition
- D. Enterprise Edition
Answer: D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-availability.html
NEW QUESTION # 88
True or False: You can resize a Virtual Warehouse while queries are running.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION # 89
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option is used when creating an Internal Stage
- B. validation_mode=return_all_errors is a parameter of the copy command
- C. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- D. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
Answer: B,D
NEW QUESTION # 90
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Minimum Clusters and Maximum Clusters settings to the same value
- B. Set the Minimum Clusters and Maximum Clusters settings to the different values
- C. Set the Warehouse type to "Auto"
- D. Configure the Maximum Clusters setting to "Auto-Scale"
Answer: B
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
NEW QUESTION # 91
How does a scoped URL expire?
- A. The encoded URL access is permanent.
- B. The length of time is specified in the expiration_time argument.
- C. When the data cache clears.
- D. When the persisted query result period ends.
Answer: D
NEW QUESTION # 92
Which of the following objects is not covered by Time Travel?
- A. Schemas
- B. Databases
- C. Tables
- D. Stages
Answer: D
NEW QUESTION # 93
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. False
- B. True
Answer: B
Explanation:
Reference:
Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf
NEW QUESTION # 94
Which of the following is true of Snowpipe via REST API? (Choose two.)
- A. All COPY INTO options are available during pipe creation
- B. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
- C. Snowpipe keeps track of which files it has loaded
- D. You can only use it on Internal Stages
Answer: A,C
NEW QUESTION # 95
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers
- A. Performance optimization
- B. Quick provisioning of Dev and Test/QA environments
- C. Data backups
- D. Point in time snapshots
Answer: B,C,D
NEW QUESTION # 96
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling rhythmically
- B. Scaling out
- C. Scaling max
- D. Scaling up
Answer: D
NEW QUESTION # 97
How long does Snowflake retain information in the ACCESS HISTORY view?
- A. 7 days
- B. 28 days
- C. 14 days
- D. 365 days
Answer: C
NEW QUESTION # 98
True or False: The COPY command must specify a File Format in order to execute.
- A. False
- B. True
Answer: A
Explanation:
Explanation
Create Stage:
https://docs.snowflake.com/en/sql-reference/sql/create-stage.html
Create Table (STAGE_FILE_FORMAT option):
https://docs.snowflake.com/en/sql-reference/sql/create-table.html
Copy Into:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
NEW QUESTION # 99
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- B. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
Answer: A,D
Explanation:
The results cache will only be used if it's the same query AND the same role executing the query
NEW QUESTION # 100
......
Prepare for the Actual SnowPro Core SnowPro-Core Exam Practice Materials Collection: https://prepaway.testkingpass.com/SnowPro-Core-testking-dumps.html