C_DS_42 Online Practice Questions and Answers
When you log in to the Management Console, Where you must log in as a user defined?
A. Central Management Server (CMS)
B. Management Console
C. Data Services Management Console
D. Management Console navigation
By which application you do Analyze the end-to-end impact and lineage for source and target objects used within the Data Services local repository?
A. Administrator
B. Impact and Lineage Analysis
C. Operational Dashboard
D. Data Validation Dashboard
E. Auto Documentation
F. Data Quality Reports
By which application you do View and export reports for batch and realtime jobs, such as job summaries and data quality transform reports?
A. Administrator
B. Impact and Lineage Analysis
C. Operational Dashboard
D. Data Validation Dashboard
E. Auto Documentation
F. Data Quality Reports
Where does An administrator sets user permissions?
A. Central Management Server (CMS)
B. Management Console
C. Data Services Management Console
D. Management Console navigation
Contains the repository name associated with the ________ Server?
A. Batch
B. Real-Time
C. Adapters
D. Profiler
In addition to the main databases for source information, records for orders are stored in flat files. You need to extract data from these flat files, and so must create the appropriate file format for the extraction. Create a file format Orders_Format for an orders flat file so that you can use it as a source object for extraction. (Validate the correct statement).
A. In the Local Objects Library, choose Formats tab.
B. Right click the Flat Files node and choose New.
C. Enter Orders_Format as the format name.
D. Right click your new file format Orders_Format and choose View Data .
You are an ETL developer working on a data warehousing project. You need to load data from the product
table and create a table for North American customers.
How to Create a new project called Omega?
A. In the Project menu, choose New Project.
B. In the Project New dialog box, in the Project name field, enter Omega.
C. Choose Create .The new project appears in the Project area.
D. In the Project area, right-click the project name and, in the context menu, choose New Batch Job.
In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced
with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with
the actual value from the country table.
How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in
the Query transform.
A. In the Mapping tab, choose Functions.
B. In the Select Function dialog box, choose Lookup Functions.
C. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.
D. In the Query Editor, in the output schema, choose the field Country.
E. In the Mapping tab for the Country field, delete the existing expression.
What are task's of data Services uses the SAP RFC Server Interface?
A. Scheduling SAP jobs
B. Reading from SAP Open Hub destinations
C. Loading SAP NetWeaver BW
D. Viewing Data Services logs from SAP NetWeaver BW
E. None of above
You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data Services?
A. Specify the DEPARTMENT column on the GROUP BY tab.
B. Enter avg(SALARY) on the Mapping tab.
C. Enter avg(SALARY) on the SELECT tab.
D. Specify the DEPARTMENT code on the WHERE tab.