In SAP Datasphere, a local table is a physical data store within a space. There are several ways to create one with a custom name. Importing a CSV file is a direct method where the user uploads a file, and SAP Datasphere creates a new local table to store its contents, prompting the user to define its name and structure. Alternatively, a data flow can be used to transform data from one or more sources. The final output of this flow can be written to a new target table, which is created as a local table with a user-specified custom name. Both methods result in a new, persistent, and queryable local table.

A. By creating an intelligent lookup: An intelligent lookup creates a specific type of view used for data harmonization, not a general-purpose, physically stored local table.

C. By creating a persistent snapshot of a view: The standard method to materialize a view's data into a physical table is by using a data flow (Option D). The "Snapshot" feature is primarily for caching data from remote tables.

1. Importing a CSV file (Correct Answer B):

SAP Help Portal

SAP Datasphere

"Creating a Local Table from a CSV File". This official documentation outlines the step-by-step process of uploading a CSV file

which results in the creation of a new local table within a space. The user defines the table properties

including its name.

2. Adding an output of a data flow (Correct Answer D):

SAP Help Portal

SAP Datasphere

"Defining the Target Table". This guide explains how

within the Data Flow editor

a user can add a target table

choose to create a new table

and define its name and structure

thereby creating a new local table.

3. Intelligent Lookup (Incorrect Option A):

SAP Help Portal

SAP Datasphere

"Creating an Intelligent Lookup". This source describes an Intelligent Lookup as a modeling artifact (a view) that combines datasets to find matching values

distinguishing it from a base local table.

4. Snapshots (Incorrect Option C):

SAP Help Portal

SAP Datasphere

"Enable Data Access Controls and Data Caching for Remote Tables". This document clarifies that snapshots are a form of data caching used to replicate data from remote tables to improve query performance

not a primary method for materializing views.