[Jan-2022] Free SnowPro-Core Exam Questions SnowPro-Core Actual Free Exam Questions
Verified SnowPro-Core dumps and 164 unique questions
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Federated Authentication & SSO
- Warehouse & Storage credit usage
- DR & Replication
- Materialized Views
- Security
- Data Encryption
- Managing Your Snowflake Account
- Differences Between Account Usage and Information Schema
- Multi-Factor Authentication (MFA)
Understanding functional and technical aspects of Data Quality 10 Developer, Professional Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Partner Connector Ecosystem
- Data Protection
- Snowflake Architecture
- Query Processing
- Data Lifecycle
- Snowflake Regions
- Connector Ecosystem
- Cloud Platform
- Snowflake Pricing & Regions
- SnowSQL (CLI)
NEW QUESTION 75
Which of the following statements are true of Snowflake data loading?
Choose 3 answers
- A. It is recommended to use staging tables to manage MERGE statements
- B. VARIANT "nut" values are not the same as SQL Null values
- C. It is recommended to do frequent, single row DMLS
- D. It is recommended to validate the data before loading into the Snowflake target table
Answer: A,B,D
NEW QUESTION 76
How would you determine the size of the virtual warehouse used for a task?
- A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- C. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
- D. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
Answer: D
NEW QUESTION 77
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 78
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
- A. Warehouses
- B. Worksheets
- C. Database
- D. Tables
Answer: A,B,C
NEW QUESTION 79
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. ACCOUNTADMIN
- B. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- C. SECURITYADMIN, ACCOUNTADMIN
- D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
Answer: D
NEW QUESTION 80
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
Answer: A
NEW QUESTION 81
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
- A. True
- B. False
Answer: A
NEW QUESTION 82
What privileges are required to execute a task?
- A. Tasks run automatically and do run under any rote.
- B. A task is an account-level object and can only be executed by the Account Admin role.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. To execute a task, you need the EXECUTE TASK.
Answer: D
NEW QUESTION 83
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/
NEW QUESTION 84
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
- A. Private Virtual Cloud
- B. Microsoft Azure Cloud
- C. Oracle Cloud
- D. Amazon Web Services
Answer: B,D
NEW QUESTION 85
Which of the following are options when creating a Virtual Warehouse?
- A. Local SSD size
- B. Auto-resume
- C. User count
- D. Auto-suspend
Answer: B,D
NEW QUESTION 86
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
- A. True
- B. false
Answer: B
NEW QUESTION 87
Which of the following commands sets the Virtual Warehouse for a session?
- A. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
- B. USE WAREHOUSE <<warehouse name>>;
- C. SET WAREHOUSE = <<warehouse name>>;
- D. COPY WAREHOUSE FROM <<config file>>;
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION 88
Which statement best describes Snowflake tables?
- A. Snowflake tables are logical representations of underlying physical data
- B. Snowflake tables require that clustering keys be defined to perform optimally
- C. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
- D. Snowflake tables are owned by a user
Answer: A
NEW QUESTION 89
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 90
Which of the following statements is true of data loading?
Select one.
- A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- B. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
- C. The "deal file size for loading is 16MB to match micro-partition size
Answer: B
NEW QUESTION 91
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
NEW QUESTION 92
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
- A. True
- B. False
Answer: B
NEW QUESTION 93
True or False: Snowpipe via REST API can only reference External Stages as source.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
NEW QUESTION 94
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: B
NEW QUESTION 95
Which of the following best describes where Snowflake's metadata is stored?
- A. In the Cloud Services Layer
- B. Inside the Virtual Warehouses
- C. Within the data files
- D. within the drivers
Answer: A
NEW QUESTION 96
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
NEW QUESTION 97
......
Latest 100% Passing Guarantee - Brilliant SnowPro-Core Exam Questions PDF: https://www.prep4sureguide.com/SnowPro-Core-prep4sure-exam-guide.html
SnowPro-Core Dumps for Pass Guaranteed - Pass SnowPro-Core Exam: https://drive.google.com/open?id=1ch21SMS4kiqlRs8EUO3TmjSzY1fpxI-R