Question 570 A compliance officer requests access to audit logs containing user identifiers. What least-privilege principle should guide granting that access? Give public SELECT to show transparency Publish raw tokens from logs to dashboards Allow all users to delete audit records Limit audit-data readership to authorized reviewers and the necessary retention scope Explanation Correct Answer D:Audit datasets can contain sensitive identity and activity records and should themselves be governed. Incorrect Answers A:Public audit log access may expose sensitive operational information. B:Raw credentials must not be exposed through audit reports. C:Deletion could destroy evidence needed for investigations.
Question 571 A data steward sees an external table and a managed table both based on Delta format. Which attribute best predicts their storage lifecycle handling? Infer managed versus external storage from the number of data columns The registered table type and its managed/external ownership semantics The number of notebook cells that queried the table Determine lifecycle solely from whether both tables use Parquet files Explanation Correct Answer B:Delta format alone does not specify who controls the underlying storage location and drop lifecycle. Incorrect Answers A:The schema shape does not determine who manages physical file lifecycle; the catalog table type and ownership do. C:Notebook activity does not define managed versus external ownership. D:Managed and external Delta tables can share a file format while differing in who controls their storage lifecycle.
Question 572 A policy administrator wants to test whether a service principal accidentally bypasses a department-level row filter. What experiment is suitable? Run the policy test only as a privileged table owner who may be exempt from the row filter Only query as the table owner Inspect only the row-filter function source text without testing effective results under the job principal Run the same representative row-scope query under the service principal and a restricted human user Explanation Correct Answer D:Contrasting effective identities reveals whether policy conditions and group entitlements behave as expected. Incorrect Answers A:A privileged account’s results do not prove whether the service principal and ordinary restricted users see correct row scopes. B:Owner behavior cannot establish restricted principal policy enforcement. C:A syntactically correct policy can behave differently under execution identities; representative identity-scoped queries are needed.
Question 573 A newly onboarded data team requests a common location to govern CSV and JSON files consumed by notebooks, with distinct file read versus write grants. Which feature matches? Only a materialized SQL view over a nonexistent table Unity Catalog volumes with READ VOLUME and WRITE VOLUME privileges Give everyone read access to a single external table instead of governing file access Only an unmanaged local `/tmp` folder Explanation Correct Answer B:Volumes expose governed file paths and distinguish consumer read rights from writer privileges. Incorrect Answers A:A SQL view does not itself establish controlled raw file storage. C:A table SELECT grant does not replace READ VOLUME/WRITE VOLUME controls over CSV and JSON files in governed volumes. D:Ephemeral ungoverned local paths do not deliver central file access control.
Question 574 A producer needs to correct a wrongly published Delta Sharing table without exposing unapproved raw fields to recipients during remediation. Which approach is prudent? Grant recipients raw catalog access for debugging Only change the share description text Restrict or suspend the affected shared object, repair the curated output, and validate recipient-visible fields Allow every recipient to edit provider source tables Explanation Correct Answer C:Controlling exposure during a fix prevents additional unapproved reads while the provider corrects the shared dataset. Incorrect Answers A:Broader direct access would worsen the identified disclosure problem. B:Changing descriptive text does not remove sensitive values from the shared object. D:External writers are not an appropriate response to an inadvertent sharing exposure.
Question 575 A platform team discovers that a newly created schema contains tables with inconsistent read privileges because different owners granted access individually. What is a more maintainable approach? Grant all data as public Use reviewed schema-level group grants and explicit exceptions where required Set warehouse auto scaling to maximum Give every user ownership of the catalog Explanation Correct Answer B:Centralized group-based privileges can reduce inconsistent per-table manual grants while respecting sensitive-object exceptions. Incorrect Answers A:Public access would eliminate the required restrictions. C:Compute scaling does not resolve inconsistent governance grants. D:Catalog ownership is too broad and does not create a suitable read-only access model.
Question 576 A Delta table contains approved public columns alongside confidential ones. A partner needs just the public fields and must not query the raw table directly. What should the provider publish? Cloud storage keys for the entire table directory A governed projection containing only permitted columns with narrowly scoped recipient access Only a dashboard description Full table SELECT with a note explaining which columns not to use Explanation Correct Answer B:A curated projection or published derived asset can enforce the agreed field exposure boundary. Incorrect Answers A:Storage credentials bypass the intended column restriction. C:Descriptive metadata does not itself supply the protected data view. D:Unrestricted raw access violates the partner's field-level agreement.
Question 577 An identity team rotates a service principal credential but a production pipeline begins failing to read protected data. Which distinction should the operator check first? Grant additional table privileges before confirming the new credential authenticates Inspect only the target table’s grants and skip whether the rotated credential now authenticates Change the destination table metadata but keep the CSV reader using a comma separator Whether authentication now succeeds and the principal retains the correct effective catalog grants Explanation Correct Answer D:Authentication failures and authorization failures have different remedies; both must be checked for the actual pipeline identity. Incorrect Answers A:Grant changes are premature if the principal cannot authenticate, and they may unnecessarily expand access. B:A valid catalog grant cannot help when the client no longer authenticates successfully as the service principal. C:The malformed load is caused by the mismatch between actual tab delimiters and parsing settings; table metadata does not fix it.
Question 578 A customer feed contains one JSON object per line with nested `profile.address.zip`, and analysts need the original nested structure in bronze. Which input representation is most suitable? Read JSON with nested struct fields retained in a bronze Delta table Immediately flatten all raw nested content and discard the source payload Split every line on commas without a JSON parser Treat the feed as fixed-width text with no field schema Explanation Correct Answer A:Nested JSON can be parsed to struct fields and preserved for controlled later transformations. Incorrect Answers B:Premature loss of the original structure undermines traceability and later schema recovery. C:Commas inside strings or nested objects make naive splitting unreliable. D:The given source is structured JSON, not fixed-width records.
Question 579 An inbound SFTP partner delivers a file with a `.csv` extension whose content is actually tab-delimited. Which ingestion setting must be corrected? The CSV delimiter option must match the actual tab-separated content Only the cloud storage bucket name Modify only the destination table’s description while retaining an incorrect CSV separator The Delta table retention period Explanation Correct Answer A:A CSV reader must use the file's real separator or the parser may place whole rows into one field. Incorrect Answers B:Storage naming does not alter separators inside file content. C:A table description does not change the delimiter used by the CSV parser; the reader must match the incoming tab-separated file. D:Retention does not control input tokenization.
Question 580 A supplier quotes fields with embedded line breaks in CSV descriptions. The initial ingest splits a single invoice into multiple records. What should be investigated? CSV multiline and quoting settings for the actual supplier format Only renaming the description column Only increasing cluster idle timeout Only lowering Delta retention Explanation Correct Answer A:Embedded newlines inside quoted fields require reader options compatible with the source CSV dialect. Incorrect Answers B:Column aliases cannot recover rows split at incorrect quoted line breaks. C:Idle timeout does not fix row boundary parsing. D:Retention does not make malformed row boundaries valid.