SnowPro Core Certified Official Practice Test SnowPro-Core - Apr-2024
Ace Snowflake SnowPro-Core Certification with Actual Questions Apr 16, 2024 Updated
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.
Snowflake is a cloud-based data platform that provides a range of data warehousing, data engineering, and data analytics services. With the growing demand for data professionals who can effectively manage and analyze data in the Snowflake platform, Snowflake has introduced the SnowPro Core Certification Exam. SnowPro Core Certification Exam certification is designed to validate a candidate's knowledge and skills in using Snowflake's core services and features.
NEW QUESTION # 20
What happens when an external or an internal stage is dropped? (Select TWO).
- A. When dropping an external stage, both the stage and the files within the stage are removed
- B. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
- C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
- D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
- E. When dropping an external stage, the files are not removed and only the stage is dropped
Answer: C,E
NEW QUESTION # 21
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
- A. Materialized Views
- B. External Tables
- C. External Tokenization
- D. User-Defined Table Functions (UDTF)
Answer: C
NEW QUESTION # 22
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. An HTTPS server with WebDAV
- B. A Windows server file share on Azure
- C. An FTP server with TLS encryption
- D. A Google Cloud storage bucket
Answer: D
NEW QUESTION # 23
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
- A. Warehouse Limit Parameter
- B. Credit Consumption Tracker
- C. Resource Monitor
- D. Account usage Tracking
Answer: C
NEW QUESTION # 24
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
- A. The data from the permanent table.
- B. An error stating that the view could not be compiled.
- C. An error stating that the referenced object could not be uniquely identified.
- D. The data from the temporary table.
Answer: D
NEW QUESTION # 25
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. False
- B. True
Answer: B
NEW QUESTION # 26
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A. False
- B. True
Answer: B
NEW QUESTION # 27
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
- A. False
- B. True
Answer: B
NEW QUESTION # 28
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
NEW QUESTION # 29
Users are responsible for data storage costs until what occurs?
- A. Data expires from Time Travel
- B. Data expires from Fail-safe
- C. Data is deleted from a table
- D. Data is truncated from a table
Answer: B
NEW QUESTION # 30
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- B. MAX_CONCURRENCY__LEVEL
- C. QUERY_TIMEOUT_IN_SECONDS
- D. STATEMENT_TIMEOUT__IN__SECONDS
Answer: A
Explanation:
Explanation
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit.
By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text
NEW QUESTION # 31
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A. COPY INTO TABLE statement
- B. Session level
- C. Table definition
- D. Stage definition
Answer: A
NEW QUESTION # 32
Which of the following objects can be shared through secure data sharing?
- A. Task
- B. Stored procedure
- C. Masking policy
- D. External table
Answer: D
Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
NEW QUESTION # 33
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Tables
- B. Procedures
- C. Materialized views
- D. Sequences
- E. Secure User Defined Functions (UDFs)
Answer: A,E
Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
NEW QUESTION # 34
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. False
- B. True
Answer: B
NEW QUESTION # 35
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Database
- B. Account
- C. Table
- D. Schema
Answer: B
NEW QUESTION # 36
What is the lowest Snowflake edition that offers Time Travel up to 90 days.
- A. Enterprise Edition
- B. Premier Edition
- C. Business Critical Edition
- D. standard Edition
Answer: A
NEW QUESTION # 37
Which of the following objects can be cloned? (Choose four.)
- A. Tables
- B. Databases
- C. Named File Formats
- D. Users
- E. Schemas
- F. Shares
Answer: A,B,D,E
NEW QUESTION # 38
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
- A. Performance
- B. Concurrency
Answer: A
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-perform
NEW QUESTION # 39
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
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 40
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .
NEW QUESTION # 41
Which kind of Snowflake table stores file-level metadata for each file in a stage?
- A. External
- B. Transient
- C. Directory
- D. Temporary
Answer: A
NEW QUESTION # 42
......
Try Free and Start Using Realistic Verified SnowPro-Core Dumps Instantly.: https://validtorrent.prep4pass.com/SnowPro-Core_exam-braindumps.html
