c_ds_42 One

Which of the following statements about work flows are true? A work flow (2 Correct Answers). Transforms source data into target data. Incorporates several data flows into a sequence. Makes jobs more adaptable to additional development and/or specification changes. Is not an object like a project, a job, a transform or a script.

Which of the following statements are true? (3 Correct Answers). A datastore provides a connection or multiple connections to data sources. Data Services uses the datastore to import metadata that describes the data in the data source. Data Services uses the datastore to read data from the source. Data Services cannot use the datastore to write data to a target. Datastore options are the same across all Relational Database Management Systems.

When do you use a file format to connect to source or target data?.

When do you use a file format to connect to source or target data?. Use a file format to connect to source or target data, when the data is stored in a file rather than a database table. Use RDBMS. use SQL Query transform.

A job is the highest level of organization offered by SAP Data Services. True. False.

A job is a schedulable object. True. False.

When you connect objects in the workspace area you cannot disconnect them again. True. False.

Describe the function of these tabs in the Parameters area of the Query Transform Editor. Mapping. Outer Join. Group By.

When a repository object is imported and exported, the description is also imported or exported. True. False.

How do you add an annotation to the workspace? Arrange these steps into the correct sequence. In the workspace, from the tool palette , select the Annotation icon and then select the workspace. Double-click the annotation. Add text to the annotation. Select the cursor outside of the annotation to commit the changes.

Select the correct statements about job validation (2 Correct Answers). You cannot validate objects while you are creating the job. You cannot validate jobs automatically before execution. Trace log files show error messages associated with the job server. Trace settings can be changed temporarily.

Match the trace options with their descriptions. SQL transforms. SQL readers. SQL loaders.

View data allows you to import table and file data from the Local Object Library. True. False.

It is possible to have multiple View data windows open at any time. True. False.

The interactive debugger places filters and breakpoints on lines in a data flow diagram. True. False.

What is an audit point. An audit point represents the object in a data flow where statistics are collected. An audit point represents the object in a data flow where records can be displayed. Its a filter. It can be used for Transform query.

All functions can be called from custom functions or scripts. True. False.

Lookup_ext has more functionality than lookup. True. False.

What is a variable. A variable is a common component in scripts that acts as a placeholder to represent values with the potential to change each time a job is executed. A variable is a global parameter defined in script. A variable is same as parameter local. None.

What is a script. A script is a single-use object that is used to call functions and assign values in a work flow. A script is a Multi-use object that is used to call functions and assign values in a work flow. None. A script is used in DataFlow.

Which one of these statements about transforms is true(1 Correct Answers). Transforms are necessary objects in a data flow. The Query transform is the most commonly used transform. Transforms operate on single values, such as values in specific columns of a dataset. It is not possible to use transforms in combination to create an output data set.

What does the Map Operation transform enable you to do. The Map Operation transform enables you to change the operation code for records. The Map Operation transform can use History Preservation. None. ???.

You can use mapping expressions on top-level schemas only. True. False.

Match the Validation transform rules with their descriptions. Enable validation. Do not validate when NULL. Condition.

The Merge transform combines incoming data sets with the same schema structure to produce a single output data set with the same schema as the input data sets. True. False.

Which of these statements about Case transforms are correct(2 Correct Answers). The Case transform supports separating data from a source into multiple targets based on branch logic. The Case transform allows for the dividing of a data set into smaller sets based on logical branches. Multiple data flow sources are allowed as a data input for the Case transform. The connections between the Case transform and objects used for a particular case are not labeled.

When would you use the SQL transform instead of the Merge transform. Use the SQL transform as a replacement for the Merge transform when dealing with database tables. The SQL transform performs more efficiently because the merge is pushed down to the database. This functionality cannot be used when source objects include file formats. To use Push-down Operations. To use Sql transform. None.

Identify the correct data recovery strategy for the data you want to recover. Recover your entire database. Recover a partially loaded job. Recover missing values or rows.

There are three ways to manage slowly changing dimensions. Match the SCD type with the correct description. Arrange these steps into the correct sequence. No history preservation. Unlimited history preservation. Limited history preservation.

Which description corresponds with these Data Integrator transforms. Data Transfer. Map CDC Operation. Reverse Pivot.

The Pivot transform creates a new row for each value in a column that you identify as a pivot column. True. False.

The Reverse Pivot transform reverses converts rows into columns. True. False.

You can only specify one pivot column to be rotated into a row. True. False.

Which one of these statements about push-down operations is true. Full push-down operations are possible when the source and target tables are from different datastores. Data Services performs a partial push-down with a SELECT statement to the source database. Data Services can push all transform operations to the database. You can push built–in functions and transforms to the source database.

Name two ways you can improve the performance of data transformations. Data caching and process slicing. Using Select queries with defined objective. Limiting use of Look_up operations. None.

Which tool enables developers to define data management applications. Central Management Console. Data Services Designer. Repository Manager. Job Server.

Which two repository types can be associated with a job server(2 Correct Answers). Central repository. Database repository. Cloud repository. Local repository.

Which of the following statements are true. SAP Data Services is self-sufficient and does not need a supporting platform. The Information Steward can be installed at the same time as SAP Data Services. Both the SAP BusinessObjects BI Platform and the Information Platform Services are required for SAP Data Services. Either the Information Platform Services or the SAP BusinessObjects BI Platform must be installed in order to use SAP Data Services.

What types of installation methods are available (2 Correct Answers). Automatic. Silent. Quiet. Non-interactive. Interactive.

The 64-bit Designer and job server can coexist with all Microsoft Office products. True. False.

Which database server is bundled with the IPS installation. Oracle. SAP HANA. Microsoft SQL Server. SAP Sybase SQL Anywhere. SAP Sybase Adaptive Server Enterprise.

Which of the following statements about jobs is true. Can control user rights. Can be executed manually. Can be created using the CMC. Can be stored in the job server.

Which of the following statements about immediate jobs is true. Can run during the development cycle. Initiates outside of the software. Needs to have only the Designer running. Continuously listens for requests.

What is the purpose of an embedded data flow(2 Correct Answers). Simplify data flow display. Reuse data flow logic inside another data flow. Improve performance. Enable push-down operations.

Which of the following statements is true of a data flow. It must be executed from a repository. It is a function that can run as a separate process. It can take advantage of additional memory. It runs the entire job on a single job server.

To which of the following formats can the Auto Documentation feature be output(2 Correct Answers). PDF. Microsoft Word. Text. Microsoft Excel.

Which of the following can be used to schedule jobs. Batch file. Designer. Server Manager. Workbench.

Which of the following are default security groups(2 Correct Answers). Data Services Execute Users. Data Services Operator Users. Data Services Modify Users. Data Services Profile Users.

Which of the following are all Data Services groups granted rights to(2 Correct Answers). Administration overview. Access to Administrator. Access to Designer. View batch job history.

Which flat file types can you use to export objects to another repository(2 Correct Answers). BIAR. ATL. XML. DSF.

Where can the Object History be found. In the Central Object Library in Designer. Using the CMC under Folders then selecting the object. In the Data Services Workbench using the Wizard. Using the Data Services Repository Manager viewing the repository.

What are the two methods for object migration(2 Correct Answers). File export/import. Upgrade Management Tool. Import Wizard. Central repositories.

Which of the following offers performance improvements(2 Correct Answers). Join rank. Information Steward. Central repository. Bulk loading.

A persistent cache can only cache data from database tables. True. False.

Why use push down operations. To influence the number of operations to the database. To enable a job to be scheduled in the CMC. To allow users and groups to access your job in the Designer. To enhance the use of create and drop tables in the data source.