2022 SnowPro-Core Dumps PDF - SnowPro-Core Real Exam Questions Answers
Valid SnowPro-Core Test Answers & Snowflake SnowPro-Core Exam PDF
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Query Profile
- Performance Management
- Account Management
- Unloading data from Snowflake to External Cloud Storage (S3,GCS,AZURE BLOB)
- Unloading data from Snowflake to Internal Snowflake Storage
- Caching
- Drive Data Unloading Considerations
- Different Formats, Variant Table Type
- Native Syntax, Flattening Data
- Data Unloading
- Unloading data from Snowflake to Local / Network
NEW QUESTION 74
Which formats are supported for unloading data from Snowflake?
Choose 2 answers
- A. JSON
- B. ORC
- C. Delimited (CSV, TSV, etc.)
- D. Avro
Answer: A,C
NEW QUESTION 75
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A. False
- B. True
Answer: A
NEW QUESTION 76
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
- B. They happen approximately weekly
- C. During a release, new customer requests/queries/connections transparently move over to the newer version
- D. They roll up and release approximately monthly, but customers can request early release application
Answer: A,C
NEW QUESTION 77
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles?
Choose 3 answers
- A. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- B. Their default role should be set to SYSTEMADMIN (the lower of the two)
- C. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
- D. They should use the SYSADMIN role to perform administrative work on database objects
- E. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
Answer: A,B,D
NEW QUESTION 78
The PUT command: (Choose two.)
- A. Automatically uses the last Stage created
- B. Automatically encrypts files
- C. Automatically compresses files using Gzip
- D. Automatically creates a File Format object
Answer: B,C
NEW QUESTION 79
True or False: Snowpipe via REST API can only reference External Stages as source.
- A. False
- B. True
Answer: A
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
NEW QUESTION 80
Fail-safe is unavailable on which table types?
- A. Permanent
- B. Provisional
- C. Temporary
- D. Transient
Answer: C,D
NEW QUESTION 81
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
- A. Standard
- B. Enterprise
- C. Premier
- D. Business Critical Edition
Answer: B
NEW QUESTION 82
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Database Layer
- B. Cloud Service Layer
- C. Storage Layer
- D. Compute Layer
Answer: B
NEW QUESTION 83
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When managing a steady workload
- B. When the compute must be available with no delay or lag time
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
Answer: A,D
NEW QUESTION 84
When loading data into Snowflake, the COPY command supports:
Choose 2 answers
- A. Column reordering
- B. Fitters
- C. Data type conversions
- D. Joins
- E. Aggregates
Answer: A,C
NEW QUESTION 85
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. False
- B. True
Answer: A
Explanation:
Explanation/Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/
NEW QUESTION 86
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. ACCOUNTADMIN
- B. SECURITYADMIN, ACCOUNTADMIN
- C. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
Answer: D
NEW QUESTION 87
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 88
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Standard
- B. Business Critical Edition
- C. Enterprise
- D. Premier
Answer: B
NEW QUESTION 89
Which of the following DML commands isn't supported by Snowflake?
- A. UPSERT
- B. TRUNCATE TABLE
- C. UPDATE
- D. MERGE
Answer: A
NEW QUESTION 90
What is the default File Format used in the COPY command if one is not specified?
- A. JSON
- B. Parquet
- C. CSV
- D. XML
Answer: C
NEW QUESTION 91
......
SnowPro-Core Exam Dumps - PDF Questions and Testing Engine: https://www.vcedumps.com/SnowPro-Core-examcollection.html
Realistic SnowPro-Core Exam Dumps with Accurate & Updated Questions: https://drive.google.com/open?id=1yIEMso0Vppn3BSSOGMgXdEwN739alKmC
