SnowPro-Core Dumps PDF - SnowPro-Core Real Exam Questions Answers
Get Started: SnowPro-Core Exam [2023] Dumps Snowflake PDF Questions
SnowPro-Core is a certification exam that measures a professional's ability to work with Snowflake's cloud-based data warehousing platform. SnowPro-Core exam is designed to test the candidate's proficiency in various areas, including data loading, querying data, performance optimization, and security. Passing the SnowPro-Core exam demonstrates that the candidate has a deep understanding of Snowflake's architecture and can perform tasks such as data modeling, data integration, and data migration.
NEW QUESTION # 77
What privileges are required to create a task?
- A. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- B. The role must have access to the target schema and the create task privilege on the schema itself.
- C. Tasks are created at the Application level and can only be created by the Account Admin role.
- D. The global privilege create task is required to create a new task.
Answer: B
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 # 78
What is a responsibility of Snowflake's virtual warehouses?
- A. Management of the storage layer
- B. Query execution
- C. Metadata management
- D. Infrastructure management
- E. Query parsing and optimization
Answer: B
NEW QUESTION # 79
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
- A. The number of queries executed
- B. The size of the virtual warehouse
- C. The length of time the warehouse is running
- D. The number of active users assigned to the warehouse
- E. The duration of the queries that are executed
Answer: A,C
NEW QUESTION # 80
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. False
- B. True
Answer: B
Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
NEW QUESTION # 81
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
- A. verify @file__stage
- B. view @file__stage
- C. show @file__stage
- D. list @file__stage
Answer: D
NEW QUESTION # 82
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
- A. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
- B. grant SELECT on all tables in database DB1 to role MYROLE;
- C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
- D. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
- E. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
- F. grant SELECT on future tables in database DB1 to role MYROLE;
Answer: A,C
NEW QUESTION # 83
What is the recommended file sizing for data loading using Snowpipe?
- A. A compressed file size greater than 10 MB, and up to 100 MB
- B. A compressed file size greater than 100 MB, and up to 250 MB
- C. A compressed file size greater than 1 GB, and up to 2 GB
- D. A compressed file size greater than 100 GB, and up to 250 GB
Answer: B
Explanation:
https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.
NEW QUESTION # 84
How often are encryption keys automatically rotated by Snowflake?
- A. 365 Days
- B. 90 Days
- C. 60 Days
- D. 30 Days
Answer: D
Explanation:
Explanation
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old.
Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dman
NEW QUESTION # 85
Which of the following statements is true of zero-copy cloning?
- A. Zero-copy clones objects inherit
- B. All zero-copy clone objects inherit the privileges of their original objects
- C. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
- D. Zero-copy coning is licensed as an additional Snowflake feature
Answer: C
Explanation:
Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data
NEW QUESTION # 86
In a Snowflake role hierarchy, what is the top-level role?
- A. SYSADMIN
- B. SECURITYADMIN
- C. ACCOUNTADMIN
- D. ORGADMIN
Answer: D
NEW QUESTION # 87
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. False
- B. True
Answer: A
NEW QUESTION # 88
How does Snowflake Fail-safe protect data in a permanent table?
- A. Fail-safe makes data available up to 1 day, recoverable by user operations.
- B. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
- C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
- D. Fail-safe makes data available for 7 days, recoverable by user operations.
Answer: C
NEW QUESTION # 89
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. REPLACE_INVALID_CHARACTERS
- B. VALIDATION_MODE
- C. SKIP_BYTE_ORDER_MARK
- D. STRIP_NULL_VALUES
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 90
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
- A. GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ; - B. GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE
MYROLE; - C. GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; - D. GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Answer: B
NEW QUESTION # 91
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Procedures
- B. Tables
- C. Sequences
- D. Materialized views
- E. Secure User Defined Functions (UDFs)
Answer: B,E
Explanation:
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 # 92
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Growth of storage and compute are tightly coupled together
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Storage expands without the requirement to add more compute
Answer: B,C,D
Explanation:
Reference:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt- separate-storage-and-compute-65d2dffd450f
NEW QUESTION # 93
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
- A. Okta
- B. Single Sign-On (SSO)
- C. Duo Security
- D. OAuth
Answer: C
NEW QUESTION # 94
Which of the following objects can be shared through secure data sharing?
- A. Masking policy
- B. Stored procedure
- C. Task
- D. External table
Answer: D
Explanation:
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%20enabl
NEW QUESTION # 95
Which of the following is a data tokenization integration partner?
- A. Tableau
- B. SAP
- C. DBeaver
- D. Protegrity
Answer: D
NEW QUESTION # 96
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Storage expands without the requirement to add more compute
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Growth of storage and compute are tightly coupled together
Answer: D
Explanation:
Reference:
separate-storage-and-compute-65d2dffd450f
NEW QUESTION # 97
......
SnowPro-Core Premium Exam Engine pdf Download: https://www.trainingdump.com/Snowflake/SnowPro-Core-practice-exam-dumps.html
Verified SnowPro-Core Bundle Real Exam Dumps PDF: https://drive.google.com/open?id=1viHfcuxdFLaKCFYU17DA4pVCSXwZoequ