View All SnowPro-Core Actual Exam Questions, Answers and Explanations for Free
SnowPro-Core Exam Free Practice Test with100% Accurate Answers
NEW QUESTION # 127
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
- A. Create a task that runs a GET operation to intermittently check for new files
- B. Create a task that puts the files in an internal stage and automate the data loading wizard
- C. Create a task that runs a copy into operation from an external stage every 5 minutes
- D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 128
Where can a user find and review the failed logins of a specific user for the past 30 days?
- A. The USERS view in ACCOUNT_USAGE
- B. The LOGIN_HISTORY view in ACCOUNT_USAGE
- C. The ACCESS_HISTORY view in ACCOUNT_USAGE
- D. The SESSIONS view in ACCOUNT_USAGE
Answer: B
NEW QUESTION # 129
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
- A. SHARE on databases and schemas
- B. CREATE_SHARE on the account
- C. SELECT on tables used by the secure view
- D. REFERENCE_USAGE on databases
Answer: C
NEW QUESTION # 130
True or False: Fail-safe can be disabled within a Snowflake account.
- A. False
- B. True
Answer: B
NEW QUESTION # 131
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: B
Explanation:
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 # 132
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. False
- B. True
Answer: B
Explanation:
You can experiment the same with snowflake UI.
NEW QUESTION # 133
How are serverless features billed?
- A. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
- B. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
- C. Per second multiplied by an automatic sizing for the job
- D. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
Answer: A
NEW QUESTION # 134
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
- A. VIEWS_HISTORY
- B. LOGIN_HISTORY
- C. OBJECT_HISTORY
- D. ACCESS_HISTORY
Answer: D
NEW QUESTION # 135
What is the default File Format used in the COPY command if one is not specified?
- A. XML
- B. CSV
- C. Parquet
- D. JSON
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
NEW QUESTION # 136
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. False
- B. True
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/jdbc.html
Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.
NEW QUESTION # 137
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 138
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
- A. The clustering depth for the table is large
- B. DML statements that are being issued against the table are blocked
- C. Queries on the table are running slower than expected
- D. The table contains a column that has very low cardinality
- E. The table has a small number of micro-partitions
Answer: A,D
NEW QUESTION # 139
How a Snowpipe charges calculated?
- A. Total storage bucket size
- B. Per-second/per Warehouse size
- C. Number of Pipes in account
- D. Per-second/per-core granularity
Answer: D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html
NEW QUESTION # 140
What are value types that a VARIANT column can store? (Select TWO)
- A. OBJECT
- B. CLOB
- C. BINARY
- D. ARRAY
- E. STRUCT
Answer: A,D
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 # 141
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A. A Warehouse can be configured to auto-resume when new queries are submitted
- B. A Warehouse can be configured to suspend after a period of inactivity
- C. Customers can change the size of the Warehouse after creation
- D. A Warehouse can be resized while running
Answer: B,D
NEW QUESTION # 142
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.
- A. START.TIME = CURRENT.DATE()
- B. INITTIALLY_SUSPENDED = TRUE/FALSE
- C. START_TTIME = 60 // (seconds from now)
- D. START_AFTCR_CREATE = TRUE/FALSE
Answer: B
NEW QUESTION # 143
Fail-safe is unavailable on which table types?
- A. Permanent
- B. Translent
- C. Provisional
- D. Temporary
Answer: B,D
NEW QUESTION # 144
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A. Transient tables are retained in neither Fail-safe nor Time Travel
- B. Time Travel - 1 day. Fail-safe - 0 days
- C. Time Travel - 0 days. Fail-safe - 1 day
- D. Time Travel - 1 day. Fail-safe - 1 day
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient
NEW QUESTION # 145
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option is used when creating an Internal Stage
- B. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- C. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- D. validation_mode=return_all_errors is a parameter of the copy command
Answer: C,D
NEW QUESTION # 146
Which of the following objects can be cloned? (Choose four.)
- A. Tables
- B. Shares
- C. Users
- D. Databases
- E. Named File Formats
- F. Schemas
Answer: A,D,E,F
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 # 147
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. Docker
- B. Google Cloud Platform
- C. Amazon Web Services
- D. Oracle Cloud
- E. Microsoft Azure Cloud
- F. IBM Cloud
Answer: A,B,E
NEW QUESTION # 148
In which use cases does Snowflake apply egress charges?
- A. Database replication
- B. Loading data into Snowflake
- C. Query result retrieval
- D. Data sharing within a specific region
Answer: D
Explanation:
Explanation
Cloud providers apply data egress
* Data is transferred from one region to another within the same cloud platform.
* Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20d
NEW QUESTION # 149
......
SnowPro-Core dumps Free Test Engine Verified By It Certified Experts: https://torrentpdf.exam4tests.com/SnowPro-Core-pdf-braindumps.html