Snowflake SnowPro-Core Dumps - The Sure Way To Pass Exam
SnowPro-Core Exam Questions (Updated 2022) 100% Real Question Answers
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Warehouse & Storage credit usage
- DR & Replication
- Differences Between Account Usage and Information Schema
- Access Control
- Materialized Views
- Information Schema
- Role Hierarchy and Privilege Inheritance
- Data Encryption
- Federated Authentication & SSO
NEW QUESTION 27
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 exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- B. 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
- C. 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
- D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
Answer: A,B
NEW QUESTION 28
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers
- A. Data backups
- B. Performance optimization
- C. Point in time snapshots
- D. Quick provisioning of Dev and Test/QA environments
Answer: A,C,D
NEW QUESTION 29
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. False
- B. True
Answer: A
NEW QUESTION 30
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The database the Virtual Warehouse resides in
- B. The primary cluster in the Virtual Warehouse
- C. The queries currently being run by the Virtual Warehouse
- D. The entire Virtual Warehouse
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 31
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
Explanation:
Explanation
NEW QUESTION 32
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. False
- B. True
Answer: A
NEW QUESTION 33
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A. False
- B. True
Answer: A
NEW QUESTION 34
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Growth of storage and compute are tightly coupled together
- C. Multiple compute clusters can access stored data without contention
- D. Storage expands without the requirement to add more compute
Answer: A,C,D
NEW QUESTION 35
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. False
- B. True
Answer: A
NEW QUESTION 36
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
NEW QUESTION 37
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
Answer: A
NEW QUESTION 38
The PUT command: (Choose two.)
- A. Automatically uses the last Stage created
- B. Automatically encrypts files
- C. Automatically compresses files using Gzip
- D. Automatically creates a File Format object
Answer: B,C
NEW QUESTION 39
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Account
- B. Table
- C. Database
- D. Schema
Answer: A
NEW QUESTION 40
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. True
- B. False
Answer: A
NEW QUESTION 41
What is the maximum compressed row size in Snowflake?
- A. 16MB
- B. 8KB
- C. 4000GB
- D. 50MB
Answer: A
NEW QUESTION 42
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.
- A. INITTIALLY_SUSPENDED = TRUE/FALSE
- B. START_AFTCR_CREATE = TRUE/FALSE
- C. START_TTIME = 60 // (seconds from now)
- D. START.TIME = CURRENT.DATE()
Answer: A
NEW QUESTION 43
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles?
Choose 3 answers
- A. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- B. Their default role should be set to SYSTEMADMIN (the lower of the two)
- C. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
- D. They should use the SYSADMIN role to perform administrative work on database objects
- E. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
Answer: A,B,D
NEW QUESTION 44
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. Warehouse size
- B. # of clusters for the Warehouse
- C. Number of users
- D. Amount of data processed
Answer: A,D
NEW QUESTION 45
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 46
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When the compute must be available with no delay or lag time
- B. When managing a steady workload
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
Answer: A,B
NEW QUESTION 47
......
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Secure Data Sharing
- Tables
- Views
- Warehouse Monitoring
- Micro partitions
- Database & Schema
- Storage
- Warehouse Sizing & Scaling
- Compute
- Warehouse Caching
- Creating & Managing Shares
- Credit Usage
- Sharing Configuration & Access Control options
- Providers, Consumers & Reader Accounts
- Warehouse Management
- Catalog & Objects
Topics of SnowPro Core Certification
SNOWFLAKE SNOWPRO CORE exam dumps pdf will include the following topics:
- Data Movement (Loading and Unloading), Data pipelines
- Snowflake Overview and Architecture Business cases, Data sharing, Extensibility
- Semi-Structured Data
- Snowflake Account and Security, Account and security, Security management
- Snowflake Virtual Warehouses Compute, Warehouses
- Snowflake Performance and Tuning, Performance management, Query optimization
- Snowflake Storage and Protection, Continuous data protection, Storage
Pass Snowflake SnowPro-Core Exam Quickly With PracticeTorrent: https://www.practicetorrent.com/SnowPro-Core-practice-exam-torrent.html
Prepare SnowPro-Core Question Answers - SnowPro-Core Exam Dumps: https://drive.google.com/open?id=1HnvltYc_u8bTR7bBxerTJRkeD0um8AYB