Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors

Snowflake SnowPro Advanced Architect SnowPro Advanced Architect Dumps in PDF

Free Snowflake SnowPro Advanced Architect Real Questions (page: 3)

SnowPro Advanced Architect PDF — 236 Questions

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

  1. Shared databases are read-only.
  2. Shared databases must be refreshed in order for new data to be visible.
  3. Shared databases cannot be cloned.
  4. Shared databases are not supported by Time Travel.
  5. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
  6. Shared databases can also be created as transient databases.

Answer(s): A,C,E



What integration object should be used to place restrictions on where data may be exported?

  1. Stage integration
  2. Security integration
  3. Storage integration
  4. API integration

Answer(s): C



The following DDL command was used to create a task based on a stream:



Assuming MY_WH is set to auto_suspend ­ 60 and used exclusively for this task, which statement is true?

  1. The warehouse MY_WH will be made active every five minutes to check the stream.
  2. The warehouse MY_WH will only be active when there are results in the stream.
  3. The warehouse MY_WH will never suspend.
  4. The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer(s): A



What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

  1. The Connector only works in Snowflake regions that use AWS infrastructure.
  2. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
  3. The Connector creates and manages its own stage, file format, and pipe objects.
  4. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer(s): C



A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.

How can this data be shared?

  1. The healthcare company will need to change the institute's Snowflake edition in the accounts panel.
  2. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
  3. Contact Snowflake and they will execute the share request for the healthcare company.
  4. Set the share_restriction parameter on the shared object to false.

Answer(s): C



An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect's highest priority is to configure the connector to stream data in the MOST cost-effective manner.

Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

  1. Utilize a higher Buffer.flush.time in the connector configuration.
  2. Utilize a higher Buffer.size.bytes in the connector configuration.
  3. Utilize a lower Buffer.size.bytes in the connector configuration.
  4. Utilize a lower Buffer.count.records in the connector configuration.

Answer(s): D



An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.

The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.

Which is the LEAST complex approach to use to populate the QA account with the Production account's data and database objects on a nightly basis?

  1. 1. Create a share in the Production account for each database
    2. Share access to the QA account as a Consumer
    3. The QA account creates a database directly from each share
    4. Create clones of those databases on a nightly basis
    5. Run tests directly on those cloned databases
  2. 1. Create a stage in the Production account
    2. Create a stage in the QA account that points to the same external object-storage location
    3. Create a task that runs nightly to unload each table in the Production account into the stage
    4. Use Snowpipe to populate the QA account
  3. 1. Enable replication for each database in the Production account
    2. Create replica databases in the QA account
    3. Create clones of the replica databases on a nightly basis
    4. Run tests directly on those cloned databases
  4. 1. In the Production account, create an external function that connects into the QA account and returns all the data for one specific table
    2. Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account

Answer(s): A



A user can change object parameters using which of the following roles?

  1. ACCOUNTADMIN, SECURITYADMIN
  2. SYSADMIN, SECURITYADMIN
  3. ACCOUNTADMIN, USER with PRIVILEGE
  4. SECURITYADMIN, USER with PRIVILEGE

Answer(s): A



PDF
Viewing page 3 of 15

Share your comments for Snowflake SnowPro Advanced Architect exam with other users:

F
Future practitioner
8/10/2023 1:26:00 PM

question 4 answer is c. this site shows the correct answer as b. "adopt a consumption model" is clearly a cost optimization design principle. looks like im done using this site to study!!!

Anonymous
A
Ace
8/3/2023 10:37:00 AM

number 52 answer is d

UNITED STATES
N
Nathan
12/17/2023 12:04:00 PM

just started preparing for my exam , and this site is so much help

Anonymous
C
Corey
12/29/2023 5:06:00 PM

question 35 is incorrect, the correct answer is c, it even states so: explanation: when a vm is infected with ransomware, you should not restore the vm to the infected vm. this is because the ransomware will still be present on the vm, and it will encrypt the files again. you should also not restore the vm to any vm within the companys subscription. this is because the ransomware could spread to other vms in the subscription. the best way to restore a vm that is infected with ransomware is to restore it to a new azure vm. this will ensure that the ransomware is not present on the new vm.

Anonymous
R
Rajender
10/18/2023 3:54:00 AM

i would like to take psm1 exam.

Anonymous
B
Blessious Phiri
8/14/2023 9:53:00 AM

cbd and pdb are key to the database

SOUTH AFRICA
A
Alkaed
10/19/2022 10:41:00 AM

the purchase and download process is very much streamlined. the xengine application is very nice and user-friendly but there is always room for improvement.

NETHERLANDS
D
Dave Gregen
9/4/2023 3:17:00 PM

please upload p_sapea_2023

SWEDEN
S
Sarah
6/13/2023 1:42:00 PM

anyone use this? the question dont seem to follow other formats and terminology i have been studying im getting worried

CANADA
S
Shuv
10/3/2023 8:19:00 AM

good questions

UNITED STATES
R
Reb974
8/5/2023 1:44:00 AM

hello are these questions valid for ms-102

CANADA
M
Mchal
7/20/2023 3:38:00 AM

some questions are wrongly answered but its good nonetheless

POLAND
S
Sonbir
8/8/2023 1:04:00 PM

how to get system serial number using intune

Anonymous
M
Manju
10/19/2023 1:19:00 PM

is it really helpful to pass the exam

Anonymous
L
LeAnne Hair
8/24/2023 12:47:00 PM

#229 in incorrect - all the customers require an annual review

UNITED STATES
A
Abdul SK
9/28/2023 11:42:00 PM

kindy upload

Anonymous
A
Aderonke
10/23/2023 12:53:00 PM

fantastic assessment on psm 1

UNITED KINGDOM
S
SAJI
7/20/2023 2:51:00 AM

56 question correct answer a,b

Anonymous
R
Raj Kumar
10/23/2023 8:52:00 PM

thank you for providing the q bank

CANADA
P
piyush keshari
7/7/2023 9:46:00 PM

true quesstions

Anonymous
B
B.A.J
11/6/2023 7:01:00 AM

i can´t believe ms asks things like this, seems to be only marketing material.

Anonymous
G
Guss
5/23/2023 12:28:00 PM

hi, could you please add the last update of ns0-527

Anonymous
R
Rond65
8/22/2023 4:39:00 PM

question #3 refers to vnet4 and vnet5. however, there is no vnet5 listed in the case study (testlet 2).

UNITED STATES
C
Cheers
12/13/2023 9:55:00 AM

sometimes it may be good some times it may be

GERMANY
S
Sumita Bose
7/21/2023 1:01:00 AM

qs 4 answer seems wrong- please check

AUSTRALIA
A
Amit
9/7/2023 12:53:00 AM

very detailed explanation !

HONG KONG
F
FisherGirl
5/16/2022 10:36:00 PM

the interactive nature of the test engine application makes the preparation process less boring.

NETHERLANDS
C
Chiranthaka
9/20/2023 11:15:00 AM

very useful.

Anonymous
S
SK
7/15/2023 3:51:00 AM

complete question dump should be made available for practice.

Anonymous
G
Gamerrr420
5/25/2022 9:38:00 PM

i just passed my first exam. i got 2 exam dumps as part of the 50% sale. my second exam is under work. once i write that exam i report my result. but so far i am confident.

AUSTRALIA
K
Kudu hgeur
9/21/2023 5:58:00 PM

nice create dewey stefen

CZECH REPUBLIC
A
Anorag
9/6/2023 9:24:00 AM

i just wrote this exam and it is still valid. the questions are exactly the same but there are about 4 or 5 questions that are answered incorrectly. so watch out for those. best of luck with your exam.

CANADA
N
Nathan
1/10/2023 3:54:00 PM

passed my exam today. this is a good start to 2023.

UNITED STATES
1
1
10/28/2023 7:32:00 AM

great sharing

Anonymous
AI Tutor 👋 I’m here to help!