Infosys Certified Databricks Analyst
Practice with real exam-pattern questions for Infosys Certified Databricks Analyst. 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 Databricks Analyst practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Databricks Analyst certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following statement(s) is/are correct? A. Databricks Notebooks support automatic change-tracking and versioning B. Databricks Notebooks support real-time coauthoring on a single notebook
- ✓
Only A
Correct - B
Only B
- C
Both A & B
- D
None of them
- ✓
- Question 2
There is a requirement to combine data from two different tables horizontally using a shared column as the key column. Output should have only those rows from "table_1" for which the value in the key column is present in both tables and all the rows from "table_2" Choose the correct SQL command that can accomplish the same.
- ✓
LEFT JOIN
Correct - B
INNER JOIN
- C
OUTER JOIN
- D
MERGE
- E
UNION
- ✓
- Question 3
An ELT job is scheduled to run which is triggered by a specific number of input records being ready to process. How to notify if the ELT job has not been run in an hour?
- ✓
Set up an Alert for the accompanying dashboard to notify if the returned value is greater than 60.
Correct - B
Set up an Alert for the query to notify when the ELT job fails.
- C
Set up an Alert for the accompanying dashboard to notify when it has not refreshed in 60 minutes.
- D
Set up an Alert for the query to notify if the returned value is greater than 60.
- ✓
- Question 4
From which of these menus job clusters can be configured?
- ✓
Create
Correct - B
Jobs
- C
Compute
- D
Users cannot configure the job clusters
- ✓
- Question 5
Which of the following incorporates deduplication while adding new records to the table in databricks?
- ✓
INSERT OVERWRITE
Correct - B
COPY INTO
- C
MERGE INTO WHEN NOT MATCHED INSERT *
- D
None of the above
- ✓
- Question 6
In which of the following tabs access to the data would be provided?
- ✓
Workflows
Correct - B
Data
- C
Workspace
- D
Permissions
- ✓
- Question 7
How long does SELECT query on streaming table/view take for completion?
- ✓
executes indefinitely
Correct - B
As long as streaming is happening
- C
maximum 10 mins
- D
None of the options
- ✓
- Question 8
The prefix to be added to file path in SELECT statement to fetch metadata of the file such as path, modified date etc. is?
- ✓
metadata
Correct - B
rawdata
- C
binaryFile
- D
None of the above
- ✓
- Question 9
Which of the following method accepts format(JSON) of incoming file as input by auto loader?
- ✓
option("cloudFiles.Format", "JSON")
Correct - B
options("format","JSON")
- C
option("cloudFiles.format", "JSON")
- D
option("cloudFiles.format", format)
- ✓
- Question 10
When pipeline is running live what appears on the pipeline UI?
- ✓
Status of data ingestion to different tables/views created
Correct - B
Status of execution of each notebook
- C
Both A & B
- D
None of the options
- ✓
More in DNA
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Infosys Certified Microsoft SSIS Advanced Developer
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.