[2023] Pass Snowflake SnowPro-Core Exam Updated 415 Questions
Get 2023 Updated Free Snowflake SnowPro-Core Exam Questions and Answer
Who should take the SnowPro Core Certification
This exam's objective is to measure an individual's knowledge and ability to use Snowflake based data warehouse solution. To earn this certification, you must pass the SnowPro Core Certification exam. The exam format consists of multiple select, multiple choice, True/False, fill-in the blank and terminology matching questions. The exam has no mandatory prerequisites and is administered by our third-party proctor.
A Snowflake SnowPro Core Certificate individual has a thorough understanding of Snowflake as a cloud data warehouse and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives. For this, you can use our SNOWFLAKE SNOWPRO CORE practice exam and SNOWFLAKE SNOWPRO CORE practice exams to ensure that you are ready for the exam.
NEW QUESTION 76
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. Parquet
- B. JSON
- C. ORC
- D. AVRO
- E. XML
- F. CSV
Answer: A,B,F
NEW QUESTION 77
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
- A. Concurrency
- B. Performance
Answer: B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-perform
NEW QUESTION 78
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. RAW
- B. VARIANT
- C. LOB
- D. VARCHAR
Answer: B
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 OF ROLE MY_ROLE
- B. SHOW GRANTS TO ROLE MY_ROLE
- C. SHOW GRANTS FOR ROLE MY_ROLE
- D. SHOW GRANTS ON ROLE MY_ROLE
Answer: B
NEW QUESTION 80
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. ACCOUNTADMIN
- C. PUBLIC
- D. SECURITYADMIN
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 81
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Cloud-native shared memory
- C. Multi-cluster, shared data
- D. Shared disk
Answer: C
Explanation:
Explanation
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.
NEW QUESTION 82
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. ACCOUNTADMIN
- C. SECURITYADMIN
- D. PUBLIC
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
"Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"
NEW QUESTION 83
What is a responsibility of Snowflake's virtual warehouses?
- A. Infrastructure management
- B. Permanent storage of micro-partitions
- C. Metadata management
- D. Query execution
- E. Query parsing and optimization
Answer: D
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20re
NEW QUESTION 84
Which of the following statements are true of Snowflake data loading?
Choose 3 answers
- A. It is recommended to validate the data before loading into the Snowflake target table
- 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 use staging tables to manage MERGE statements
Answer: A,B,D
NEW QUESTION 85
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLTP (Transactional) workloads
- B. On-premise workloads
- C. Concurrent workloads
- D. OLAP (Analytics) workloads
Answer: C,D
Explanation:
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing
NEW QUESTION 86
True or False: A Virtual Warehouse can be resized while suspended.
- A. False
- B. True
Answer: B
NEW QUESTION 87
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- B. ACCOUNTADMIN
- C. SECURITYADMIN, ACCOUNTADMIN
- D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION 88
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 89
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
- A. Premium
- B. Business Critical
- C. Standard
- D. Enterprise
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/privatelink-azure.html
NEW QUESTION 90
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
- A. 1 year
- B. 14 days
- C. 30 days
- D. 24 hours
- E. 60 minutes
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html
NEW QUESTION 91
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
NEW QUESTION 92
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.
- A. Account -> Database -> Schema -> Table
- B. Database -> Table -> Schema -> Account
- C. Database -> Schema -> Table -> Account
- D. Account -> Schema -> Database -> Table
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
NEW QUESTION 93
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. False
- B. True
Answer: B
Explanation:
Reference:
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.
NEW QUESTION 94
What are value types that a VARIANT column can store? (Select TWO)
- A. ARRAY
- B. CLOB
- C. OBJECT
- D. BINARY
- E. STRUCT
Answer: A,C
Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.
NEW QUESTION 95
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
NEW QUESTION 96
Which are true of Snowflake roles?
- A. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- B. All grants to objects are given to roles, and never to users
- C. The public role controls at other roles
- D. Roles are a subset of users and users own objects In Snowflake
Answer: A,B
NEW QUESTION 97
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When managing a steady workload
- B. When the compute must be available with no delay or lag time
- 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 98
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Schema
- B. Table
- C. Account
- D. Database
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period
NEW QUESTION 99
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
- A. It removes the outer array structure and loads the records into separate table rows,
- B. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
- C. It removes the last element of the outer array.
- D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
Answer: A
Explanation:
Explanation
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO
<table> command to remove the outer array structure and load the records into separate table rows:
copy into <table>
from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true);
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html
NEW QUESTION 100
......
Verified SnowPro-Core exam dumps Q&As with Correct 415 Questions and Answers: https://lead2pass.testvalid.com/SnowPro-Core-valid-exam-test.html