(2022) SnowPro-Core Exam Dumps, Practice Test Questions BUNDLE PACK
SnowPro Core Certification SnowPro-Core Sample Questions Reliable
NEW QUESTION 146
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Premier
- B. Enterprise
- C. Standard
- D. Business Critical Edition
Answer: D
NEW QUESTION 147
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 148
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. A Schema is a logical grouping of Database Objects
- B. A Database may contain one or more Schemas
- C. A Schema may contain one or more Databases
- D. Each Schema is contained within a Warehouse
Answer: A,B
NEW QUESTION 149
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. All of the above
- B. Data integration tools
- C. SQL commands
- D. The Snowflake Web Interface (UI)
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
NEW QUESTION 150
Which of the following describes how clustering keys work in Snowflake?
- A. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
- B. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- C. Clustering keys sort the designated columns over time, without blocking DML operations
- D. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
Answer: C
NEW QUESTION 151
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 152
What is the maximum compressed row size in Snowflake?
- A. 4000GB
- B. 50MB
- C. 16MB
- D. 8KB
Answer: C
NEW QUESTION 153
What is the minimum Snowflake edition that provides data sharing?
- A. Business Critical Edition
- B. Premier
- C. Standard
- D. Enterprise
Answer: D
NEW QUESTION 154
True or False: An active warehouse is required to run a COPY INTO statement.
- A. True
- B. False
Answer: A
NEW QUESTION 155
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 156
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles?
Choose 3 answers
- A. 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
- B. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- C. Their default role should be set to SYSTEMADMIN (the lower of the two)
- D. They should use the SYSADMIN role to perform administrative work on database objects
- E. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
Answer: B,C,D
NEW QUESTION 157
Which of the following objects can be cloned? (Choose four.)
- A. Tables
- B. Named File Formats
- C. Users
- D. Databases
- E. Schemas
- F. Shares
Answer: A,B,D,E
Explanation:
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks
NEW QUESTION 158
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
- A. Clustered table
- B. Materialized view
- C. Sequence
- D. Secure view
- E. Transient table
Answer: A,E
NEW QUESTION 159
Which of the following statements is true of data loading?
Select one.
- A. The "deal file size for loading is 16MB to match micro-partition size
- B. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism
Answer: C
Explanation:
Once loaded, there is no option to force a reload of an already loaded file
NEW QUESTION 160
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. validation_mode=return_all_errors is a parameter of the copy command
- B. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- C. The validation_mode option is used when creating an Internal Stage
- 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: A,B
NEW QUESTION 161
Which of the following are options when creating a Virtual Warehouse?
- A. Auto-suspend
- B. Auto-resume
- C. Local SSD size
- D. User count
Answer: A,B
NEW QUESTION 162
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 163
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- B. A multi-cluster Warehouse can add clusters automatically based on query activity
- C. A multi-cluster Warehouse can scale down when query activity slows
- D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Answer: A,B,C,D
NEW QUESTION 164
......
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Semi Structured Data
- Account Management
- Load Testing
- SQL optimization
- Clustering
- Caching
- Unloading data from Snowflake to Local / Network
- Drive Data Unloading Considerations
- Performance Management
- Query Profile
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Snowflake Overview and Architecture
- Overview of Key Features
- Introduction to Semi-Structured Data
- Continuous Data Protection
- Using Persisted Query Results
- A Quick Look at Zero-copy Cloning
Prepare for the Actual SnowPro Core SnowPro-Core Exam Practice Materials Collection: https://www.prep4away.com/Snowflake-certification/braindumps.SnowPro-Core.ete.file.html
SnowPro Core Certified Official Practice Test SnowPro-Core: https://drive.google.com/open?id=1liiuLpC3F6SAi3Rqm_g0TYUkmas_tfeU