QUESTION 45
For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.

QUESTION 46
Who can view account-level Credit and Storage Usage?

QUESTION 47
Which statement is true about clustering key?

QUESTION 48
Which of the below query will you run to get the approximate number of distinct values in a table?

QUESTION 49
You ran a query and the query
SELECT * FROM inventory WHERE BIBNUMBER = 2805127;
The query profile looks as below. If you would like to further tune the query, what is the best thing to do?

QUESTION 50
An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

QUESTION 51
What does Percentage scanned from cache in the query profile signify?

QUESTION 52
How do you refresh a materialized view?

QUESTION 53
To increase performance, materialized views can be created on external table without any additional cost

QUESTION 54
When a database gets cloned, what accesses are replicated

QUESTION 55
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below
{
“COURSE_DESC”: “SNOWFLAKE CERTIFICATION”,
“COURSE_ID”: 1000,
“DURATION”: 2
}
if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it return

QUESTION 56
Which of the below operations are allowed on an inbound share data?

QUESTION 57
If you run the below commands in your worksheet, what will happen?
CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE
STUDENT_TABLE_CLONE
CLONE STUDENT_TABLE;

QUESTION 58
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

QUESTION 59
What conditions should be true for a table to consider search optimization