Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SnowPro Core Certification - PQ > Video deck > Flashcards

Video deck Flashcards

1
Q

How many days is the query history maintained in the history tab of the classic UI?

A

14

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which object does an external function make use of to hold security related information?

A

API integration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the recommended compressed file size when loading data into Snowflake?

A

100-250mb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How many databases objects can a data provider add to a SHARE object? Choose one correct value.

A

1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How many database objects can a data provider add to a SHARE object? Choose one correct value.

A

Unlimited

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which system function is called to retrieve clustering metadata for a column or columns?

A

system$clustering_information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many accounts can a data consumer share a shared database with? Choose one correct value.

A

0 - Data consumers cannot re-share shared database objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which symbols are used when referencing a user stage via SQL? Choose one correct value.

A

@~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which symbols are used when referencing a table stage via SQL? Choose one correct value.

A

@%

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The account usage share contains a database called SNOWFLAKE. The views in this database are used to provide fine-grained metrics at the account and object level. What is the maximum number of months data in these views available for? Choose one correct value.

A

12 - Certain account usage views provide historical usage metrics. The retention period for these views is 1 year.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The COPY INTO <table> statement does NOT require a virtual warehouse to run. True or false?

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which system-defined role is it recommended to assign custom roles to? Choose one correct value.

A

If custom roles are not assigned to the SYSADMIN role, system admins will not be able to manage the objects owned by the custom role.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Every securable object is owned by a single role. True or false?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the default value for the table property DATA_RETENTION_TIME_IN_DAYS for an account on the enterprise edition of Snowflake?

A

The default value for DATA_RETENTION_TIME_IN_DAYS is 1 for all editions of Snowflake.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

If the query profile indicates queries are regularly spilling to remote storage what are the recommended solutions?

A

Increase the size of the Virtual Warehouse.
Process data in smaller batches.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

External tables can be cloned. True or false?

A

False

17
Q

If enabled, periodic rekeying happens every ___ months

A

12 - If periodic rekeying is enabled, then when the retired encryption key for a table is older than one year, Snowflake automatically creates a new encryption key and re-encrypts all data previously protected by the retired key using the new key. The new key is used to decrypt the table data going forward.

18
Q

A schema cannot be cloned. True or false?

A

False

19
Q

Fail-safe is available for external tables. True or false?

A

False - It is only available for permanent table types

20
Q

What’s the maximum number of days a user could set the table property DATA_RETENTION_TIME_IN_DAYS to for a transient table on a business critical edition Snowflake account?

A

1 - The maximum DATA_RETENTION_TIME_IN_DAYS is 0 or 1 for temporary and transient tables regardless of the edition of Snowflake.

21
Q

Which types of notation are used to traverse semi-structured data natively in Snowflake? Select all that apply.

A

bracket and dot

22
Q

Which is the most accurate description of the Snowflake Partner Connect?

A

The Snowflake Partner Connect is a service which expedites the process of getting up and running with selected third-party tools.

23
Q

What is the purpose of the VALIDATE function? Choose one correct value.

A

Allows a user to view all errors encountered during a previous COPY INTO execution.

24
Q

When is a table stage not appropriate to use for data loading?

A

When loading into multiple tables

25
Q

What are the two scaling policies that can be defined when creating a multi-cluster warehouse?

A

Standard and Economy

26
Q

What is the recommended maximum number of columns (or expressions) defined per clustering key?

A

3 or 4

SnowPro Core Certification - PQ (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions