A data analyst worked on a project that contained medical content and a list of requirements. Which of the following are most likely the reasons the privacy team flagged the analyst's report? (Choose two.)
A. The exclusion of data occurred only after a participant invoked a right to withdraw.
B. The method used to anonymize identifying values in the data was insufficient.
C. The practice of data masking was irreversible and all PII was lost.
D. The directive did not mention that it was vital for PHI to be encrypted in the data set.
E. The retention policy did not allow data to be used beyond one year after the project.
F. The collection of data was stored according to protocols that are too strict.
Show Answer
Correct Answer: B, D
Explanation: Insufficient anonymization can leave medical data identifiable or re-identifiable. The report also failed to specify encryption safeguards for PHI, which is a significant privacy and security concern. The other choices describe safeguards or do not identify a clear privacy weakness.
Question 22
A data analyst is creating a new data set that involves bringing together the following data sets:
Which of the following would be the output rf the data analyst does a FULL JOIN?
A.
B.
C.
D.
Show Answer
Correct Answer: D
Explanation: A FULL JOIN keeps every ID from both tables. IDs 23525 and 11290 match; Ellen’s ID 12141 has no address, and address ID 11040 has no name or date of birth.
Question 23
Which of the following data structures would a data engineer most likely receive when using a get command?
A. HTML
B. XLSM
C. CSS
D. JSON
Show Answer
Correct Answer: D
Explanation: A GET request commonly retrieves data from an API, which is often returned as JSON—a structured format that applications can readily process.
Question 24
A data analyst is cleaning up a data set that contains images. The analysts wants to keep everything that was produced within the last 12 months. Which of the following best describes where the analyst should check for the date of creation on these products?
A. The data dictionary of the data set
B. The metadata of each item in the data set
C. The data set creation date on the database
D. The folder creation date on the filesystem
Show Answer
Correct Answer: B
Explanation: Creation dates for individual images are recorded in each item's metadata. The dataset or folder creation date describes the collection or folder, not when each image was produced.
Question 25
A data analyst creates a report that identifies the middle 50% of the collected data. Which of the following best describes the analyst’s findings?
A. Interquartile range
B. The difference between mode and median
C. Mean variance
D. Skewness from the slope
Show Answer
Correct Answer: A
Explanation: The interquartile range (IQR), calculated as Q3 − Q1, spans the middle 50% of the data.
Question 26
A database administrator is investigating the reason a reporting job failed. The target-layer schema remained unchanged from the last run, and the database server is scalable. All of the users have default execute privileges on the report. Which of the following attribute changes most likely caused this incident?
A. Data lineage
B. Data type
C. Data volume
D. Data access
Show Answer
Correct Answer: C
Explanation: An increase or unexpected change in data volume can cause a reporting job to exceed processing, memory, or runtime limits even when the target schema is unchanged and the server is scalable. The unchanged schema makes a data-type change less likely, and default execute privileges make an access change less likely.
Question 27
A Chief Executive Officer requests a report that must:
• Summarize the company metrics in a simple way
• Be clear and concise.
• Be easily understood by all company levels
• Be accessible and updated without manual intervention
Which of the following communication approaches best meets these requirements?
A. Executive summary
B. Slide presentation
C. Key performance indicator dashboard
D. Open data portal
Show Answer
Correct Answer: C
Explanation: A KPI dashboard presents key company metrics in a concise, easy-to-understand format and can be made accessible across the organization while updating automatically from connected data sources. An executive summary or slide presentation typically requires manual preparation, while an open data portal is broader and less focused on a simple company-wide summary.
Question 28
Which of the following data repositories stores unaltered data?
A. Data lake
B. Data warehouse
C. Data table
D. Data factory
Show Answer
Correct Answer: A
Explanation: A data lake stores data in its raw, unaltered form. Data warehouses generally store processed and structured data.
Question 29
Which of the following differentiates stress testing from UAT?
A. Stress testing engages end users in the testing process
B. Stress testing gathers feedback to share with developers
C. Stress testing identifies potential failures and optimizes performance
D. Stress testing detects flaws missed during design and development
Show Answer
Correct Answer: C
Explanation: Stress testing evaluates how a system performs under extreme workloads to reveal bottlenecks and potential failures. UAT instead has end users verify that the system meets their needs.
Question 30
An analyst uses a server's storage to keep a large amount of files, images, and videos. Which of the following describes this type of storage?
A. GUID
B. BLOB
C. UUID
D. OLAP
Show Answer
Correct Answer: B
Explanation: BLOB (Binary Large Object) storage is used for large, typically unstructured data such as files, images, and videos. GUID and UUID are identifiers, while OLAP is for analytical processing.
$19
Get all 146 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
