Sophos Certified Engineer Exam Questions & Answers – Verified and Graded A+ | Latest Updated Edition

SOPHOS CERTIFIED ENGINEER EXAM QUESTIONS WITH VERIFIED
ANSWERS ALREADY GRADED A+
C

Terms in this set (54)


An upstream system has been configured to pass the date for a
given batch of data to the Databricks Jobs API as a
parameter. The notebook to be scheduled will use this
parameter to load data with the following code: df =
spark.read.format("parquet").load(f"/mnt/source/(date)")
E. dbutils.widgets.text("date",
"null")date = Which code block should be used to create the date Python
dbutils.widgets.get("date") variable used in the above code block?
A. date = spark.conf.get("date")

B. input_dict = input()date= input_dict["date"]

C. import sysdate = sys.argv[1]

D. date = dbutils.notebooks.getParam("date")

E. dbutils.widgets.text("date", "null")date = dbutils.widgets.get("date")

The Databricks workspace administrator has configured
interactive clusters for each of the data engineering groups.
To control costs, clusters are set to terminate after 30 minutes
of inactivity. Each user should be able to execute workloads
against their assigned clusters at any time of the day.
Assuming users have been added to a workspace but not
D. "Can Restart" privileges on granted any permissions, which of the following describes the
the required cluster minimal permissions a user would need to start and attach to
an already configured cluster.

A. "Can Manage" privileges on the required cluster
B. Workspace Admin privileges, cluster creation allowed,

"Can Attach To" privileges on the required cluster
C. Cluster creation allowed, "Can Attach To" privileges on the required
cluster
D. "Can Restart" privileges on the required cluster

E. Cluster creation allowed, "Can Restart" privileges on the required
cluster

, When scheduling Structured Streaming jobs for production,
which configuration automatically recovers from query
failures and keeps costs low?
D.
Cluster: New Job
A. Cluster: New Job Cluster;Retries: Unlimited;Maximum Concurrent
Cluster; Retries: Runs: Unlimited
Unlimited; B. Cluster: New Job Cluster;Retries: None;Maximum Concurrent Runs:
Maximum Concurrent Runs: 1 1
C. Cluster: Existing All-Purpose Cluster;Retries:

Unlimited;Maximum Concurrent Runs: 1
D. Cluster: New Job Cluster;Retries: Unlimited;Maximum Concurrent
Runs: 1
E. Cluster: Existing All-Purpose Cluster;Retries: None;Maximum
Concurrent Runs: 1
The recent_sensor_recordings table
contains an identifying sensor_id
alongside the timestamp and
temperature for the most recent 5
minutes of recordings.
The query is set to refresh each
minute and always completes in less
than 10 seconds. The alert is set to
trigger when mean (temperature) >
120.
E. The average temperature Notifications are triggered to be
recordings for at least one sent at most every 1 minute.
sensor exceeded 120 on three If this alert raises notifications for 3
consecutive executions of the consecutive minutes and then stops,
query which statement must be true?
A. The total average temperature
across all sensors exceeded 120 on
three consecutive executions of the
query
B. The recent_sensor_recordings
table was unresponsive for three
consecutive runs of the query
C. The source query failed to update
properly for three consecutive
minutes and then restarted
D. The maximum temperature
recording for at least one sensor

, exceeded 120 on three consecutive
executions of the query




A junior developer complains that the
code in their notebook isn't
producing the correct results in the
development environment. A shared
B. Use Repos to pull changes screenshot reveals that while they're
from the remote Git repository using a notebook versioned with
and select the dev- Databricks Repos, they're using a
2.3.9 branch. personal branch that contains old
logic. The desired branch named
dev-2.3.9 is not available from the
branch selection dropdown.

Which approach will allow this
developer to review the current logic
for this notebook?

, Which statement describes what will
happen when the above code is
executed?

A. The connection to the external
table will fail; the string
"REDACTED" will be printed.
B. An interactive input box will
E. The connection to the
appear in the notebook; if the
external table will succeed; the
right password is provided, the
string "REDACTED" will be
connection will succeed and the
printed.
encoded password will be saved
to DBFS.
C. An interactive input box will
appear in the notebook; if the right
password is provided, the
connection will succeed and the
password will be printed in plain
text.
D. The connection to the external
table will succeed; the string
value of password will be printed
in plain text.
E. The connection to the external
table will succeed; the string
"REDACTED" will be printed.