
Snowflake SnowPro Advanced Architect - Practice Exam 1
What does a response error code of 429 from the insertFiles, insertReport, or loadHistoryScan API of Snowpipe mean?
What is the purpose of the SYSTEM$CLUSTERING_INFORMATION function?
What is the purpose of external functions in Snowflake?
When are materialized views NOT recommended?
Select the correct object hierarchy from the following options:
What is the meaning of “Percentage scanned from cache” in the query profiler menu when running a query?
Which scaling policies does Snowflake support for multi-cluster warehouses?
Does the VALIDATION_MODE support COPY statements that transform the data during a load?
When copying files, there might be errors. What are the options that you can specify in the COPY INTO clause?
Can we clone a temporary table into a permanent one?
What command can we use to delete a share from the Snowflake account?
How does Snowflake charge for the compute resources of the cloud services layer?
What is the function of the insertReport Snowpipe endpoint?
Can we create materialized views without any additional cost?
Which role can view account-level Credit and Storage Usage?
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?