[Nov 03, 2021] Get New SnowPro-Core Practice Test Questions Answers
SnowPro-Core Dumps and Exam Test Engine
Topics of SnowPro Core Certification
SNOWFLAKE SNOWPRO CORE dumps pdf will include the following topics:
- Snowflake Performance and Tuning, Performance management, Query optimization
- Semi-Structured Data
- Snowflake Cloud services, Migrations, Objects, WebUI
- Snowflake Storage and Protection, Continuous data protection, Storage
- Data Movement (Loading and Unloading), Data pipelines
- Snowflake Account and Security, Account and security, Security management
- Snowflake Virtual Warehouses Compute, Warehouses
- Snowflake Overview and Architecture Business cases, Data sharing, Extensibility
NEW QUESTION 68
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. SHOW TABLES;
- B. Information Schema -> TABLE_STORAGE_METRICS
- C. Information Schema -> TASLE_HISTORY
- D. SHOW STORAGE BY TABLE;
Answer: A,C
NEW QUESTION 69
Which of the following commands are not blocking operations?
Choose 2 answers
- A. INSERT
- B. MERGE
- C. COPY
- D. UPDATE
Answer: A,C
NEW QUESTION 70
The number of queries that a Warehouse can concurrently process is determined by:
Choose 2 answers
- A. The size of the data required for each query
- B. The tool that s executing the query
- C. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- D. The complexity of each query
Answer: A,D
NEW QUESTION 71
What is the default File Format used in the COPY command if one is not specified?
- A. XML
- B. JSON
- C. Parquet
- D. CSV
Answer: D
NEW QUESTION 72
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. SECURITYADMIN
- C. ACCOUNTADMIN
- D. PUBLIC
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 73
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLTP (Transactional) workloads
- B. On-premise workloads
- C. OLAP (Analytics) workloads
- D. Concurrent workloads
Answer: A,C
NEW QUESTION 74
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 75
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
NEW QUESTION 76
Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)?
(Choose two.)
- A. HIVE
- B. ODBC
- C. R
- D. SnowSQL
Answer: B,D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/connecting.html
NEW QUESTION 77
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Enterprise
- B. Standard
- C. Premier
- D. Business Critical Edition
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 78
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
- A. True
- B. False
Answer: B
NEW QUESTION 79
Which of the following objects is not covered by Time Travel?
- A. Schemas
- B. Stages
- C. Databases
- D. Tables
Answer: B
NEW QUESTION 80
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. # of clusters for the Warehouse
- B. Amount of data processed
- C. Warehouse size
- D. Number of users
Answer: B,C
NEW QUESTION 81
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 82
True or false: it is best practice to define a clustering key on every table.
- A. True
- B. False
Answer: B
NEW QUESTION 83
True or False: Snowflake supports federated authentication in all editions.
- A. True
- B. False
Answer: A
NEW QUESTION 84
Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi- Factor Authentication (MFA):
- A. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
- B. ACCOUNTADMIN
- C. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- D. SECURITYADMIN, ACCOUNTADMIN
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION 85
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Enterprise
- B. Standard
- C. Premier
- D. Business Critical Edition
Answer: 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. false
- B. True
Answer: A
NEW QUESTION 87
......
2021 New Actual4Cert SnowPro-Core PDF Recently Updated Questions: https://www.actual4cert.com/SnowPro-Core-real-questions.html
Snowflake SnowPro-Core DUMPS WITH REAL EXAM QUESTIONS: https://drive.google.com/open?id=1mQCTjfCYzChECEVjKVEZTwIErOf-er3c