Snowflake SnowPro Advanced Architect - Practice Exam 1

Can a user set a Column-level Security masking policy on a table or view column with the APPLY MASKING POLICY privilege?

Which command cannot we perform in a Shared database?

Why does Snowflake NOT recommend adding more than 3-4 columns into a cluster key?

What is the best option to clone a table called MYTABLE?

What is the definition of securable objects?

Does Snowflake implement row-level and column-level security policies?

What is the meaning of the "Bytes spilled to remote storage" of the query profiler?

Can we replicate databases across regions and cloud providers?

Which of the following objects cannot be replicated?

Does the VARIANT data type impose a 16MB size limit on individual rows?

Can we replicate a Database that has been created from a Share?

What is the meaning of “Local Disk IO” in the query profiler menu when running a query?

Does the Kafka connector create one pipe for each partition in a Kafka topic?

What Snowflake object executes code outside Snowflake, known as remote service?

Which command can we use to convert JSON NULL values to SQL NULL values?

What of these metrics is not a metric that appears in the Execution Time screen of the Query Profiler?

Person1 is using the role SECURITYADMIN. Person 1 creates a role named DBA_ROLE that will manage the warehouses in the Snowflake account. Person1 now needs to switch to that role. What command(s) need to be executed to switch the context of this worksheet?

Can an Object Owner grant object privileges in a regular schema?

Why does Snowflake recommend using the insertReport endpoint instead of the loadHistoryScan when using Snowpipe?

Can one masking policy be applied to multiple columns?

Which objects does the Kafka connector create for each topic?

What is row-level security?

What types of stages does Snowpipe support?

After performing the following query:

SELECT * 
FROM MYTABLE 
WHERE email=’test@test.com’

you see in the query profiler the following information:

*Subscribe now to see this picture*

Can you spot the issue?

Can a Schema Owner grant object privileges in a managed access schema?

When we create a table using the following command:

CREATE TABLE USERS(
	USER_ID NUMBER, 
	USER_NAME VARCHAR
);

What datatype will Snowflake use for the USER_ID parameter?

What are the possible use-cases of using cross-cloud and cross-region replication?

What is the difference between the insertReport and the loadHistoryScan endpoints from Snowpipe?

Which statement is false about the following task?

CREATE TASK mytask1 
 	 WAREHOUSE = mywh 
 	 SCHEDULE = '5 minute' 
 WHEN 
 SYSTEM$STREAM_HAS_DATA('ST1') 
 AS 
 	INSERT INTO mytable(id,nm)
	SELECT id, nm
	FROM st1 
	WHERE 
	METADATA$ACTION='INSERT';

How can we optimize the performance of the queries?

A Snowflake developer has created a masking policy with the following syntax:

create or replace masking policy mp
AS (val string) returns string ->
 CASE
 WHEN current_role() in('DEVROLE') 
  THEN val
 ELSE '*********'
END;

Which statements are correct about this policy?

Why does Snowflake not recommend using SELECT * in the definition of a materialized view?

Is it good practice to drop the Search Optimization Service before re-clustering the entire table and re-adding it after this process finishes?

Where can we use the command STATEMENT_TIMEOUT_IN_SECONDS?

What tables are we able to list using the command SHOW TABLES?

What Access Control Privileges do you need in order to add or remove the Search Optimization Service for a table? (SELECT TWO):

What does a successful response from the insertFiles Snowpipe endpoint mean?

Does Snowflake call the remote service directly when executing external functions?

When is the parameter INTEGRATION from Snowpipe required?

How can we add a clustering key to the existing table MYTABLE in the columns USER and CREATED_AT?

When will a multi-cluster warehouse start a new cluster if it’s running with the economy scaling policy?

A large join query takes around 3 hours to complete in an L warehouse. After increasing the warehouse size to XL one, the query's performance didn't improve. What can be the cause of it?

How many credits will consume a medium-size warehouse with 2 clusters running in maximized mode for 3 hours?

A department from our company will run complex aggregation queries to a small subset of data from a huge table that doesn’t change much. After running these queries, we realized that the queries take a lot of time because the table is not clustered on those columns. What is the most optimal solution that we should implement?

Which are the two limitations of the insertReport API of Snowpipe?