[Feb-2023] Snowflake SnowPro-Core Actual Questions and Braindumps
Pass SnowPro-Core Exam with Updated SnowPro-Core Exam Dumps PDF 2023
NEW QUESTION 88
Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)
- A. Directory tables do not have their own grantable privileges.
- B. A directory table is a separate database object.
- C. A directory table will be automatically added to a stage.
- D. Directory table data can not be refreshed manually.
- E. Directory tables store data file metadata.
Answer: A,E
NEW QUESTION 89
Which data type can be used to store geospatial data in Snowflake?
- A. Geography
- B. Object
- C. Variant
- D. Geometry
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geos
NEW QUESTION 90
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
- A. True
- B. False
Answer: A
NEW QUESTION 91
True or False: During data unloading, only JSON and CSV files can be compressed.
- A. False
- B. True
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html
NEW QUESTION 92
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. A Schema may contain one or more Databases
- B. A Database may contain one or more Schemas
- C. A Schema is a logical grouping of Database Objects
- D. Each Schema is contained within a Warehouse
Answer: B,C
NEW QUESTION 93
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A. Time Travel - 1 day. Fail-safe - 1 day
- B. Time Travel - 1 day. Fail-safe - 0 days
- C. Transient tables are retained in neither Fail-safe nor Time Travel
- D. Time Travel - 0 days. Fail-safe - 1 day
Answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe%20period.
NEW QUESTION 94
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Streams
- B. Pipes
- C. Procedures
- D. Tasks
Answer: A
Explanation:
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.
NEW QUESTION 95
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
- A. False
- B. True
Answer: A
NEW QUESTION 96
Which of the following statements describe features of Snowflake data caching? (Choose two.)
- A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
- B. The RESULT_SCAN table function can access and filter the contents of the query result cache.
- C. A user can only access their own queries from the query result cache.
- D. When the data cache is full, the least-recently used data will be cleared to make room.
- E. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
Answer: D,E
NEW QUESTION 97
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. It is recommended to validate the data before loading into the Snowflake target table
- C. VARIANT "nut" values are not the same as SQL Null values
- D. It is recommended to do frequent, single row DMLS
Answer: A,B,C
NEW QUESTION 98
Which of the following objects can be cloned? (Choose four.)
- A. Schemas
- B. Databases
- C. Tables
- D. Shares
- E. Named File Formats
- F. Users
Answer: A,B,C,E
Explanation:
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 99
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
- A. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
- B. The listing is replicated into all selected regions automatically, the data is not.
- C. There is no need to have a Snowflake account in the target region, a share will be created for each user.
- D. Shares attached to listings in remote regions can be viewed from any account in an organization.
- E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Answer: A,C
NEW QUESTION 100
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A. False
- B. True
Answer: A
Explanation:
Explanation
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
NEW QUESTION 101
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. False
- B. True
Answer: A
NEW QUESTION 102
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
- A. Row level access policies
- B. Data encryption
- C. Time Travel
- D. External tokenization
- E. Data masking policies
Answer: B,C
NEW QUESTION 103
What feature can be used to reorganize a very large table on one or more columns?
- A. Clustering keys
- B. Micro-partitions
- C. Clustered partitions
- D. Key partitions
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION 104
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 105
Using variables in Snowflake is denoted by using which SQL character?
- A. &
- B. #
- C. $
- D. @
Answer: C
NEW QUESTION 106
Which command can be used to load data files into a Snowflake stage?
- A. COPY INTO
- B. PUT
- C. JOIN
- D. GET
Answer: B
NEW QUESTION 107
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The primary duster in the virtual warehouse
- B. The entire Virtual Warehouse
- C. The queries currently being run by the Virtual Warehouse
- D. The database the Virtual Warehouse resides in
Answer: B
NEW QUESTION 108
What privileges are required to execute a task?
- A. Tasks run automatically and do run under any rote.
- B. To execute a task, you need the EXECUTE TASK.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. A task is an account-level object and can only be executed by the Account Admin role.
Answer: B
NEW QUESTION 109
What is the maximum compressed row size in Snowflake?
- A. 8KB
- B. 4000GB
- C. 16MB
- D. 50MB
Answer: C
Explanation:
Explanation
NEW QUESTION 110
......
Latest SnowPro-Core Pass Guaranteed Exam Dumps with Accurate & Updated Questions: https://www.topexamcollection.com/SnowPro-Core-vce-collection.html
SnowPro-Core Exam Brain Dumps - Study Notes and Theory: https://drive.google.com/open?id=1ABB9hQ28cKC7ZWI2LiWcvFFvHlOYG1wk
