Practice SnowPro Core SnowPro-Core exam. Online Exam Practice Tests with detailed explanations! Pass SnowPro-Core with confidence!
SnowPro-Core - SnowPro Core Certification Exam Practice Tests 2022 | Easy4Engine
NEW QUESTION 144
The FLATEEN function is used to query which type of data in Snowflake?
- A. None of the above
- B. Semi-structured data
- C. Both of the above
- D. Structured data
Answer: B
Explanation:
Reference:
FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.
NEW QUESTION 145
For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
- A. The size of the Warehouse and the number of clusters that ran within a given time period.
- B. The number of users who accessed the Warehouse.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The number of queries that ran using the Warehouse.
Answer: A
NEW QUESTION 146
Which of the following roles is recommended to be used to create and manage users and roles?
- A. ACCOUNTADMIN
- B. PUBLIC
- C. SYSADMIN
- D. SECURITYADMIN
Answer: D
Explanation:
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 147
What is the recommended method for loading data into Snowflake?
- A. Load data in batch
- B. Load data via frequent, angle row DML's
- C. Load data by writing it In the Snowflake Web Interface (UI)
- D. Load row by row
Answer: A
NEW QUESTION 148
True or False: Snowflake charges a premium for storing semi-structured data.
- A. True
- B. False
Answer: B
Explanation:
Reference:
premium-for-storing-semi-structured-data
NEW QUESTION 149
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
- C. The "deal file size for loading is 16MB to match micro-partition size
Answer: B
Explanation:
Once loaded, there is no option to force a reload of an already loaded file
NEW QUESTION 150
Select the different types of Internal Stages: (Choose three.)
- A. Named Stage
- B. Table Stage
- C. User Stage
- D. Schema Stage
Answer: A,B,C
NEW QUESTION 151
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. False
- B. True
Answer: B
Explanation:
Reference:
Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf
NEW QUESTION 152
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A. ORC
- B. Avro
- C. JSON
- D. Parquet
- E. XML
Answer: C,D
Explanation:
Semi-structured
JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
NEW QUESTION 153
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. All COPY INTO options are available fluting pipe creation
- B. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- C. you can only use it on internal Stages
- D. Snowpipe keeps track of which files it has loaded
Answer: A,D
NEW QUESTION 154
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. All COPY INTO options are available fluting pipe creation
- B. you can only use it on internal Stages
- C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- D. Snowpipe keeps track of which files it has loaded
Answer: C,D
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes
NEW QUESTION 155
What tasks can be completed using the copy command? (Select TWO)
- A. Columns can be aggregated
- B. Columns can be joined with an existing table
- C. Data can be loaded without the need to spin up a virtual warehouse
- D. Columns can be reordered
- E. Columns can be omitted
Answer: D,E
NEW QUESTION 156
What privileges are required to create a task?
- A. Tasks are created at the Application level and can only be created by the Account Admin role.
- B. The role must have access to the target schema and the create task privilege on the schema itself.
- C. The global privilege create task is required to create a new task.
- D. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
Answer: B
Explanation:
Explanation
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks
NEW QUESTION 157
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 158
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
- A. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
- B. The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
- C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
- D. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
Answer: A,C
NEW QUESTION 159
......
Get instant access to SnowPro-Core practice exam questions: https://drive.google.com/open?id=1tZcLux58QYwdARs_ESQXn6hXmNhfhetR
The best SnowPro-Core exam study material and preparation tool is here: https://www.easy4engine.com/SnowPro-Core-test-engine.html
