Actual Questions for Snowflake SnowPro Advanced Architect Exam

dumps2023-05-17T09:59:08+08:00

Snowflake SnowPro Advanced Architect exam information is available below for you to study. There are 65 Multiple Select, Multiple Choice, True/False in the real Snowflake SnowPro Advanced Architect exam, and you have 115 minutes to answer all the questions. The available language is English. The registration fee is $375. We have cracked the actual questions for Snowflake SnowPro Advanced Architect exam, which are useful in your preparation. Free Snowflake SnowPro Advanced Architect exam actual questions are below.

Page 1 of 11

1. Which cache type gets purged regularly?

Metadata Cache

Results Cache

Warehouse Cache

2. Snowflake offers rich set of drivers and connectors to connect with external applications. Select the Connectors from the list. (Choose 3)

Python

JDBC

Spark

Kafka

Node.js

3. Which type of view is most like a table?

External

Materialized

Standard

Secure

4. Can you have a database overlap across two Snowflake account?

Yes

5. if another objects gets added to a shared database. Will consumer able to see immediately?

Yes

6. Before Snowflake Kafka connector load data into table, it is required to create the table in Snowflake. Kafka connector can't create a table. (TRUE/FALSE)

FALSE

TRUE

7. What is the best use of SCALING OUT?

Better Performance

Better Concurrency

8. Some compute occurs in the cloud services layer. When customer is charged for compute which occurred in the cloud services layer?

Customers are charged for cloud computing that exceeds 10% of total compute costs for the account

There is no charge to customer for cloud services layer

Customers are charged for cloud computing that exceeds 10% of total storage costs for the account

Customers are charged for cloud computing that exceeds 50% of total compute costs for the account

9. Which SQL statements will need a running Warehouse and consume credit? Consider table created as - CREATE OR REPLACE TABLE T1 (ID number (2), Name varchar (20), Salary number (11,2));

SELECT MIN(ID) FROM T1;

SELECT MAX(ID) FROM T1;

SELECT AVG(ID) FROM T1;

SELECT COUNT(*) FROM T1;

10. Which type of view has an extra layer of protection to hide the SQL code from unauthorized viewing?

Standard

Materialized

Secure

Permanent

Page 2 of 11

11. Zero Copy Cloning allows users to have multiple copies of your data without the additional cost of storage usually associated with replicating data.

Which other statements about the Cloning features in Snowflake are True?

Clone is a “point in time version” of the table data as of the time the clone was made

Any new record in the parent table gets available in the cloned table

Cloning is an efficient and cost effective approach for code migration for Agile Release Management

The clone is a pointer to the original table data

12. Kafka Snowflake connector can read or subscribe one or more Kafka topics. (TRUE / FALSE)

FALSE

TRUE

13. Kafka connector requires a role with the following minimum privileges:

CREATE DATABASE

CREATE SCHEMA

CREATE TABLE

CREATE PIPE

CREATE STAGE

DATABASE USAGE

14. How many tables can be written for one Kafka Topic?

15. Snowflake calculates usage of data stored in the system for:

Clones of database tables that reference data deleted in the table that owns the clones

Cloud storage used in External Stage

Database tables, including historical data for Time Travel

Fail-safe for database tables

Files staged for bulk data loading/unloading

16. How can you store Result Scan into a table?

CREATE OR REPLACE TABLE MY_RESULT AS (RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT FROM table (RESULT_SCAN(last_query_id(-1)));

CREATE OR REPLACE TABLE MY_RESULT FROM table (RESULT_SCAN(last_query_id()));

CREATE OR REPLACE TABLE MY_RESULT AS SELECT * FROM table (RESULT_SCAN(last_query_id()));

17. A CAST command (symbol) will force a value to be output as a certain datatype.

Which of the following code samples will result in the "employeename" being output using the VARCHAR datatype?

SELECT employeename||VARCHAR

SELECT VARCHAR(employeename)

SELECT employeename AS VARCHAR

SELECT employeename::VARCHAR

18. You create a Sequence in Snowflake with an initial value of 3 and an interval of 2.

Which series of numbers do you expect to see?

3,4,5,6,7

3,6,9,12,15

3,5,7,9,11

2,5,8,11,14

19. If you want to view query history older than 14 days, where can you go to view it? Choose one path and one "term" commonly used.

Account Usage share

Account->Usage->History

The Usage Sharing Monitor

SNOWFLAKE (Database) -> ACCOUNT_USAGE (Schema) -> QUERY_HISTORY (Secure View)

History-> Profile -> Account_Usage

20. Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases.

SNOWFLAKE_SAMPLE_DATA contains a schema called ACCOUNT_USAGE

SNOWFLAKE contains a table called ACCOUNT_USAGE

ACCOUNT USAGE is a schema filled with secure views

ACCOUNT_USAGE is a schema filled with external tables

SNOWFLAKE contains a schema called ACCOUNT_USAGE

Page 3 of 11

21. You have table created as : CREATE TABLE T1 ( Name string(50), Salary number (11,2) ); If you run DESC TABLE T1; what would be the data type of NAME column?

varchar(50)

varchar

string

string(50)

22. Mike has a same query which runs for around 40 minutes every hour. Most of the time the data in the table remain same.

What could be best option for Mike to keep warehouse running or AUTO_SUSPEND?

Mike should not set AUTO_SUSPEND

Mike should set AUTO_SUSPEND to 10 minutes

Mike doesn't have to set AUTO_SUSPEN

Snowflake will take care of suspension as needed.

Mike should set AUTO_SUSPEND to 40 minutes

23. How often does Snowflake release new features?

Weekly

Yearly

Bi-Weekly

Monthly

24. As an ACCOUNTADMIN, how can you find the credit usage of a warehouse?

Run SQL query on WAREHOUSE_METERING_HISTORY view under ACCOUNT_USAGE Schema

Run SQL query on ACCOUNT_USAGE table under Snowflake Database

Using Web interface > Account > Usage

Run SQL query on METERING_HISTORY view under ACCOUNT_USAGE Schema

25. When choosing a geographic deployment region, what factors might an enrollee consider?

End-user perceptions of glamorous or trendy geographic locations

Number of availability zones within a region

Additional fees charged for regions with geo-political unrest

Proximity to the point of service

26. Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Select the correct columns names.

RECORD_CONTENT

RECORD_TOPIC

RECORD_METADATA

RECORD_PARTITION

27. Which actions are not supported with shared data?

Creating a clone of a shared database or any schemas/tables in the database

Can be re-shared by data consumer

Time Travel for a shared database or any schemas/tables in the database

Editing the comments for a shared database

28. A Virtual Warehouse can't access data loaded in the table using different warehouse.

TRUE

FALSE

29. Please choose all the securable objects from the given options.

SCHEMA

STORED PROCEDURE

EXTERNAL TABLE

DATABASE

UDF

30. Which of the following Snowflake Editions automatically store data in an encrypted state?

Standard

Enterprise

Business Critical

Page 4 of 11

31. Who pays for the compute usage of the Reader account?

Consumer

Provider

32. By default System cancels long running queries after execution till specific duration. Select the correct duration.

2 Days

12 Hours

never

7 days

33. What type of Privilege Data Consumer should have to administer shares

SHOW SHARE

EXPORT SHARE

IMPORT SHARES

LIST SHARE

34. When a warehouse is resized, which queries make use of the new size?

Only subsequent queries

Both current and subsequent queries

Only currently running queries

35. Stored Procedure supports

Java

Python

JavaScript

SQL

36. Which cache type runs on a 24 hour "clock"?

Results Cache

Warehouse Cache

Metadata Cache

37. If a server in warehouse cluster runs for 64 seconds, shuts down, and then restarts and runs for less than 60 seconds, for how many seconds it will be billed?

64 Seconds

120 Seconds

124 Seconds

4 Seconds

38. To connect with Snowflake, Kafka Snowflake connector supports:

User Name and Password Authentication

Both

Key Pair Authentication

39. Which of the following are Snowflake view types? (Select 3)

Transient

Secure

Standard

Permanent

Materialized

40. Mike wants to share a VIEW with Jessica but Mike wants to hide View definition and details from Jessica.

What type of view Mike should create and share with Jessica?

None

Materialized

Standard

Secured

Page 5 of 11

41. Which of the following are valid context functions?

CURRENT_WORKSHEET( )

CURRENT_CLIENT( )

CURRENT_CLOUD_INFRASTRUCTURE( )

CURRENT_SESSION( )

CURRENT_REGION( )

42. How to choose the right size of warehouse to achieve the best results based on the Query processing?

Execute relatively homogenous queries on the same warehouse

Execute varieties of queries on same warehouse to achieve the best result

43. What all objects does Snowflake Kafka connector create for each of the Kafka topics?

Table

Internal Stage

Schema

Database

Pipe

44. If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake? (Select 2)

Check to see if the tool can connect to other solutions via JDBC

Check to see if the tool can connect to other solutions via ODBC

Check to see if there is a petition in the community to create a driver

Check to see if you can develop a driver and put it on GitHub

45. Which of these must return a value?

Stored Procedure

User-Defined Function

Both

46. Materialized views doesn't incur any costs. (TRUE / FALSE)

TRUE

FALSE

47. Mike wants to create a multi-cluster warehouse and wants to make sure that whenever new queries are queued, additional clusters should start immediately.

How should he configure the Warehouse?

Snowflake takes care of this automatically so, Mike does not have to worry about it

Set the SCALING POLICY as ECONOMY

Set the SCALING POLICY as STANDARD

Configure as SCALE-MAX so that the warehouse is always using maximum number of specified clusters

48. Which view does behave like a table and get auto-refreshed?

None

Materialized

Secured

Standard

49. A multi-cluster virtual warehouse is Maximized when

Minimum number of clusters and Maximum number of clusters are same and must be specified with a value of more than 1.

Minimum and Maximum number of clusters are specified differently.

MIN_CLUSTER_COUNT = 3 MAX_CLUSTER_COUNT = 3

MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 1

50. Which of the following Snowflake Editions encrypt all data transmitted over the network within a Virtual Private Cloud (VPC)?

Standard

Enterprise

Business Critical

Page 6 of 11

51. What all objects can be shared?

Secure UDF

Secure View

Table

Standard View

52. Please choose the correct Table Type from the given options.

PERMANENT

TRANSIENT

EXTERNAL

TEMPORARY

INTERNAL

53. User-Defined Function (UDF) supports

SQL

JavaScript

Java

Python

54. New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share

FALSE

TRUE

55. You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes.

How will Snowflake manage changing and non-changing data? Mark all true statements.

Snowflake will spin up a warehouse each time the dashboard is refreshed

Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available

Snowflake will show the most up-to-date data each time the dashboard is refreshed

Snowflake will compile results cache data from all user results so no warehouse is needed

Snowflake will spin up a warehouse only if the underlying data has changed

56. Which command can give the list of all consumer accounts who have created database from share?

SHOW GRANTS OF DATABASE(*)

SHOW DATABASE OF SHARE <share_name>

SHOW GRANTS OF SHARE <share_name>

SELECT * FROM SHARE <share_name>

57. The VARIANT data type imposes a 10 MB to 100 MB (compressed) size limit on individual rows.(TRUE / FALSE)

TRUE

FALSE

58. What are the types of Caches? (Select 2)

Storage Cache

History Cache

Results Cache

Metadata Cache

59. If an account has federated authentication enabled. Can Snowflake admins still maintain user id and passwords in Snowflake?

Yes

60. Defining a clustering key directly on top of VARIANT columns is not supported. (TRUE / FALSE)

TRUE

FALSE

Page 7 of 11

61. The BI group is complaining about their queries taking too long to run. Checking the virtual warehouse information shows the queued time is pretty high.

What is the best way to fix this issue?

Provide a virtual warehouse for every user in the group

Increase the virtual warehouse MAXCONCURRENCY_LEVEL parameter

Determine which users have the high priority queries and set the other users

Increase the size of the virtual warehouse

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS parameter to a low value to cancel those queries if they get in the queue

Increase the virtual warehouse MAX_CLUSTER_COUNT property

62. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

FALSE

TRUE

63. We loaded an XML file that included a header entity called <dataset>. In order to bypass this entity and treat each EMPLOYEE object as a separate record (loading each into a separate row), what FILE_FORMAT property did we change?

DISABLE AUTO CONVERT

PRESERVE SPACE

STRIP OUTER ELEMENT

DISABLE SNOWFLAKE DATA

IGNORE UTF-8 ERROR

64. An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet.

What is the least costly way to download the results?

Type the command SELECT RESULTS(-3) into the Worksheet and click "Run"

Click on History -> Locate the Query -> Click the QueryID -> Use the "Export Result" button

Click on History -> Locate the Query -> Click "Download Results" in column 3

Type the command Select RESULTS(<Account>,<User>,<QueryID>) in the Worksheet and click "Run"

65. Snowflake provides native support for semi-structured data. Select true option about Snowflake native support for Semi-Structure data.

Flexible-Schema data types for loading semi-structured data without transformation

Database Optimization for fast and efficient SQL querying.

All of these

Automatic conversion of data to optimize internal storage format

66. If you are defining a multi-column clustering key of a table, the order in which the columns are specified in the CLUSTER BY clause is important. As general rule, Snowflake recommends:

Order doesn't matter

Ordering the columns from lowest cardinality to highest cardinality

Ordering the columns from highest cardinality to lowest cardinality

67. Objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available

FALSE

TRUE

68. Which cache type runs on a 24 hour "clock"?

Results Cache

Warehouse Cache

Metadata Cache

69. You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes.

How will Snowflake manage changing and non-changing data? Mark all true statements.

Snowflake will compile results cache data from all user results so no warehouse is needed

Snowflake will show the most up-to-date data each time the dashboard is refreshed

Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available

Snowflake will spin up a warehouse only if the underlying data has changed

Snowflake will spin up a warehouse each time the dashboard is refreshed

70. Mike is having SECURITYADMIN role. He created a custom DBA_ROLE. He Granted SYSADMIN role to DBA_ROLE. He created a user 'Jessica'. Mike granted DBA_ROLE to Jessica. Jessica creates a Database Jessica_DB. Jessica then created a Table T1 in Jessica_DB under PUBLIC schema.

What should Mike do to access Table T1 created by Jessica?

GRANT ROLE DBA_ROLE TO Mike; USE DATABASE Jessica_db; Select * from t1;

USE ROLE SECURITYADMIN; USE DATABASE Jessica_db; Select * from t1;

USE ROLE dba_role; USE DATABASE Jessica_db; Select * from t1;

GRANT TOLE DBA_ROLE TO Mike; USE ROLE DBA_ROLE; USE DATABASE Jessica_db; Select * from t1;

Page 8 of 11

71. What are the key considerations for using warehouse effectively and efficiently?

Start with smallest warehouse always and Scale up if the performance is poor

Don’t focus on warehouse size. Snowflake utilizes per-second billing, so you can run larger warehouses (Large, X-Large, 2X-Large, etc.) and simply suspend them when not in use

Snowflake utilizes per-hour billing so, customer doesn't have to worry about the warehouse size.

Experiment with different types of queries and different warehouse sizes to determine the combinations that best meet your specific query needs and workload.

72. What level of Privilege do you need to view Resource monitor?

OWNERSHIP

MONITOR

OPERATE

USAGE

73. Which vendors do support Snowflake natively for federated authentication and SSO?

Okta

Google G Suite

Microsoft Azure Active Directory

Onelogin

Microsoft ADFS

74. SQL Clause which helps defining the clustering key:

CLUSERTING ON

CLUSTER ON

CLUSTERING BY

CLUSTER BY

75. Which objects are securable objects in Snowflake?

Database

Table

File Format

Warehouse

76. Secured view can be used to hide the definition but its performance can get degraded?

TRUE

FALSE

77. At what frequency does Snowflake rotate the object keys?

16 Days

60 Days

1 Year

30 Days

78. Running query against INFORMATION_SCHEMA.QUERY_HISTORY can help in finding the Size of Warehouse used in Query. (TRUE/FALSE)

TRUE

FALSE

79. When key: value pairs are queried from a semi-structured record and the data is not cast, what is the data type returned?

Varchar

The system automatically cast the value to the correct data type based on the structure

String

Variant

Binary

80. What are the features of Column-level security? (Select 2)

External Tokenization

Column Masking

Internal Tokenization

Dynamic Data Masking

Page 9 of 11

81. The best method to assist pruning on a large table is to:

Define a HASH TABLE for the table

Create a DENSE INDEX on the table

Define a CLUSTER KEY for the table

Define a PARTITIONING KEY on the table

Create a CLUSTERED INDEX on the table

82. Running query against INFORMATION_SCHEMA.QUERY_HISTORY can help in finding the time of queuing / time spent by an query in the warehouse queue. (TRUE/FALSE)

FALSE

TRUE

83. Mike ran a query which took around 30 mins. He referred to Query profiler, and found the 'Bytes spilled to local storage' has big number.

What could be the issue?

Mike should contact Snowflake Personnel

Mike is using comparatively smaller warehouse

Mike is using very large warehouse

Warehouse size has no impact on Bytes spilling

84. How is the most effective way to test if clustering a table helped performance?

Use SYSTEM$CLUSTERING_INFORMATIO

Check the average_depth

Use SYSTEM$CLUSTERING_INFORMATIO

Check the total_constant_partition_count

Use the SYSTEM$CLUSTERING_DEPTH and check the depth of each column

Run a sample query before clustering and after to compare the results

Use SYSTEM$CLUSTERING_INFORMATIO

Check the average_overlaps

85. What are the best strategies to select clustering keys?

Cluster columns that are most actively used in selective filters.

Avoid columns which are used in join predicates

Columns with timestamps in nano seconds

Consider columns frequently used in join predicates

86. All files stored in stages (for data loading/unloading) automatically encrypted (using either AES 256 standard or 512 strong encryption). (TRUE/FALSE)

TRUE

FALSE

87. Mike is having SECURITYADMIN role. He created a custom DBA_ROLE. He Granted SYSADMIN role to DBA_ROLE. He created a user 'Jessica'. Mike granted DBA_ROLE to Jessica. Jessica creates a Database Jessica_DB. Jessica then created a Table T1 in Jessica_DB under PUBLIC schema.

What should Mike do to access Table T1 created by Jessica?

USE ROLE dba_role; USE DATABASE Jessica_db; Select * from t1;

GRANT ROLE DBA_ROLE TO Mike; USE DATABASE Jessica_db; Select * from t1;

USE ROLE SECURITYADMIN; USE DATABASE Jessica_db; Select * from t1;

GRANT TOLE DBA_ROLE TO Mike; USE ROLE DBA_ROLE; USE DATABASE Jessica_db; Select * from t1;

88. In the History Page, a query shows Bytes Scanned having Assigned Partitions: 110, Scanned Partitions 58, and Original Partitions 110.

Why did the optimizer show fewer partitions scanned than assigned?

The optimizer estimated only 58 partitions would need to be scan but during the execution of the query, the optimizer realized it would have to read all 110 micro partitions

One of the tables in the query was an external table and didn’t have micro partitions The metadata for the table was out of date and there were really only 58 partitions total

The query was using an Xlarge warehouse and could scan the partitions in parallel

The static optimization determined the number of possible micro partitions would be 110 but the dynamic optimization was able to prune some of the partitions from a joined table

During the execution of the query, new data was added to the table and the optimizer had to add those micro partitions into the scan.

89. Which tables will experience the most benefit from clustering?

Tables in the multi-terabyte (TB) range

Tables with sizes between the range of 100 MB to 1 GB compressed

Tables with sizes between the range of 1 GB to 10 GB compressed

All sizes of tables

90. Reclustering in Snowflake is automatic. (TRUE / FALSE)

FALSE

TRUE

Page 10 of 11

91. SQL Clause which helps defining the clustering key:

CLUSTERING BY

CLUSERTING ON

CLUSTER ON

CLUSTER BY

92. Clustering keys are not intended for all tables. (TRUE / FALSE)

TRUE

FALSE

93. Snowflake provides standard and powerful features that ensure the highest levels of security for your account and users if used properly.

Which are the true statements about Snowflake Security?

Tri-secret requires that customers manage their own keys

Snowflake supports user-based access control

Federated authentication in Snowflake is compliant with SAML 2.0

94. How to choose the right size of warehouse to achieve the best results based on the Query processing?

Execute varieties of queries on same warehouse to achieve the best result

Execute relatively homogenous queries on the same warehouse

95. Which approach would result in improved performance through linear scaling of data ingestion workload?

Consider the practice of splitting input file batch within the recommended range of 10MB to 100MB

All of the above

Consider the practice of organizing data by granular path

Resize virtual warehouse

96. Which DML operations will result in re-clustering?

INSERT

COPY

DELETE

MERGE

UPDATE

97. Semi-structured data types can be cast using what method?

Column_name CAST TO <object_type>

Column_name AS <object_type>

Column_name AS_<object_type>

(<object_type>) Column_name

Column_name::<object_type>

98. If a query is slow, how can the query be changed to improve the query?

Provide a hint to the optimizer

Change the order of the where clause to force the optimizer to consider the most effective filter first

Use an ORDER BY on the query to order the data before it’s searched

Reorder the list of tables in the query to change the order the tables are read in the query

If possible, use the table’s defined CLUSTER KEY in the query

99. STRIP_NULL_VALUE converts a JSON “null” value to a SQL NULL value. (TRUE / FALSE)

TRUE

FALSE

100. You have a table "ORG"."PUBLIC"."JS_DATA" The VARIANT column RAW_DATA with JSON has : { "extract_date": "20", "id": "10", "organizations": "Jade" }

What would be the result of following query: SELECT RAW_DATA:ID FROM "ORG"."PUBLIC"."JS_DATA";

"10"

"20"

ERROR

NULL

Page 11 of 11

101. What are the best practices for JOIN on unique keys?

Use distinct keys

Avoid unintentional cross join

Avoid MANY-TO-MANY Join

102. Mike is having SECURITYADMIN role. He created a custom DBA_ROLE. He Granted SYSADMIN role to DBA_ROLE. He created a user 'Jessica'. Mike granted DBA_ROLE to Jessica. Jessica creates a Database Jessica_DB. Jessica then created a Table T1 in Jessica_DB under PUBLIC schema.

What should Mike do to access Table T1 created by Jessica?

USE ROLE dba_role; USE DATABASE Jessica_db; Select * from t1;

USE ROLE SECURITYADMIN; USE DATABASE Jessica_db; Select * from t1;

GRANT TOLE DBA_ROLE TO Mike; USE ROLE DBA_ROLE; USE DATABASE Jessica_db; Select * from t1;

GRANT ROLE DBA_ROLE TO Mike; USE DATABASE Jessica_db; Select * from t1;

103. Which command will help you the current permissions on a Schema?

SHOW GRANTS ON SCHEMA <database_name>.<schema_name>;

SHOW ROLES ON SCHEMA <database_name>.<schema_name>;

SHOW ALL PREIVILEGE ON SCHEMA <database_name>.<schema_name>;

SHOW GRANTS OF SCHEMA <database_name>.<schema_name>;

104. All data transparently & synchronously replicated across minimum 2 availability zones. (TRUE / FALSE)

FALSE

TRUE

105. Snowflake supports many methods of authentication.

Which are the supported authentication methods in ALL Snowflake Editions?

SSO

MFA (Multi-factor authentication)

OAuth

Only MFA is supported by all the Snowflake editions

Only MFA and SSO are supported by all the Snowflake editions

106. Select the correct statements.

As a general rule, Snowflake recommends ordering the columns from lowest cardinality to highest cardinality. Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the latter column.

An existing clustering key is not copied when a table is created using CREATE TABLE … CLON

An existing clustering key is not supported when a table is created using CREATE TABLE … AS SELECT; however, you can define a clustering key after the table is created.

An existing Clustering key is not propagated when a table is created using CREATE TABLE … LIK

107. Which approach would result in improved performance through linear scaling of data ingestion workload?

All of these

Resize virtual warehouse

Consider the practice of organizing data by granular path

Consider the practice of splitting input file batch within the recommended range of 10MB to 100MB

108. Select the right container hierarchy.

ACCOUNT > USER > DATABASE > SCHEMA > TABLE

ACCOUNT > WAREHOUSE, ROLES, USER, DATABASE on same level > SCHEMA > TABLE

ACCOUNT > ROLE > DATABASE > SCHEMA > TABLE

ACCOUNT >WAREHOUSE > DATABASE > SCHEMA > TABLE

None of these

109. What is the best practice after creating a custom role in a Snowflake account?

Grant PUBLIC to the role so all database objects owned by PUBLIC will be available to the new role

Grant the role to the USERADMIN role so users can be added to the role.

Grant ownership to the SYSADMIN role or a child role under SYSADMIN

Grant ownership of the role to itself so a member of the role can control access to the role

110. Running query against INFORMATION_SCHEMA.QUERY_HISTORY can help in finding the Size of Warehouse used in Query. (TRUE/FALSE)

FALSE

TRUE

Actual Questions for Snowflake SnowPro Advanced Architect Exam

Actual Questions for Snowflake SnowPro Advanced Architect Exam

Share this post

Leave a Reply Cancel reply

Related Posts

DSA-C02 SnowPro Advanced: Data Scientist Certification Exam Dumps

New SnowPro Core Certification Exam COF-C02 Study Materials

SnowPro Advanced Data Engineer Certification DEA-C01 Exam Questions

Snowflake SnowPro Advanced Architect ARA-C01 Exam Questions

2021 New Updated SnowPro Core Exam Dumps Questions

SnowPro Advanced Administrator ADA-C01 Exam Free Dumps