vuthanhdatt's Second Brain

9

7 min read

Questions and Answers

Question QqXTmCsks1PvDTUGNsZb

Question

Identify how the count_if function and the count where x is null can be used

Consider a table random_values with below data.

What would be the output of below query? select count_if(col > 1) as count_a. count(*) as count_b.count(col1) as count_c from random_values col1 0 1 2

NULL - 2 3

Choices

  • A: 3 6 5
  • B: 4 6 5
  • C: 3 6 6
  • D: 4 6 6

Question Ls0lbEXY09HR2o1hmK3s

Question

Which two components function in the DB platform architecture’s control plane? (Choose two.)

Choices

  • A: Virtual Machines
  • B: Compute Orchestration
  • C: Serverless Compute
  • D: Compute
  • E: Unity Catalog

Question sQC88nWwPflUnkAzU2IU

Question

In a healthcare provider organization using Delta Lake to store electronic health records (EHRs), a data analyst needs to analyze a snapshot of the patient_records table from two weeks ago before some recent data corrections were applied.

What approach should the Data Engineer take to allow the analyst to query that specific prior version?

Choices

  • A: Truncate the table to remove all data, then reload the data from two weeks ago into the truncated table for the analyst to query.
  • B: Identify the version number corresponding to two weeks ago from the Delta transaction log, share that version number with the analyst to query using VERSION AS OF syntax, or export that version to a new Delta table for the analyst to query.
  • C: Restore the table to the version from two weeks ago using the RESTORE command, and have the analyst query the restored table.
  • D: Use the VACUUM command to remove all versions of the table older than two weeks, then the analyst can query the remaining version.

Question cyOBbupUqHUH0weIxfhT

Question

A data engineer wants to create a new table containing the names of customers that live in France. They have written the following command: //IMG//

A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII). Which of the following lines of code fills in the above blank to successfully complete the task?

Choices

  • A: There is no way to indicate whether a table contains PII.
  • B: “COMMENT PII”
  • C: TBLPROPERTIES PII
  • D: COMMENT “Contains PII”
  • E: PII

Graph View