Infosys Certified Snowflake Testing Professional
Practice with real exam-pattern questions for Infosys Certified Snowflake Testing Professional. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Snowflake Testing Professional practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Snowflake Testing Professional certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following is/are the data model for Warehouse?
- ✓
Star
Correct - B
Snowflake
- C
Degenerate
- D
Conformed
- ✓
- Question 2
if we logout from snowflake and gain login back ,the worksheet content will go off
- ✓
Yes
Correct - B
No
- ✓
- Question 3
Snowflake can process which type of data?
- ✓
semi-structured data
Correct - B
structured data
- C
None
- D
Both a & b
- ✓
- Question 4
Which of the following is correct regarding Type-0 SCD.
- ✓
No changes allowed
Correct - B
Update record directly, there is no record of historical values, only current state
- C
Track changes as version records with current flag & active dates
- D
None
- ✓
- Question 5
John is trying to get todays date. What query he should write?
- ✓
Select current_date();
Correct - B
select getdate();
- C
select today();
- D
None
- ✓
- Question 6
SQL stands for
- ✓
Structured Query Language
Correct - B
System query Language
- C
Sub query Language
- D
None
- ✓
- Question 7
Which of the following statements are TRUE about an SQL query?
P : An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause
Q : An SQL query can contain a HAVING clause only if it has a GROUP BY clause
R : All attributes used in the GROUP BY clause must appear in the SELECT clause
S : Not all attributes used in the GROUP BY clause need to appear in the SELECT clause- ✓
P and R
Correct - B
P and S
- C
Q and R
- D
Q and S
- ✓
- Question 8
A star schema has what type of relationship between a dimension and fact table?
- ✓
Many-to-many
Correct - B
One-to-one
- C
One-to-many
- D
All of the above.
- ✓
- Question 9
MFA removal, number changes, or re-enrollment has to happen through support contact?
- ✓
For any above task support contact needed
Correct - B
All of the operations can be done by a user with 'accountadmin' role. Support contact is not needed.
- C
incident need to raise for above
- D
None of the above
- ✓
- Question 10
Write An SQL Query To Print The FIRST_NAME From Worker Table After Replacing ‘A’ With ‘a’.
- ✓
Select REPLACE(FIRST_NAME,'A','A') from Worker;
Correct - B
Select REPLACE(FIRST_NAME,'a','A') from Worker;
- C
Select REPLACE(FIRST_NAME,'A','a') from Worker;
- D
None
- ✓
More in IVS Academy
Infosys Certified TOSCA Automation Tester
Infosys certified Digital Accessibility Expert
Infosys Certified Data QE platform Expert
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.