Ensuring Compliance DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   In a Structured Streaming pipeline, which DataFrame operation is used to apply a masking function to a PII column?

   • Afilter() to remove PII rows
   • BorderBy() to sort PII values
   • CgroupBy() to aggregate PII values
   • Dselect() with a UDF or built-in function
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   In a batch pipeline using Spark DataFrames, which method is used to replace a PII column with a masked version?

   • Adf.agg({'email': 'count'})
   • Bdf.withColumn('email', masking_function(df['email']))
   • Cdf.drop('email')
   • Ddf.filter(df['email'].isNotNull())
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which built-in Spark SQL function can be used to mask a PII column by replacing it with a fixed string?

   • Aregexp_replace()
   • Bconcat()
   • Clit()
   • Dsha2()
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In a batch pipeline, which technique is commonly used to automatically detect PII fields before applying masking?

   • AApplying a regex-based pattern matching on sample data to identify fields like phone numbers or credit card numbers
   • BReading the data into a pandas DataFrame and using the .info() method
   • CManually inspecting the first few rows of the dataset
   • DUsing the DESCRIBE TABLE command to list all columns and their comments
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which masking technique replaces a PII value with a one-way cryptographic representation, making it irreversible?

   • ATokenization
   • BHashing
   • CEncryption
   • DRedaction
   Reveal Solution Discussion Select an answer first