Pass Your Exam Easily! SnowPro-Core Real Question Answers Updated on May 02, 2024
Actual Questions Answers Pass With Real SnowPro-Core Exam Dumps
NEW QUESTION # 69
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html
NEW QUESTION # 70
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A. The warehouse size does not change until all queries currently in the warehouse queue have completed.
- B. The warehouse size does not change until the warehouse is suspended and restarted.
- C. The warehouse size does not change until all queries currently running in the warehouse have completed.
- D. It does not return from the command until the warehouse has finished changing its size.
Answer: D
NEW QUESTION # 71
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A. Customers can change the size of the Warehouse after creation
- B. A Warehouse can be configured to auto-resume when new queries are submitted
- C. A Warehouse can be resized while running
- D. A Warehouse can be configured to suspend after a period of inactivity
Answer: C,D
NEW QUESTION # 72
The is the minimum Fail-safe retention time period for transient tables?
- A. 1 day
- B. 7 days
- C. 0 days
- D. 12 hours
Answer: C
NEW QUESTION # 73
Which kind of Snowflake table stores file-level metadata for each file in a stage?
- A. Transient
- B. Directory
- C. Temporary
- D. External
Answer: D
NEW QUESTION # 74
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
- A. In the metadata of the target table for 14 days
- B. In the metadata of the target table for 64 days
- C. In the metadata of the pipe for 14 days
- D. In the metadata of the pipe for 64 days
Answer: A
NEW QUESTION # 75
What is a key feature of Snowflake architecture?
- A. Zero-copy cloning creates a mirror copy of a database that updates with the original
- B. Snowflake eliminates resource contention with its virtual warehouse implementation
- C. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
- D. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
- E. Software updates are automatically applied on a quarterly basis
Answer: C
NEW QUESTION # 76
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
- A. select * from directory(@bronzestage);
- B. select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
- C. select metadata$filename from @bronzestage;
- D. list @bronzestage;
Answer: A
Explanation:
Explanation
According to the Snowflake documentation , a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL has the following format:
https://<account_identifier>/api/files/<db_name>.<schema_name>.<stage_name>/<relative_path> Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is B. select * from directory(@bronzestage);
NEW QUESTION # 77
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)
B)
C)
D)
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: D
NEW QUESTION # 78
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. True
- B. False
Answer: B
NEW QUESTION # 79
True or false: it is best practice to define a clustering key on every table.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/
NEW QUESTION # 80
Which Snowflake layer is always leveraged when accessing a query from the result cache?
- A. Cloud Services
- B. Compute
- C. Metadata
- D. Data Storage
Answer: A
NEW QUESTION # 81
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION # 82
What are value types that a VARIANT column can store? (Select TWO)
- A. BINARY
- B. STRUCT
- C. OBJECT
- D. ARRAY
- E. CLOB
Answer: C,D
Explanation:
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
NEW QUESTION # 83
When creating a user it is advisable sable to:
Choose 2 answers
- A. Set the user to be initially disabled
- B. Force an immediate password change
- C. Set a default role for the user
- D. Set the number of minutes to unlock to 15 minutes
- E. Set the users access to expire within a specified timeframe
Answer: B,C
NEW QUESTION # 84
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html
NEW QUESTION # 85
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A. TLS 1.2
- B. Key-pair authentication
- C. OCSP authentication
- D. Federated authentication
- E. OAuth
- F. SCIM
Answer: B,D,E
NEW QUESTION # 86
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
- A. Increase the warehouse size from Medium to 2XL.
- B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
- C. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
- D. Configure the warehouse to a multi-cluster warehouse.
Answer: B
NEW QUESTION # 87
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
- A. Multi-cluster virtual warehouses
- B. Automatic clustering
- C. Row access policies
- D. Secure views
- E. Search optimization service
Answer: B,E
NEW QUESTION # 88
Which formats does Snowflake store unstructured data in? (Choose two.)
- A. GeoJSON
- B. BLOB
- C. Array
- D. Object
- E. XML
Answer: B,D
NEW QUESTION # 89
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Avoid using embedded characters such as commas for numeric data types
- B. Load files that are approximately 25 MB or smaller.
- C. Remove semi-structured data types
- D. Remove all dates and timestamps.
- E. Load files that are approximately 100-250 MB (or larger)
Answer: A,E
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 90
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Secure User Defined Functions (UDFs)
- B. Tables
- C. Materialized views
- D. Sequences
- E. Procedures
Answer: A,B
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 # 91
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: B
Explanation:
A reader account can only consume data from the provider account that created it.
NEW QUESTION # 92
The fail-safe retention period is how many days?
- A. 1 day
- B. 7 days
- C. 90 days
- D. 45 days
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
NEW QUESTION # 93
Which of the following objects can be cloned? (Choose four.)
- A. Shares
- B. Named File Formats
- C. Tables
- D. Schemas
- E. Users
- F. Databases
Answer: C,D,E,F
NEW QUESTION # 94
......
New SnowPro-Core Dumps - Real Snowflake Exam Questions: https://www.dumpsking.com/SnowPro-Core-testking-dumps.html
SnowPro-Core Dumps Prepare Your Exam With 339 Questions: https://drive.google.com/open?id=1-ZfOJJSZox4XwcdIJMCpnkkVJqDR0r0t
