Valid Snowflake ARA-C01 Dumps – Great To Prepare For SnowPro Advanced Architect Certification Exam

1. How do you refresh a materialized view?

2. Which alter command below may affect the availability of column with respect to time travel?

3. Loading data using snowpipe REST API is supported for external stage only

4. Which copy options are not supported by CREATE PIPE...AS COPY FROM command?

5. Which command can be run to list all shares that have been created in your account or are available to consume by your account

6. Materialized views based on external tables can improve query performance

7. You have created a table as below

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

Which of the below select query will fail for this table?

8. With default settings, how long will a query run on snowflake

9. With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

10. Which of the below commands will use warehouse credits?

11. Where can you define the file format settings?

12. Which command below will load data from result_scan to a table?

13. Which command below will only copy the table structure from the existing table to the new table?

14. When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

15. A user needs access to create materialized view on a shema mydb.myschema.

What is the appropriate command to provide the access?

16. The kafka connector creates one pipe for each partition in a Kafka topic.

17. Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.

18. You have created a table as below

CREATE TABLE TEST_01 (NAME STRING(10));

What data type SNOWFLAKE will assign to column NAME?

19. Snowflake has row level security

20. To convert JSON null value to SQL null value, you will use

21. Following objects can be cloned in snowflake

22. What will the below query return

SELECT TOP 10 GRADES FROM STUDENT;

23. You need to choose a high cardinality column for the clustering key

24. Below are the rest APIs provided by Snowpipe

25. Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.

Which are those?

26. Who can provide permission to EXECUTE TASK?

27. You have created a TASK in snowflake.

How will you resume it?

28. What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

29. While choosing a cluster key, what is recommended by snowflake?

30. You have create a task as below

CREATE TASK mytask1

WAREHOUSE = mywh

SCHEDULE = '5 minute'

WHEN

SYSTEM$STREAM_HAS_DATA('MYSTREAM')

AS

INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';

Which statement is true below?

31. How do you validate the data that is unloaded using COPY INTO command

32. Which of the below operations are allowed on an inbound share data?

33. Data sharing is supported only between provider and consumer accounts in same region

34. When would you usually consider to add clustering key to a table

35. You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.

What type of table you will use in this case to optimize cost

36. You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the table which they will query using complex aggregation logic. You know that querying with those columns will take a lot of time because the table is not clustered on those columns.

What is the most optimal solution that you will suggest to the business team?

37. What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan

38. This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.

Which is that role?

39. A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses

40. Removing files from a stage after you are done loading the files improves performance when subsequently loading data

41. Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

42. Dynamic data masking is supported in which editions of snowflake

43. Please select the correct hierarchy from below

44. SNOWPIPE_AUTO_INGEST is supported for external stages only

45. Refreshing a secondary database is not allowed in the following circumstances

46. Which of the below objects cannot be replicated from one region to the other?

47. When unloading from a snowflake table to an internal or external stage, the COPY INTO command supports which of the below ones?

48. When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database

49. You want to automatically delete the files from stage after a successful load using the COPY INTO command.

What will be recommended approach for deletion?

50. Which of the below commands lists all the pipes for which you have access?

51. Which of the below objects cannot be replicated?

52. For which use cases, will you use cross-cloud and cross-region replication?

53. You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days.

What will be the impact on the table data?

54. You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.

What is the best option?

55. Select the true statements about TASKS

56. While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?

57. Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?

58. One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?

59. You have created a reader account for sharing data. who will pay for the compute usage of the account

60. You have create a table in snowflake as below

CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?

61. 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

62. You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.

What may be the most possible cause of this.

63. One of your joins is taking a lot of time. The query profile view looks like this.

What may be the issue?

64. You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes.

What will happen to the query?

65. The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.

66. One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage).

What may be the cause of this?

67. You have created a table as below

CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR);

What datatype Snowflake will use for EMPLOYEE_ID?

68. You got a response code of 429 from the insertFiles API.

What does that mean?

69. Which of the two are limitations of the insertReport API of SnowPipe?

70. The insertReport endpoint can be thought of like the UNIX command tail

71. You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.

What feature of Snowflake is the most appropriate to use

72. Materialized views are recommended for all of the scenarios except

73. Snowflake includes administration settings for resource consumption in order to

74. Snowflake supports the following query performance optimizing methods

75. You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.

Which mode will you use for the warehouse?

76. If a multi-cluster warehouse is resized, the new size applies to

77. Multi-cluster warehouses are best utilized for

78. When does a multi-cluster warehouse shuts down with default scaling policy

79. All multi cluster warehouses that were using the Legacy policy now use the default Standard policy

80. 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?