Fabric Analytics Engineer Associate Practice Test

These questions are part of the practice quiz. Start practicing

• Which Fabric workload is used to move and transform data?
• Delta Lake stores tables based on which file format?
• Why consider basic data cleansing when loading data into Fabric lakehouse?
• In a Type 1 slowly changing dimension, what happens when a non-key attribute changes?
• You have previously run a pipeline containing multiple activities. What's the best way to check how long each individual activity took to complete?
• You have a Parquet file named Customers.parquet uploaded to a Fabric lakehouse and you want to load it into a pandas DataFrame using PySpark in a notebook. Which code should you run?
• For a survey, how many rows are added to the Response table per question in the survey?
• You want to use a pipeline to copy data to a folder with a different name for each run. Which approach should you take?
• In SQL Server, which datepart should be used with DATENAME to return the name of the day of the week?
• Which of the following is a valid step to hide a column from a security role in Tabular Editor?
• Which statement best describes projection pushdown when reading a CSV into Spark?
• In a Fabric survey data model, the third question in each survey response represents what?
• Which feature helps accelerate data exploration and cleansing in Fabric?
• What is one of Data Activator's strengths in interoperability with other Fabric experiences?
• In Delta Lake, what is the purpose of the VACUUM command?
• In a left anti join, which describes the result set?
• Which view should you use to identify commonly run commands in your data warehouse?
• In a DAX query intended for an XMLA endpoint, which sequence of keywords correctly starts the query?
• To minimize data shuffling when joining a large transactions DataFrame with a small customers DataFrame on the customer_id column, which join approach is best?
• Which Dataflows Editor option shows distinct values for a column and helps identify non-duplicate entries across customers?
• Which gateway type is suitable when multiple users need to connect to multiple on‑premises data sources?
• Which combination lists the four data ingestion methods for loading data into a Fabric data warehouse?
• Which dynamic management view helps identify long-running report requests in a Fabric warehouse?
• Where should you create a table shortcut when querying lakehouse data stored in S3 via the SQL endpoint?
• For ResearchReviewersGroup2, which workspace role should you assign?
• To enable T-SQL-based data cleanup in a Fabric Warehouse, which object type is best suited?
• What is the default storage format for Fabric's OneLake?
• For determining whether queries are mapped to aggregated data via user-defined aggregations, which single tool is most suitable for profiling queries in a semantic model?
• A data model includes a products table and a sales table. A relationship is created between them. Which cardinality should be set to achieve an optimal model?
• In a Power BI model with no physical relationship between two tables, which DAX function maps values from one table into another to create a virtual relationship?
• When using Row-Level Security, what is the primary purpose of the security predicate?
• For a Dataflow Gen2 creating a new dimension table that must immediately relate to the central fact table, which schema option should you select in the data destination?
• In Real-Time Intelligence, which statement best describes the KQL database?
• Which tool can help identify memory-heavy columns loaded into memory in a Direct Lake model?
• What is a data pipeline?
• What is the purpose of a security predicate function in Row-Level Security (RLS)?
• What is the recommended approach for bootstrapping the initial load of a large dataset published to the service?
• For near-real-time reporting with minimal development effort on a lakehouse with heavy historical data and frequent incremental updates, which storage mode is most suitable?
• What is the recommended approach to ingest data into the bronze layer of the Lakehouse Medallion Architecture to minimize implementation effort?
• Which tool can update a measure definition in a large model without refreshing in the Power BI service?
• What does a custom theme file for Power BI specify to standardize visuals across reports?
• In the query, which functions should you use for ChargedQuantity and OrderPrice?
• In Tabular Editor 2, to load data to a table without rebuilding hierarchies and relationships and without recalculating calculated columns and measures, which process mode should you use?
• To enable incremental refresh, which two parameters should you add to Power Query?
• When optimizing a dataflow that filters a DateTime column to the current year, what sequence improves performance?
• In Microsoft Fabric, which component is used for integrated data storage and processing?
• For scenario 2 (overwrite the existing value in the latest row), which Slowly Changing Dimension type is appropriate?
• Which action should you perform to ensure embedded reports require authentication and only read-only (live) connections to cloud semantic models?
• What determines the maximum allowed dataset size when large dataset storage format is enabled?
• Which DAX pattern optimizes a measure by using a variable and SWITCH for the result?
• In a dataflow, how many transformation steps will fold?
• For optimizing a complex semantic model and reducing the number of joins, which tables should be denormalized?
• What does the NOT ENFORCED attribute imply when adding a PRIMARY KEY constraint in a database?
• Which of the following DAX expressions correctly activates an inactive Date to ShipDateKey relationship for the Shipped measure?
• Which approach is best for a one-time copy of a small local file into the lakehouse when convenience is prioritized?
• When diagnosing slow DAX performance, which two elements can you view in Power BI to understand how time is spent?
• Which statement best describes a typical use of VACUUM in Delta Lake?
• What is the primary benefit of using a calculation group in a data model?
• You plan to use Data Wrangler to view basic summary statistics for the Customers.parquet data before loading it to a Delta table. Which tool should you use?
• To enable a Fabric Shortcut to access a firewall-protected Data Lake, which step is essential?
• A model includes a products table and a table with monthly category targets; each product can belong to multiple categories and each category can have multiple products. Which cardinality should be set?
• Which KQL keyword is used to group and aggregate data?
• What is the primary language used for querying a data warehouse?
• If you want a Power BI semantic model to be reusable by multiple reports without an enterprise data warehouse, which component should you create?
• What is the most efficient approach for data transformation when designing data models for scalability?
• You want to merge two Azure SQL tables so the combined table contains all rows from Product and the matching rows from ProductCategory. Which join configuration should you use?
• If you drop a managed Delta table whose data resides in a folder, what happens to the table and data?
• Which engine processes the added custom step in a dataflow?
• In numeric data summaries, which option correctly states an additional function included beyond COUNT, MEAN, and STD?
• Which Tabular Editor tool should you use to audit a model for performance or design issues?
• To apply logic-based DAX formatting to a single measure with minimal administrative effort and without modifying other measures, which approach should you use?
• To ensure that foldable Power Query transformation steps are processed by the Microsoft SQL Server engine during ingestion from Azure SQL, which configuration should you apply?
• Which statement is true about the COPY statement in Warehouse in terms of supported data sources and file formats?
• Which statement correctly describes using a Data Factory workload to create a Dataflow Gen2 for transformation before loading into a lakehouse?
• Which requirement describes how Research division workspaces should be organized to support OneLake data hub filtering based on department name?
• To monitor capacity unit consumption in Fabric data warehouses, which tool should you use?
• What is the primary effect of broadcasting a small DataFrame when joining with a large DataFrame in Spark?
• To enable a Fabric Shortcut to access an Azure Data Lake Storage Gen2 account behind a firewall, which initial step is required?
• A data pipeline is scheduled to run every four hours on Mondays and Fridays. Which Repeat setting should be chosen?
• In Dataflows Query Editor connected to an Azure SQL customer table, which option helps identify which column contains non-duplicate values per customer?
• With 1 TB legacy accounting data in Azure Data Lake Gen2 and annual ad-hoc reporting needs, which Fabric architecture and integration approach minimizes admin costs while enabling reporting and analysis?
• Which command would you use to review the history of a Delta Parquet table named FactSales?
• You want to monitor capacity unit consumption in your Fabric data warehouse. What tools should you use?
• Your Fabric Model1 refresh fails due to resource exhaustion. Which statement explains the likely cause?
• Which function should be used to rank results without gaps when there are ties in SQL?
• Which DAX function should you use to create a virtual relationship between two tables without a physical relationship?
• In Fabric, which statement best describes the relationship between a Data Factory workload and Dataflow Gen2?
• For a report that requires current-year data and table-level security, which authentication method and mode should you choose?
• When using a Dataflow Gen2 to transform and append 1000 records daily into a Fabric Lakehouse, which staging setting should you choose?
• In a star schema, what is the primary purpose of a surrogate key in a dimension table?
• In DAX Studio, which feature should you enable to capture the queries executed by a report?
• Which action would you take to reference external Gen2 data in the lakehouse without copying it?
• What is the recommended minimum file size when working with external data on files in Microsoft Fabric?
• What tool should Mary-Jo use to ensure all data models adhere to data modeling best practices?
• Which Power Query transformation generally prevents query folding and should be avoided if you want to preserve folding?
• In a Power BI semantic model using Direct Lake mode, which option describes querying data directly from the lake without importing it?
• Which external tool can show the size of each table and column in a model?
• Which tool should you use to determine if query throttling is occurring in a Fabric warehouse?
• Which statement best describes the effect of Dynamic Data Masking on data storage?
• Which Fabric data store should be used to store data on OneLake and support CREATE TABLE statements?
• RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip ) describes which ranking behavior?
• What is a primary benefit of denormalizing dimension tables in a semantic model?
• In Power Query, which transformation is known to break query folding when splitting a column either by position or delimiter?
• Which statement best describes a notebook in Fabric?
• To build a Fabric analytical data store that supports a relational schema for SQL queries and stores data on OneLake, which option fits?
• In a calculation group, to switch context to month-to-date (MTD), which DAX expression is correct for the calculation item?
• Which tool accelerates data exploration and cleansing in Fabric?
• Which tool should you use to programmatically modify every column whose name ends with "Key" in a semantic model?
• Which set of permissions correctly assigns access to data engineers, data analysts, and data scientists to satisfy the security requirements?
• Which tool is specifically designed to verify that data models adhere to established best practices across the organization?
• You save a DataFrame to Parquet with partitionBy year, month, and day. Which statement about the resulting files is true?
• Which Power Query function should you use to identify the maximum values for numeric columns when loading a new dataset from OneLake into the warehouse?
• In a star schema for a customer dimension using SCD Type 2, which column is typically added to support versioning of records?
• Which feature should you use to review MLflow's tracking results through a UI?
• What is the purpose of the ROW_NUMBER() function when used with ORDER BY in a query?
• To limit data in a lakehouse shortcut to CustomerID 100, which step should be taken when creating the shortcut?
• What is the primary advantage of using a custom theme in Power BI report development?
• When querying a Delta table, which statement about metadata queries indicates maintenance events were recorded?
• Which tool is best suited for data transformation in Fabric when dealing with large-scale data that will continue to grow?
• Which command would you use to view the query plan for how a Delta table query will be executed?
• What is true about promotion and certification in Fabric?
• To minimize costs while providing access for 20 report creators and 350 report customers in Fabric, which licensing option would you recommend?
• You need to connect to and transform data to be loaded into a Fabric lakehouse using Dataflows Gen2. How would you complete this task?
• In a Direct Lake semantic model with 500 million rows, which mode will DAX queries use?
• To group workspaces for certain company divisions that should support OneLake data hub filtering, which pairing of grouping method and tool is correct?
• To perform a one-time ingest of a small local CSV into a Fabric lakehouse with minimal administrative effort, which method is recommended?
• To interactively explore data in a file in the lakehouse using Spark, which option should you use?
• To permit a user to truncate tables only within schemaA, which X and Y tokens should be used in the GRANT statement?
• Which set of layers is typically associated with the Medallion Architecture for data management?
• Which DirectQuery-related best practice is specifically about ensuring data integrity in relationships?
• In a Fabric Spark job reading a CSV with header and selecting specific columns, which statement is true?
• Which function allows you to activate an inactive relationship between Date and ShipDateKey for a calculation?
• Delta Lake is best described as what in relation to Spark?
• Which syntax should you use to read data from a Lakehouse shortcut named ResearchProduct in Lakehouse1?
• Which statement about the effect of a DESCRIBE HISTORY query on a Delta table’s maintenance history is correct?
• What feature should be used to connect Dataverse data to Fabric for integration into Lakehouse shortcuts?
• What is the purpose of V-Order and Optimize Write in Delta tables?
• Within a Fabric lakehouse environment, where should a data analyst create a shortcut to access data stored in an external Amazon S3 bucket via the SQL endpoint?
• For an RLS-enforced model where reports need fastest performance, where should RLS rules be applied?
• To display the value breakdown between starting balance and ending balance across customer segments, which visual should you use?
• Which architecture best supports creating a relational data store on OneLake with SQL CREATE statements?
• What happens when a user is granted a permission and then denied the same permission in a warehouse?
• What determines the data model size limits on a dataset when large dataset storage format is enabled?
• In the Medallion Architecture, which layer would you expect to contain raw data?
• Which statement best describes a main benefit of Real-Time Intelligence in Fabric?
• Which Spark DataFrame writer option controls how data is distributed into folders when saving?
• To enable read-write access to a dataset named DS1 via the XMLA endpoint, which setting must be modified first?
• What is the correct sequence to identify the slowest DAX query and compare DAX engine vs storage engine timings?
• What is the purpose of incremental refresh in a large fact-table model?
• Which statement best describes active vs inactive relationships in a data model?
• What is the purpose of a fact table in a data warehouse?
• A matrix visual renders slowly; after using Performance Analyzer and DAX Studio, the DAX query runs fast in DAX Studio. What should you do next?
• In Spark, which statement accurately describes the difference between df.explain() and df.describe() or df.summary()?
• Which column statistics should you update to improve query performance when table statistics are out of date?
• If you want to forecast monthly expenses, which modeling approach would you use?
• Which of the following best practices for Power BI data modeling is relevant only to DirectQuery models?
• In a data warehouse, what is the primary purpose of a dimension table?
• When choosing between filtering on a dimension table versus a fact table, which yields faster performance?
• To reduce the size and number of files in a Delta Parquet table with a long version history and a six-month retention policy, which maintenance operation should be run?
• Why can performing a split by position on a column cause a dataflow to load more data than expected?
• To meet the requirement of a date dimension spanning 2010 through the end of the current year, which method can be used to populate the date dimension table?
• What is Dataflow Gen2?
• What is the role of a KQL database in Real-Time Intelligence?
• In a data model where a single product can appear in many sales records, which cardinality describes the relationship between the product and sales tables?
• Which license type is typically sufficient to grant read access to reports without requiring Pro or PPU?
• Which general requirement should be followed to minimize privilege exposure?
• Which function should be used to set PeriodDate to the first day of the month from OrderDate?
• Which operation should you schedule to remove Delta Lake data files that are no longer used?
• In OneLake security, which permission should you assign to User1 to meet the requirement 'Read all spark data'?
• Which Fabric capacity SKU is appropriate for a dedicated, on-demand capacity with per-minute billing for specialized analytics work?
• In the Fabric data pipeline UI, which type of activity supports parameterization (allowing you to pass runtime values)?
• In Microsoft Fabric, item permissions in a workspace are used to grant access to what?
• What is Data Activator's capability in real-time data analysis?
• To integrate tables created in Dataverse into Fabric Lakehouse on OneLake and have them show up as valid Shortcut options, what must you do first?
• Which role should be granted to an administrator who needs to monitor the health of a Fabric capacity, following the principle of least privilege?
• In a semantic model deployed to Development, Test, and Production, to reduce the size of query requests during full semantic model refreshes in Development or Test, what should you do in the deployment pipeline?
• What is the primary advantage of Dynamic Data Masking (DDM)?
• You have a historical dataset of monthly expenses and want to forecast next month's values. Which modeling approach is appropriate?
• In a Power BI semantic model, which storage mode should aggregated tables use?
• Which language should you use in Dataflow Gen2 to transform data when ingesting from Azure SQL Database into a Lakehouse?
• Which ranking behavior is associated with the RANK() function when there are ties?
• In a left join, which statement describes the result of the join?
• Which Fabric workload experience lets you create a Dataflow Gen2?
• Which objective is emphasized when refreshing the Orders table to minimize impact?
• Which action ensures the destination table matches the external data schema when copying data with a changing schema?
• What is the simplest way to analyze data stored as CSV using Spark in Fabric?
• Why is indexing important in a data warehouse?
• Which command sequence would correctly delete unreferenced files older than the retention policy for a Delta table?
• Which of the following is NOT a stated reason for basic data cleansing when loading into Fabric lakehouse?
• What is a key benefit of using Microsoft Fabric in data projects?
• To add a primary key constraint to a table as NONCLUSTERED and NOT ENFORCED, which T-SQL statement is correct?
• Incremental refresh for a Fabric OneLake data model fails due to resource constraints. Which statement is correct?
• In Spark, which function is used to extract the year from a date column?
• For scenario 1 (create a new version of the row), which Slowly Changing Dimension type is appropriate?
• Which solution is most suitable for creating a data store that supports dataflows and ensures delta tables are V-order optimized automatically?
• Which operation should you schedule to combine small Delta Lake files into larger ones?
• Which tool is commonly used to inspect DAX queries outside the report to diagnose performance issues?
• In Microsoft Fabric, what type of capacity do you need to be able to pause and resume, and to scale up and down based on organizational needs?
• Which KQL keyword is used to limit the results of a query to a specified number of rows?
• In DAX, to specify a fixed date boundary such as 2023-12-01 in a query, which function is used?
• If you need to increase Fabric capacity unit size to resolve a compute issue, which portal should you use?
• Which combination of actions should you enable to enable external tools to create Fabric items and access XMLA while following least privilege?
• Which dynamic management view can help identify memory-heavy columns loaded into memory in a Direct Lake model?
• What is the main limitation of using XMLA endpoints for the Microsoft Power BI deployment process?
• Which activity should you add to Pipeline1 to copy CSV data into Lakehouse1 and support Power Query M expressions?
• Which practice preserves query folding and improves performance in data transformation workflows?
• To ensure that queries against a Direct Lake semantic model always use Direct Lake mode, where do you configure this setting?
• Which expression is used to define the PricingGroup based on ListPrice thresholds?
• What are the supported data sources and file formats for the COPY (Transact-SQL) statement in Warehouse?
• If you only need metadata copied from schema1.city to schema2.city, which statement would you run?
• To create a virtual relationship for filtering across an unrelated table, which DAX function should be used?
• In DirectQuery mode, which change reduces the number of queries when using filters and slicers?
• Which statement best describes Direct Lake mode?
• What is a Microsoft Fabric Lakehouse?
• For consolidating supplier attributes used in claims, which type of table is appropriate?
• To allow deployment to Development and Test workspaces only, which access should be granted to those workspaces?
• In the described dataflow scenario, which step generates the two columns OrderDateTime.1 and OrderDateTime.2?
• In Power BI, what approach minimizes administrative effort when applying the same time intelligence calculations to many measures?
• What is the benefit of storing different layers of your lakehouse in separate workspaces?
• Which statement about the VACUUM operation is accurate?
• In a Dataflows Query Editor, which option would you select to view the frequency of values and identify duplicates by count per value?
• To allow a Power BI bar chart to change its y-axis category using a slicer, which feature should be added?
• Which method should be used for a one-time copy of a small local file into the lakehouse when you want to minimize setup?
• Which tool should be used to implement calculation groups for the Research division semantic models?
• You want to include data in an external Azure Data Lake Store Gen2 location in your lakehouse, without the requirement to copy the data. What should you do?
• You want a security role SalesRegionManager to not see the Address column in SalesAddress. Which sequence of steps is correct in Tabular Editor?
• How can you customize the appearance of a Power BI report?
• In Fabric with Apache Spark, which artifact should you create to explore data interactively?
• The date dimension must always contain dates from 2010 through the end of the current year. Which option satisfies this requirement?
• In a scenario with a very large dataset, which action best reduces rendering time for a report containing many visuals?
• Which dynamic management view provides details about SQL commands running in the data warehouse?
• A Fabric notebook ingestion process must run daily at 7:00 AM and retry up to two times if source missing; minimal development effort. Which approach meets this?
• For a Fabric workspace with a large lakehouse containing historical data and frequent updates, which semantic model storage mode yields best performance for near real-time reporting?
• For ResearchReviewersGroup1, which workspace role should you assign?
• Which statement best describes Dataflow Gen2 capabilities in Fabric?
• Which tool can create partitions in the Power BI service without processing them?
• What is the purpose of item permissions in a Fabric workspace?
• When persisting a Spark DataFrame to storage for Delta Lake use, which format should you write in?
• What is the purpose of creating a Reflex in Data Activator?
• Which Fabric capacity SKU is appropriate for Research division, given requirements for dedicated on-demand capacity and per-minute billing?
• What data storage solution located in a Fabric workspace supports access via T-SQL or Python and can store unstructured or semi-structured data?
• What is the benefit of using Fabric notebooks over manual uploads for data ingestion?
• Which option would you use to load data into a Fabric data warehouse via SQL?
• Which statement best describes the effect of TOP 10 in a SQL query after an ORDER BY clause?
• Which statement best defines a semantic model in a data warehouse context?
• To merge Sales with ExceptionRecords in Dataflow Gen2 such that Sales excludes any records found in ExceptionRecords while preserving query folding, which applied steps should you use?
• What is the purpose of Reflex in Data Activator?
• What mode must the Research division semantic models use?
• Fabric Domains are primarily used to support which capability?
• To restrict access to a column (SSN) so that payroll employees can see it and others cannot, which feature should be used?
• In the SQL example, what are the Ranking values for the first two records?
• Which Fabric UI component would you use to examine MLflow experiments?
• Which measure is most likely to perform best when filtering by a specific calendar year?
• Which change reduces memory usage by adjusting how DateTime data is stored?
• To enforce RLS with a dynamic rule that restricts access to sales regions per user, what should you create?
• Which statement best describes the concept of capacity in Fabric?
• Which dynamic management view provides details about SQL commands running in the data warehouse?
• What database object type is used to hold the computed results for the pricing group in the example 'ProductsWithPricingGroup'?
• Replacing the FILTER function with KEEPFILTERS reduces execution time in which scenario?
• In the described dataflow with two lakehouses, non-folded steps are executed by which engine?
• What is the fastest refresh interval you can configure for Dataflow Gen2 native refresh scheduler?
• Where can you check and enable high concurrency mode for notebooks when working in a Fabric environment?
• To help department teams find data relevant to them, which option supports OneLake filtering by grouping workspaces?
• In a Python visual within a Microsoft Power BI report, if you want all rows to appear, which change should you apply?
• What does setting Available in MDX to False do for a column?
• In the data view for a Power Query dataflow, which option shows the distribution of column values?
• If row-level security must filter data based on the viewer's identity using dynamic rules, what should you implement?
• For a small daily load of 1000 records via Dataflow Gen2, what is the recommended staging setting?
• In OneLake security, which permission should you assign to User2 to meet the requirement 'Read all SQL endpoint data'?
• In a Copy Data activity, which Destination setting ensures the destination table is replaced with the source data?
• Where in the Fabric Admin portal can you enable Fabric environments when migrating from Azure Synapse Analytics due to permission issues?
• If a survey has 5 questions, how many total rows are created across the Survey and Response tables when the survey is submitted?
• In a Fabric notebook, which approach profiles the DataFrame with minimal administrative effort?
• If you also want to copy the data, which statement would you run?
• You have a Fabric workspace and an Azure Data Lake Storage Gen2 account. You want to create a shortcut to storage1 in Lakehouse1. Which connection type and endpoint should you specify?
• Which statement accurately describes how a Data Factory workflow interacts with a Dataflow Gen2 when loading data into a lakehouse?
• Which storage mode should the detailed fact table use to enable real-time queries against the source?
• Which storage options and file formats are supported for COPY when using Transact-SQL in Warehouse?
• In the pricing logic, which ListPrice threshold maps to the 'low' pricing group?
• In Power Query Editor, which option shows the percentage of valid records in a column?
• Where in the lakehouse UI should you create a shortcut to access data stored in Amazon S3?
• Which of the following statements is true about the ListPrice thresholds mapping to 'low', 'medium', and 'high' PricingGroup?
• Given a report where a visual's DAX query takes 27 ms, visuals total 39 ms, and other 1047 ms, what change yields the greatest rendering improvement?
• When a slicer causes visuals to render slowly, which tool should you use first to troubleshoot?
• To ensure each customer's sales data is written to its own Parquet file, which data pipeline configuration should you implement?
• In the Medallion Architecture, which layer contains curated, aggregated data for business reporting?
• In the ingestion and history review, what is the retention policy applied to the lakehouse table mentioned?
• When you create a clone using CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales, which statement is true?
• To transform data into attribute–value pairs by turning columns into rows, which operation should you apply in a data flow when the VendorID column is selected?
• What file format should you use to save a semantic model using the Tabular Model Definition Language extension for Visual Studio Code?
• To ignore spaces when joining data from a database and a lakehouse with minimal development, which approach should you take?
• In a star schema, which type of table stores measurable events or facts such as totals or counts?
• For a semantic model that must enforce security and reflect current-year data, which authentication method and mode should be used?
• To identify surrogate key columns in a model whose Summarize By is not None, which tool should you use?
• Which storage mode should dimension tables use to maximize caching and performance for filtering?
• Which file format is recommended for data files stored in S3 to enable efficient querying via a SQL endpoint?
• If a data source is only available in narrow time windows, which dataflow design best ensures the source is copied as-is and usable for later transformations?
• In Delta Lake, what does the OPTIMIZE command do?
• Partitioning a lakehouse table by CustomerID primarily enables which performance benefit?