DL Advanced and Specialized Skills 5

Question 1

A developer uses a 'virtual environment' when working on Python projects. What problem does this primarily solve?

Accepted Answer

Isolating project-specific package versions to avoid dependency conflicts

Answer

Running Python in a web browser

Answer

Securing code from unauthorized access

Answer

Compiling Python into machine code

Question 2

Which protocol is used to securely transfer files between a local machine and a remote server over an encrypted connection?

Accepted Answer

SFTP

Answer

FTP

Answer

HTTP

Answer

POP3

Question 3

A product manager wants to test whether a new website button color increases click-through rates. Which advanced testing methodology should be used?

Accepted Answer

A/B testing with statistical significance analysis

Answer

Focus group discussion

Answer

Usability heuristic evaluation only

Answer

A single-page survey

Question 4

In the context of digital forensics, what is a 'chain of custody'?

Accepted Answer

A documented record tracking who handled digital evidence and when

Answer

A blockchain-based file storage system

Answer

An encryption chain applied to sensitive logs

Answer

A process for transferring software licenses

Question 5

Which advanced Excel or spreadsheet function retrieves a value from a table based on a lookup value and column index?

Accepted Answer

VLOOKUP

Answer

COUNTIF

Answer

SUMPRODUCT

Answer

IFERROR

Question 6

A network engineer wants to segment a company's network to limit the spread of a security breach. Which technology achieves this?

Accepted Answer

Network segmentation using VLANs

Answer

VPN tunneling

Answer

Increasing firewall log verbosity

Answer

Installing antivirus on all workstations

Question 7

What distinguishes a 'data lake' from a traditional 'data warehouse'?

Accepted Answer

A data lake stores raw data in its native format at any scale, while a warehouse stores processed structured data

Answer

A data lake only stores structured relational data

Answer

A data warehouse is always stored in the cloud, a data lake on-premises

Answer

They are functionally identical but use different vendors