HP2-B100 Exam Discussions & Posts
mark
Commented on July 26, 2025
very informative
EUROPEAN UNION
gm
Commented on July 26, 2025
Question 77: Answer should be all
Bulk copy from an External Stage:
This involves using the COPY INTO command to load data from files stored in external cloud storage locations (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage) into a Snowflake table.
Continuous load using Snowpipe REST API:
Snowpipe enables continuous data loading from staged files as soon as they become available. The Snowpipe REST API can be used to trigger the loading process for new files in an external stage.
The Snowflake Web Interface (UI) data loading wizard:
Snowsight, Snowflake's web interface, provides a user-friendly wizard that guides users through the process of loading data into tables, often from local files or staged files.
Bulk copy from an Internal Stage:
Similar to external stages, data can be bulk loaded from internal stages (storage locations within Snowflake) into tables using the COPY INTO command. Files can be placed in internal stages using commands like PUT.
Anonymous
gm
Commented on July 26, 2025
Question 68:
Explanation:
INSERT:
When inserting data into a table, Snowflake usually writes to new partitions, allowing other queries to access the existing data simultaneously.
COPY:
Similar to INSERT, the COPY command often writes to new partitions, enabling parallel execution with other operations.
Why other options are incorrect:
UPDATE:
This command modifies existing data in a table, which requires locking the affected rows to prevent conflicts. This makes it a blocking operation, meaning other queries that need to access the same rows will have to wait until the UPDATE finishes.
MERGE:
Like UPDATE, the MERGE command modifies data in a table, requiring locks and thus being a blocking operation. It combines data from multiple sources into a target table, which can involve modifying existing rows.
Anonymous
mark
Commented on July 26, 2025
very interesting
EUROPEAN UNION
Kannamani Ramasamy
Commented on July 26, 2025
Good practice questions
Anonymous
lp
Commented on July 25, 2025
good set of questions to help prep
UNITED STATES
gm
Commented on July 25, 2025
Question 59 - False. In Snowflake, when a role is created, the role that is active at the time of creation is assigned ownership, not the individual user. This ownership can be transferred to another role using the GRANT OWNERSHIP command.
SINGAPORE
gm
Commented on July 25, 2025
Question 48 -
? They roll up and release approximately monthly, but customers can request early release application.
- While behavior changes are bundled monthly, releases themselves are weekly. Early access is available for Enterprise Edition and higher, but this applies to weekly releases, not monthly rollups.
? A customer is assigned a 30-minute window during which the system will be unavailable and upgraded.
- Snowflake upgrades are seamless and do not involve downtime. Customers are not assigned maintenance windows.
SINGAPORE
gm
Commented on July 25, 2025
Question 42 - Explaining why not others
? Snowflake tables are the physical instantiation of data: This is misleading because Snowflake abstracts physical storage from users.
? Clustering keys are required for optimal performance: Clustering keys are optional and used for very large tables to improve query performance, but not required.
? Snowflake tables are owned by a user: Tables are owned by roles, not individual users, as part of Snowflake's role-based access control (RBAC) model.
SINGAPORE
MK
Commented on July 25, 2025
excellent website for preparing for the ms 900 exam
UNITED STATES
gm
Commented on July 25, 2025
Question 37: Explaination -
Here are the three correct statements about Snowflake data loading:
? VARIANT "null" values are not the same as SQL NULL values
In Snowflake, the string "null" stored in a VARIANT column is treated as a string, not as a SQL NULL. This distinction is important when querying or transforming semi-structured data like JSON.
? It is recommended to validate the data before loading into the Snowflake target table
Validating data helps ensure integrity, prevents errors during loading, and avoids polluting production tables with bad or malformed data.
? It is recommended to use staging tables to manage MERGE statements
Staging tables allow for cleaner, more controlled data transformations and help manage complex MERGE operations efficiently.
? It is recommended to do frequent, single row DMLs
This is not recommended. Snowflake is optimized for bulk operations. Frequent single-row DMLs (INSERT, UPDATE, DELETE) can be inefficient and costly.
SINGAPORE
gm
Commented on July 25, 2025
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
Answer should be False because Snowflake provides standard JDBC and ODBC drivers that allow connections from tools supporting these standards
SINGAPORE
gm
Commented on July 25, 2025
Helpful questions
SINGAPORE
Ankitha
Commented on July 25, 2025
Its very useful
UNITED STATES
ADB
Commented on July 25, 2025
very relevant questions providing accurate answers which helps in certification preparation
INDIA
Ricardo Nelumba
Commented on July 25, 2025
On question 49, answer B makes more sense because Athena requires files to be in queryable formats (e.g., CSV/JSON), not audio/text transcripts. Glacier Select has high latency (hours).
Anonymous
Nayeh
Commented on July 25, 2025
Anyone passed exam recently? shade a light on questions asked from here
Anonymous
ADB
Commented on July 25, 2025
this questions provides contextual insights for exam preparations
INDIA
cc
Commented on July 25, 2025
nice questions
JAPAN
cuuns
Commented on July 25, 2025
good questioins
JAPAN
harry
Commented on July 25, 2025
great content
JAPAN
BV
Commented on July 25, 2025
The answer to question 34 is incorrect. It should be:
ALTER TABLE ...
ADD CONSTRAINT ... PRIMARY KEY NONCLUSTERED
NOT ENFORCED
Fabric does not support clustered index primary keys and does not support enforcing constraints.
CANADA
Maarten
Commented on July 25, 2025
Looking good
NETHERLANDS
Riya
Commented on July 25, 2025
Very helpful
Anonymous
Riya
Commented on July 25, 2025
Very good and helpful
Anonymous
ghostdog248
Commented on July 25, 2025
Wish you all the best
Anonymous
AL
Commented on July 25, 2025
Good content
SPAIN
Abhijeet
Commented on July 25, 2025
Good questions
Anonymous
Lucky
Commented on July 25, 2025
I'm currently preparing for the CompTIA 220-1101 exam and finding the mix of hardware, networking, and mobile device topics both challenging and exciting. I've been using practice tests and flashcards to reinforce my learning. For those who’ve already taken the exam — any tips on which sections are most heavily tested or common pitfalls to watch out for? Would love to hear how others are preparing too!
Anonymous
Shengavit
Commented on July 25, 2025
Thank you for this resource! It was very helpful and played a big role in helping me reach my goal. Great work!
ARMENIA
Shengo
Commented on July 25, 2025
Very useful !
ARMENIA
Arjith
Commented on July 25, 2025
Really great content. very helpful
INDIA
Aldo - Philippines
Commented on July 25, 2025
Very helpful questionnaires in preparing for my exam.
UNITED STATES
BV
Commented on July 24, 2025
The answer to question 36 is "Yes" (A). The current answer is wrong, as well as the explanation (not specifying the order explicitly does not invalidate the solution).
CANADA
MAGICBUNNIEZ
Commented on July 24, 2025
To mitigate the risk of sensitive data exfiltration after a data classification initiative, the most effective solution among the given options is:
DLP (Data Loss Prevention)
Why DLP?
DLP solutions are specifically designed to detect and prevent unauthorized transfers or exfiltration of sensitive data.
They can monitor, classify, and block sensitive data (e.g., PII, financial records, intellectual property) from being emailed, uploaded, or copied outside the organization.
DLP enforces policies based on data classification, ensuring compliance with regulations like GDPR, HIPAA, or PCI DSS.
Other Options (Less Relevant for Data Exfiltration Mitigation):
XDR (Extended Detection and Response) – Focuses on threat detection and response, not necessarily preventing data exfiltration directly.
SPF (Sender Policy Framework) – Helps prevent email spoofing but does not stop data leaks.
DMARC (Domain-based Message Authentication, Reporting & Conformance) – Improves email authentication but d
UNITED STATES
Robo
Commented on July 24, 2025
have heard great things, hope i pass :)
Anonymous
Jbits
Commented on July 24, 2025
Q 198. Correct Answer: B/C/F
UNITED STATES
Culo
Commented on July 24, 2025
so far very helpful
EUROPEAN UNION
Daniel Isangedighi
Commented on July 24, 2025
Microsoft Fabric has changed a lot of the features for Data Processing. A couple of the questions need revision.
SWITZERLAND
Don
Commented on July 24, 2025
Question 134 the answer is A, since the service account need to be assigned to the vm and not configure it at the application level
MOROCCO
yves
Commented on July 24, 2025
very useful I already used it for Azure Fundamentals cert
UNITED STATES
Krish
Commented on July 24, 2025
Very good website to prepare for AZ-900
UNITED STATES
Nayeh
Commented on July 24, 2025
Are these questions relevant in 2025 exam?
Anonymous
Onyi
Commented on July 24, 2025
The dumps were simply amazing. A sure guide to Ace your exam. I did write mine on June 21 and scored 714 with only a few days of study using the dumps only.
SWITZERLAND
Cool Flamez
Commented on July 24, 2025
Very useful questions and answers for ther ServiceNow Certified System Administrator Examination
Anonymous
Nona
Commented on July 24, 2025
Very helpful , really appreciate your time and effort offering them for free
UNITED STATES
Fan
Commented on July 24, 2025
Great content
Anonymous
Kavita
Commented on July 24, 2025
answer for Q 120 is D 17 .
Anonymous
Random
Commented on July 24, 2025
Answer for Question 120 is D) 17 not 17.0.
Anonymous
Mark Wee
Commented on July 24, 2025
A mid-sized company uses Veeam Backup and Replication to safeguard their business-critical data from ransomware attacks. The company needs to validate backups and increase security, while improving DevOps efficiency.
How can a SureBackup Job be utilized to address the company's specific needs?
it should be How can a SureBackup Job be utilized to address the company's specific needs?
asnwer should be this :
B) Validates backup data and ensures backups are ransomware-free
MALAYSIA
Edgar Santos
Commented on July 24, 2025
Question 36 , opcion b or d ?
Anonymous
Mark Wee
Commented on July 24, 2025
A company has an RPO set at 4 hours and values data protection and disaster recovery. A disaster occurs on June 12, 2023 at 10:00 AM. Which restore point gives the company the best RPO? It should be: June 12, 2023, 9:30 AM <--- yes, it does mentioned need 4 hours
MALAYSIA
Ola
Commented on July 23, 2025
Question 184 answer should be critical.
Anonymous
United States
Commented on July 23, 2025
great questions. Hope to pass the exam.
UNITED STATES
Edgar Santos
Commented on July 23, 2025
Very helpfull for my exams.
Anonymous
qq
Commented on July 23, 2025
helpful comment
UNITED STATES
m
Commented on July 23, 2025
valuable questions
UNITED STATES
Aryan
Commented on July 23, 2025
Good website
Anonymous
ThePredFrom76
Commented on July 23, 2025
These dumps are very helpful and very rich in term of content.
FRANCE
anonymous
Commented on July 23, 2025
easy to learn
CANADA
anonymous
Commented on July 23, 2025
explanation are very clear
CANADA
theo
Commented on July 23, 2025
questions are precisely correct
CANADA
venu
Commented on July 23, 2025
very helpful
UNITED STATES
United States
Commented on July 23, 2025
Handy questions, I hope exam question will be similar too.
UNITED STATES