Cantajuegos

Pregunta 1 de 80

1

1 de 80
Basic Data Transformation
From the account table you want to know how many accounts you have per account type, hence you output the ACCOUNT_TYPE, which is used in the GROUP BY tab as well, and an additional COUNTER column
Which mapping would you use for the COUNTER column? (1)

Selecciona una o más de las siguientes respuestas posibles:

Count(*)
Count_Distinct(ACCOUNT_TYPE)
Total_rows()
Gen_Row_Num_By_Group(ACCOUNT_TYPE)

Explicación

Pregunta 2 de 80

1

7 de 80
Basic Data Transformation
Which join types are supported in the Query Editor? (3)

Selecciona una o más de las siguientes respuestas posibles:

Right outer join
Cross-product join
Full outer join
Left outer join
Inner join

Explicación

Pregunta 3 de 80

1

13 de 80 ok
Basic Data Transformation
You executed a job in a development environment and it raised primary key violation errors.
Which option do you use to find which primary key values caused the errors? (1)

Selecciona una o más de las siguientes respuestas posibles:

Auto correct load
Delete data before loading
Overflow file
Drop and re-create

Explicación

Pregunta 4 de 80

1

14 de 80 ok
Basic Data Transformation
Which of the following can be performed in the Query Transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

Separate data into distinct output sets
Join data from multiple sources
Assign a value to a global variable
Change column datatypes
Change the primary key flag of columns

Explicación

Pregunta 5 de 80

1

20 de 80 (D)
Basic Data Transformation
Which objects can you use to define an output schema in a Query transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

File formats
Columns
XML schemas
Nested schemas
Lookup_ext as new function calls

Explicación

Pregunta 6 de 80

1

35 de 80
Basic Data Transformation
What is the expected result of the expression quarter(to_date(‘Feb 22, 2013’,’mon dd, yyyy’))? (1)

Selecciona una o más de las siguientes respuestas posibles:

Null
Q1
1
An error

Explicación

Pregunta 7 de 80

1

39 de 80
Basic Data Transformation
In the source-target mapping document, a Target column is specified to contain a concatenation of a First Name column with a Last Name column from the source table.
Where in the Query Editor can you accomplish this task? (1)

Selecciona una o más de las siguientes respuestas posibles:

SELECT
GROUP BY
ORDER BY
MAPPING

Explicación

Pregunta 8 de 80

1

48 de 80
Basic Data Transformation
You have just added a new template table to a data flow. You validate and save the data flow and its parent job.
What happens during the save? (1)

Selecciona una o más de las siguientes respuestas posibles:

The metadata for the template table is added to the local repository
The job server verifies the existence of the template table
The job server attempts to (re)create the table
The designer attempts to (re)create the table

Explicación

Pregunta 9 de 80

1

54 de 80 (D)
Basic Data Transformation
You are part of a development team on a data integration project and have been instructed to use the error_number() function to identify errors while running the job.
Where do you place the error_number() function? (1)

Selecciona una o más de las siguientes respuestas posibles:

Validation transform
Script at job level
Query transform
Script inside a catch

Explicación

Pregunta 10 de 80

1

59 de 80
Basic Data Transformation
Which options are available when using the Include in Transaction target table option? (2)

Selecciona una o más de las siguientes respuestas posibles:

Transaction order
Auto correct load
Rows per commit
Use overflow file

Explicación

Pregunta 11 de 80

1

61 de 80
Basic Data Transformation
In which cases do you recommend using embedded data flows? (2)

Selecciona una o más de las siguientes respuestas posibles:

To optimize the performance of the data flow
To make the layout more readable by grouping sections of the data flow
To reuse the extraction logic of the existing data flow in another data flow
To run data flows in parallel inside the parent data flow

Explicación

Pregunta 12 de 80

1

76 de 80
Basic Data Transformation
You have multiple output schemas in a Query transform. All columns in the schema you want to edit are greyed-out.
Which action do you perform in order to change the mapping of a column inside this schema? (3)

Selecciona una o más de las siguientes respuestas posibles:

Double-click the column in the output schema area
Select the schema from the Output list
Right-click the parent schema and select the Nest with Sub-Schemas option
Right-click the schema, column or function and select Make Current
Right-click the parent schema and select the Unnest with Sub-Schemas option

Explicación

Pregunta 13 de 80

1

79 de 80
Basic Data Transformation
Which function will deliver the same results as nested IFTHENELSE functions? (1)

Selecciona una o más de las siguientes respuestas posibles:

Literal
Match_pattern
Word_ext
Decode

Explicación

Pregunta 14 de 80

1

6 de 80
Advanced Data Transformation
Your source table has a revenue column and a quantity column for each month (so 12 columns for revenue and 12 columns for quantity). You want to pivot the data to get 12 rows with 2 columns.
What is the best way to achieve this? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use a Query transform with multiple IFTHENELSE() functions
Use the Pivot transform with two pivot sets
Use 12 Query transforms to create the desired output, which you the merge
Use the Pivot transform with one pivot set

Explicación

Pregunta 15 de 80

1

12 de 80
Advanced Data Transformation
Which transforms can be used as a source in a dataflow? (2)

Selecciona una o más de las siguientes respuestas posibles:

Effective Date
SQL
Row Generation
Hierarchy Flattening

Explicación

Pregunta 16 de 80

1

29 de 80
Advanced Data Transformation
What benefits does the Validation transform give you? (3)

Selecciona una o más de las siguientes respuestas posibles:

You can see all violated rules at once
You can call a recovery dataflow
You can have multiple rules on a single column
You can produce statistics
You can interrupt the dataflow once a certain number of violations occur

Explicación

Pregunta 17 de 80

1

31 de 80
Advanced Data Transformation
You have a Map Operation transform immediately before the target in a data flow.
What happens if all operation codes are mapped to Discard in the transform? (1)

Selecciona una o más de las siguientes respuestas posibles:

They are flagged for later deletion
They are deleted from the target
They are added to the overflow file
They are filtered by the transform

Explicación

Pregunta 18 de 80

1

38 de 80
Advanced Data Transformation
In a Slowly Changing Dimension Type 2 dataflow, all INSERT and UPDATE rows are passed through the Key_Generation transform.
What does the Key_Generation transform do with UPDATE rows? (1)

Selecciona una o más de las siguientes respuestas posibles:

It retains the current data
It only creates a new key value when the input value is NULL
It increases the key value by 1
It always creates a new key value

Explicación

Pregunta 19 de 80

1

43 de 80
Advanced Data Transformation
You have used the Table Comparison transform to establish the differences between two tables. In the subsequent History Preserving transform, all columns are listed as compare columns (neither the Valid from/to nor Current flag is used).
What will the History Preserving transform do with new rows or if any of the columns have been changed? (2)

Selecciona una o más de las siguientes respuestas posibles:

It will keep an INSERT as an INSERT
It will change an UPDATE to an INSERT
It will output an UPDATE as two rows with INSERT and UPDATE
It will keep an UPDATE as an UPDATE

Explicación

Pregunta 20 de 80

1

52 de 80
Advanced Data Transformation
What are the source schema requirements when using the Hierarchy Flattening transform? (1)

Selecciona una o más de las siguientes respuestas posibles:

Each row contains columns that function as the keys in a parent-child relationship
Rows with NULL values in the child column have been removed or updated
Rows with NULL values in the parent column have been removed or updated
Each row has an operation code of either UPDATE or INSERT

Explicación

Pregunta 21 de 80

1

60 de 80
Advanced Data Transformation
In which cases do you use the Text_Data_Processing transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

To cleanse material master descriptions
To analyze relationships in a sentence
To spellcheck free-form text
To extract keywords from a free-form text
To evaluate the sentiment (for example, strong positive or weak negative) of a free-form text

Explicación

Pregunta 22 de 80

1

67 de 80
Advanced Data Transformation
Your source vendor data needs to be loaded to one of three target tables, depending on the country code.
Which transform do you use to achieve this? (1)

Selecciona una o más de las siguientes respuestas posibles:

Validation transform
Map_Operation transform
Merge transform
Case transform

Explicación

Pregunta 23 de 80

1

70 de 80
Advanced Data Transformation
You have a Validation transform with two rules.
Rule #1: Action on Failure is “Send to Pass”
Rule #2: Action on Failure is “Send to Fail”
Where are the records that fail both Rule #1 and Rule #2 sent? (1)

Selecciona una o más de las siguientes respuestas posibles:

To both the Pass and Fail output
Only to the Fail output
Only to the Pass output
Only to the Rule Violation output

Explicación

Pregunta 24 de 80

1

73 de 80
Advanced Data Transformation
Why would you use a validation function instead of the Column Validation option in the Validation transform? (2)

Selecciona una o más de las siguientes respuestas posibles:

To write custom messages to DI_ERRORCOLUMMS in the fail output schema
To capture validation statistics for later reporting purposes
To use a function that was created in SAP Information Steward
To allow the validation rule to be used in multiple data flows

Explicación

Pregunta 25 de 80

1

75 de 80
Advanced Data Transformation
Why would you use the Map_CDC_Operation transform? (1)

Selecciona una o más de las siguientes respuestas posibles:

To identify changed rows in a relational database
To split insert, update and delete flagged rows into three output streams
To consume a source that contains the information if a record was inserted, updated or deleted
To further process rows that have been identified as changes by the Table_Comparison transform

Explicación

Pregunta 26 de 80

1

78 de 80
Advanced Data Transformation
When would you check the Produce default output option in the Case transform? (1)

Selecciona una o más de las siguientes respuestas posibles:

-To output all incoming rows by this default path but the flag Row can be true for one case only has to be turned off
-To output all incoming rows by this default path
-To output rows that do not match one condition
-To output all rows that do not match any case expression by this default path

Explicación

Pregunta 27 de 80

1

2 de 80
Data Integration Concepts
In which situation do you use the Data Services interactive debugger? (1)

Selecciona una o más de las siguientes respuestas posibles:

You need to debug a script object
You need to view the data output from the dataflow
You need to establish why a small group of records is wrong
You need to resolve syntax validation errors in a dataflow

Explicación

Pregunta 28 de 80

1

3 de 80
Data Integration Concepts
Why would you use additional effort to build a job that can be restarted automatically? (2)

Selecciona una o más de las siguientes respuestas posibles:

It shows time consuming jobs to be restarted mid process
It reduces the daily manual work for the operator when errors occur
It enables debugging
It improves the job’s performance

Explicación

Pregunta 29 de 80

1

15 de 80
Data Integration Concepts
What can you control with Data Services system configurations? (2)

Selecciona una o más de las siguientes respuestas posibles:

Substitution parameters
Global variables
Job server used
Datastore configurations

Explicación

Pregunta 30 de 80

1

17 de 80
Data Integration Concepts
What benefits does the central repository bring to a development environment? (2)

Selecciona una o más de las siguientes respuestas posibles:

It removes the need for developers to have their own repository
It supports multiple versions of Data Services
It can control which objects developers are allowed to edit
It retains a history of objects checked in

Explicación

Pregunta 31 de 80

1

30 de 80
Data Integration Concepts
A job you are designing requires you to extract source data that contains sales revenue facts for different regions, and separate the records for the regions into distinct output tables.
Which transform will allow you to accomplish this task? (1)

Selecciona una o más de las siguientes respuestas posibles:

Country_ID
Pivot
Case
Map_Operation

Explicación

Pregunta 32 de 80

1

33 de 80
Data Integration Concepts
You are part of a development team that is extracting data from external systems using flat files. You must combine all incoming address data sets and produce a single output data set using the Merge transform.
Which conditions must be met to successfully run the Merge transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

All nested schemas from the input sets must be consistent
All sources have the same column names
All sources must have the same column data types
All hierarchical data must have matching names and data types at the highest level only
All duplicates have been removed from source files

Explicación

Pregunta 33 de 80

1

37 de 80
Data Integration Concepts
When using Data Services scripting language, which syntax must be followed when creating an expression? (2)

Selecciona una o más de las siguientes respuestas posibles:

Each statement ends in a semicolon (;)
Variable names start with a dollar sign ($)
Values of an expression are qualified by parentheses ()
Functions call parameters within square brackets [ ]

Explicación

Pregunta 34 de 80

1

46 de 80
Data Integration Concepts
When analyzing your customer’s data, you discover a data entry error in the source system. The contact title “Director” has been entered as “Vice President”.
Which function should be used to correct these entries? (1)

Selecciona una o más de las siguientes respuestas posibles:

Word_ext
Ltrim
Search_Replace
Match_pattern

Explicación

Pregunta 35 de 80

1

57 de 80
Data Integration Concepts
In which of the following objects can built-in functions be used? (3)

Selecciona una o más de las siguientes respuestas posibles:

Query transform
Merge transform
Map CDC transform
Conditionals
Scripts

Explicación

Pregunta 36 de 80

1

63 de 80
Data Integration Concepts
What are the advantages of using the lookup_ext() function as a new function call compared to using it in a mapping? (2)

Selecciona una o más de las siguientes respuestas posibles:

You can have multiple input conditions
You can get better performance
You can have multiple return columns
You can specify a cache setting

Explicación

Pregunta 37 de 80

1

64 de 80
Data Integration Concepts
You are reading sales order data from a file. The file contains order numbers, but each one can have multiple rows (see screenshot below).
How can you populate an additional column with the order line number identifying each line item per order? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use a gen_row_num_per_group(ORDERNUMBER) function on unsorted data
Use the count_distinct(ORDERNUMBER) function on the data sorted by ORDERNUMBER
Use a gen_row_num_per_group(ORDERNUMBER) function on the data sorted by ORDERNUMBER
Use the count(*) function on unsorted data

Explicación

Pregunta 38 de 80

1

66 de 80
Data Integration Concepts
Which objects can you use to read data from SAP Netweaver Business Warehouse? (2)

Selecciona una o más de las siguientes respuestas posibles:

XML file
Open hub
File format
Tables

Explicación

Pregunta 39 de 80

1

71 de 80
Data Integration Concepts
Which of the following use cases are common for scripts? (2)

Selecciona una o más de las siguientes respuestas posibles:

Conditional routing
Job initialization
Status table checks and updates
Set the system/datastore configurations

Explicación

Pregunta 40 de 80

1

4 de 80
Complex Design Methodology
A new team member wants to browse the content of an existing local repository
How do you allow them to view the repository without making changes? (2)

Selecciona una o más de las siguientes respuestas posibles:

-Copy the repository and instruct the team member to view the copy in the repository manager
-Export the repository’s metadata to an XML file and instruct the team member to open it in SAP Information Steward
-Assign the team member “View” access level to the repository in the Central Management Console and instruct them to view it from the Designer
-Demonstrate to the team member how to view the repository using the Auto Documentation feature in the Management Console

Explicación

Pregunta 41 de 80

1

24 de 80
Complex Design Methodology
What file formats are available when exporting Data Services objects? (2)

Selecciona una o más de las siguientes respuestas posibles:

An XML file
A CSV file
An XSD file
An ATL file

Explicación

Pregunta 42 de 80

1

27 de 80 (D)
Complex Design Methodology
You have two workflows. The second workflow should only run if the first one was successful.
How can you achieve this? (1)

Selecciona una o más de las siguientes respuestas posibles:

You embed the first workflow in a try-catch
You connect the two workflows with a line
You add a script between the workflows using the error_number() function
You use a conditional for the second workflow

Explicación

Pregunta 43 de 80

1

32 de 80
Complex Design Methodology
Which of the following are correct sequences of embedding objects within objects? (3)

Selecciona una o más de las siguientes respuestas posibles:

Job -> Dataflow -> Table Reader Object -> Dataflow
Project -> Job -> Workflow -> Dataflow -> Table Reader Object
Project -> Job -> Workflow -> Workflow -> Dataflow -> Dataflow
Project -> Job -> Script -> Table Reader Object
Project -> Job -> Dataflow -> Table Reader Object

Explicación

Pregunta 44 de 80

1

34 de 80
Complex Design Methodology
You have the requirement to build a process that handles both an initial load and a delta load. For most targets, the initial load and the delta load can use the same dataflow logic.
How does SAP recommend that you design the job(s)? (1)

Selecciona una o más de las siguientes respuestas posibles:

-One job is used for the initial load, and another job is used for delta load. The delta dataflows are copied from the initial load dataflows where necessary
-One job is used for the initial load, and another job is used for delta load. Both call the same objects where required
-One job is used for both initial and delta load. A conditional object is used to start the initial or delta dataflow where necessary
-One job is used for initial load and delta load. You control the dependencies by using scripting

Explicación

Pregunta 45 de 80

1

36 de 80
Complex Design Methodology
You want to display an object’s description in the Designer workspace
What tasks must be performed to accomplish this? (3)

Selecciona una o más de las siguientes respuestas posibles:

Click the View Enabled Descriptions button on the toolbar
Enter a description in the properties of the object
Disable Hide Non-Executable Elements in the difference viewer
Right-click the object, then choose Enable Description
Right-click the object in the local object library, then choose View Where Used

Explicación

Pregunta 46 de 80

1

41 de 80
Complex Design Methodology
You have three workflows:
• Customer
• Salesoffice
• Geography
The Salesoffice and Customer workflows have a dependency that the Geography workflow is loaded first.
How does SAP recommend dealing with the dependency? (1)

Selecciona una o más de las siguientes respuestas posibles:

-Connect the Geography workflow to the Customer workflow and the Salesoffice workflow
-Connect the Geography workflow to the Customer workflow, which in turn is connected to the Salesoffice workflow
-Have the Geography workflow as first object in the Customer workflow and Salesoffice workflow, and set them all to Execute only once
-Have two jobs: The first one calls the Geography and the second one calls the other workflows

Explicación

Pregunta 47 de 80

1

45 de 80
Complex Design Methodology
The design of a complex job requires that a dataflow occur in multiple workflows. This dataflow should run –at most- one time in a single execution of the job.
What would you do to prevent the dataflow from running multiple times? (1)

Selecciona una o más de las siguientes respuestas posibles:

Set the Number of Loaders on the target in the data flow to 1
Enable the Execute Only Once option in the dataflow properties
Set the Degree of Parallelism on the data flow to 1
Enable the Execute Only Once option in the properties of each of the workflows

Explicación

Pregunta 48 de 80

1

53 de 80
Complex Design Methodology
Your business user has given you the following source-to-target mapping document.
What issues do you need to clarify with the business user? (1)

Selecciona una o más de las siguientes respuestas posibles:

The data type in the price column in the target should be changed to decimal(4,2)
The to_date function will be used for the transformation of the ORDER_DATE column
The transformation of the B_CODE column will be performed using regular expressions
The N_DAT column will have some values truncated in the target table

Explicación

Pregunta 49 de 80

1

56 de 80
Complex Design Methodology
How does a workflow differ from a job? (1)

Selecciona una o más de las siguientes respuestas posibles:

A workflow can only call embedded dataflows
In recovery mode, only workflows with “recover as a unit” enabled will be executed
A workflow has its own global variables
A workflow must be called by a job in order to execute

Explicación

Pregunta 50 de 80

1

74 de 80
Complex Design Methodology
Which of the following components are required to run batch jobs in Data Services? (2)

Selecciona una o más de las siguientes respuestas posibles:

Local repository
Job server
Designer
Central repository

Explicación

Pregunta 51 de 80

1

5 de 80
Performance Optimized Design
You need to initial load a target table with data from an extremely large source table in another database. The only mappings are columns being renamed. The source has been set up to allow for maximum throughput, for example, the source table is partitioned.
Which option should you check before the first execution of the dataflow? (3)

Selecciona una o más de las siguientes respuestas posibles:

-Check if the Degree Of Parallelism property of the dataflow object is set to the same number of CPU cores as the DataServices server
-Check the Degree Of Parallelism property of the dataflow object and set it to the same number as the number of partitions in the source table
-Check that the target table options Enable Partitions, Number of Loaders and Enable Bulkloader are aligned to the database you are using
-In the source table options, check if the Enable Partitions flag is available and turned on
-Check if the bulkloader is turned on, although the number of Loaders and Enable Partitions options are greyed out

Explicación

Pregunta 52 de 80

1

10 de 80 (D)
Performance Optimized Design
A dataflow contains a Pivot transform, which is followed by a Query transform that performs an aggregation.
How do you push down the aggregation query to the database? (1)

Selecciona una o más de las siguientes respuestas posibles:

-The Data_Transfer transform must be used twice, ahead of the Pivot transform and after the Query transform
-The Data_Transfer transform must go ahead of the Query transform
-The Data_Transfer transform must follow the Query transform
-The Data_Transfer transform must go ahead of the Pivot transform

Explicación

Pregunta 53 de 80

1

16 de 80 (D)
Performance Optimized Design
Your dataflow reads a subset of data (where ORDER_TYPE=’A’) from a relational source database and loads another target database. The only mappings you are using are columns being renamed and the functions trim_blanks() and substring().
To isolate the performance bottleneck, what test would you perform first? (1)

Selecciona una o más de las siguientes respuestas posibles:

-Add a Map_Operation discarding all rows between the query and the target table
-Add a Map_Operation discarding all rows between the source table and the query transform with the where clause and the functions
-Remove the functions trim_blanks() and substring() from the query mappings
-Use the Display Optimized SQL menu item and copy the shown SQL statement into a database query tool

Explicación

Pregunta 54 de 80

1

18 de 80
Performance Optimized Design
You have a source table and lookup table in the same database.
Which is the fastest method to retrieve a lookup value from a table based on a primary key? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use the sql() function in the query mapping
Push down the lookup as a join into the source database
In the database, write a stored procedure to return the row
Use the lookup_ext function with pre_load_cache

Explicación

Pregunta 55 de 80

1

21 de 80
Performance Optimized Design
Your customer is using the lookup function and needs to improve performance.
Under what conditions should they use the Demand Load Cache option? (3)

Selecciona una o más de las siguientes respuestas posibles:

All rows of the lookup table will eventually be needed
Lookup rows are used more than once
Columns referenced in the lookup condition are indexed
Optimization statistics have been collected for the job
The lookup table is too large to fit in cache

Explicación

Pregunta 56 de 80

1

23 de 80
Performance Optimized Design
After modifying an existing job, you notice that the run time is longer than expected.
Where in the Management Console can you observe the progress of row counts to determine the location of a bottleneck? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use the Administrator web page to access the Trace log
Use the Impact and Lineage Analysis option to access the Trace log
Use the Administrator web page to access the Monitor log
Use the Impact and Lineage Analysis option to access the Monitor log

Explicación

Pregunta 57 de 80

1

44 de 80
Performance Optimized Design
To improve load balancing, you decide to distribute the execution of a job across multiple job servers within a server group.
What objects can be distributed across the server group? (3)

Selecciona una o más de las siguientes respuestas posibles:

Embedded dataflow
Sub-dataflow
Job
Workflow
Dataflow

Explicación

Pregunta 58 de 80

1

55 de 80
Performance Optimized Design
You are working on a dataflow where performance is critical. You use the Display Optimized SQL menu item and expected to see an insert…select statement, but the dataflow is not optimized as full pushdown.
What could have caused this? (3)

Selecciona una o más de las siguientes respuestas posibles:

The dataflow produces a warning saying “varchar(20) converted to varchar(5)”
The dataflow has two query transforms, although they are simple
The dataflow has two target tables
The dataflow has the Bulkloader option enabled
The dataflow is using a join clause containing a greater than condition

Explicación

Pregunta 59 de 80

1

62 de 80 (D)
Performance Optimized Design
After a batch job executes, you view the Monitor log for execution statistics. For one of the tasks, you observe that the Elapsed Time column is 0.0000 (zero), while Actual Time for the task is greater than zero.
What might explain this outcome? (1)

Selecciona una o más de las siguientes respuestas posibles:

The task was performed on the access server
The task was pushed down to the database server
An exception was raised in the job prior to the task
The task was performed using data cached in job server memory

Explicación

Pregunta 60 de 80

1

65 de 80
Performance Optimized Design
Which transforms execute SQL statements themselves? (2)

Selecciona una o más de las siguientes respuestas posibles:

Map CDC Operation transform
Key Generation transform
History Preserving transform
Table Comparison transform

Explicación

Pregunta 61 de 80

1

80 de 80
Performance Optimized Design
Which factor do you need to consider when setting the degree of parallelism? (1)

Selecciona una o más de las siguientes respuestas posibles:

The number of access servers available
The number of CPUs available on the server
The number of source tables used in the dataflow
The amount of disk space available on the server

Explicación

Pregunta 62 de 80

1

19 de 80 (D)
Recovery and Troubleshooting
You have built a job using many workflows and dataflows.
What is the SAP-recommended way to execute a single workflow for testing? (1)

Selecciona una o más de las siguientes respuestas posibles:

Copy and paste each of the objects within the workflow into a test job
Execute the job in debug mode and skip the other objects
Use conditionals for each workflow and a complex control logic
Drag the workflow object from the object library into a test job

Explicación

Pregunta 63 de 80

1

25 de 80
Recovery and Troubleshooting
You created a job containing a number of workflows. You want to implement a solution that allows you to restart loading the job from a point of failure.
What do you need to do before starting the job? (1)

Selecciona una o más de las siguientes respuestas posibles:

-Turn on the Enable Recovery flag in the execution properties
-Turn on the Recover as a Unit flag in the workflow properties
-Turn on the Recover from Last Failed Execution flag in the execution properties
-Turn on the Enable Recovery flag and the Recover from Last Failed Execution flag in the execution properties

Explicación

Pregunta 64 de 80

1

42 de 80 (D)
Recovery and Troubleshooting
You execute a job with Enable Recovery activated and one of the data flows in the job raises an exception, interrupting execution. You run the job again with Recover from Last Failed Execution enabled.

What happens to the data flow that raised the exception during the first execution? (1)

Selecciona una o más de las siguientes respuestas posibles:

It is rerun only if the dataflow is part of a recovery unit
It is rerun from the beginning and the design of the data flow must deal with partially loaded data
It is rerun from the beginning and the partially loaded data is always handled automatically
It is rerun starting with the first failed row

Explicación

Pregunta 65 de 80

1

50 de 80
Recovery and Troubleshooting
Where can you set up breakpoints for the interactive debugger? (1)

Selecciona una o más de las siguientes respuestas posibles:

In a workflow
In a script
In a job
In a dataflow

Explicación

Pregunta 66 de 80

1

51 de 80
Recovery and Troubleshooting
A job is failing with a primary key constraint violation error during testing.
How can you run the job successfully and also capture the rows that are failing? (1)

Selecciona una o más de las siguientes respuestas posibles:

Put the data flow in a try-catch block and use the error_message function
Set the Auto Correct Load option to Yes in the target table editor
Enable the Distinct Rows option in the Query transform
Set the Use Overflow File option to Yes in the target table editor

Explicación

Pregunta 67 de 80

1

68 de 80
Recovery and Troubleshooting
Your job design includes an initialization script that truncates rows in the target prior to loading. The job will make use of automatic recovery.
Which of the following behaviours can you expect when you run the job in recovery mode? (2)

Selecciona una o más de las siguientes respuestas posibles:

-The job will rerun all workflows and scripts. Only data flows that ran successfully in the previous execution in skipped when using automatic recovery
-The job will start with the flow that caused the error. If this is after the initialization script, the initialization script will be skipped
-The job will execute the script if it is part of a workflow marked as a recovery unit, but only if an error was raised within that workflow
-The job will execute the script if it is part of a workflow marked as a recovery unit, no matter where in the job’s flow the error occurred

Explicación

Pregunta 68 de 80

1

72 de 80 (D)
Recovery and Troubleshooting
What is the consequence of using the loader option Include in Transaction? (1)

Selecciona una o más de las siguientes respuestas posibles:

It requires a single database connection and might slow down performance
It requires all data to be staged in a temporary database table
It requires the dataflow to have a single target database
It requires a script object after the dataflow to commit the data

Explicación

Pregunta 69 de 80

1

77 de 80
Recovery and Troubleshooting
Which of the following cause conversion warnings? (2)

Selecciona una o más de las siguientes respuestas posibles:

varchar(10) converted to varchar(5)
int to decimal(20,3)
varchar(5) converted to varchar(10)
to_date(sysdate(),’YYYY.MM.DD’))

Explicación

Pregunta 70 de 80

1

9 de 80
Implement Change Data Capture
You have a delta dataflow that is loading a large target table containing historical data. The table contains many indexed columns. The dataflow uses the Key_Generation transform to populate a surrogate key column in the target table. A typical delta run will update 80% of the target table.
How can you improve the performance of the delta load? (1)

Selecciona una o más de las siguientes respuestas posibles:

-Truncate the target table before loading
-Set the target table option Include in Transaction to Yes
-Replace the Key_Generation transform with a Query transform using the gen_row_num function
-Before loading, drop the indexes except the primary key on the target and recreate the indexes after loading

Explicación

Pregunta 71 de 80

1

11 de 80
Implement Change Data Capture
What are all the available options you have to identify changed rows in the source database with Data Services? (1)

Selecciona una o más de las siguientes respuestas posibles:

-Timestamps
-Read all and compare with the current target
-CDC datastores
-Additional log tables in the source containing changes

Explicación

Pregunta 72 de 80

1

26 de 80 (D)
Implement Change Data Capture
You want to load a target database that is queried day and night by users worldwide.
How do you design your job to have the least impact on users who are currently querying the database? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use the option to truncate the target table and bulkload all data quickly
Use the Table Comparison transform in all dataflows
Use the sql() function to lock all tables at the beginning of the job
Use the Include in Transaction option in all dataflows and commit once at the end of the job

Explicación

Pregunta 73 de 80

1

28 de 80
Implement Change Data Capture
Your target database has a dimension table with 100 columns and 50,000,000 rows. More than half of the records change each day. You are designing a job to capture changes to this table without preserving history.
Which method is the fastest? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use the Delete Data from Table Before Loading option
Use Table Comparison transform
Use Bulk Load with truncate option
Use the Auto-Correct Load option

Explicación

Pregunta 74 de 80

1

40 de 80
Implement Change Data Capture
How can you implement a target-based delta that deals with inserts, updates and deletes in the source? (1)

Selecciona una o más de las siguientes respuestas posibles:

Use Auto correct load
Use a Map_Operation transform
Use a Map_CDC_Operation transform
Use a Table Comparison transform

Explicación

Pregunta 75 de 80

1

47 de 80
Implement Change Data Capture
Which transforms are typically used to implement a Slowly Changing Dimension Type 2? (3)

Selecciona una o más de las siguientes respuestas posibles:

Data_Transfer
History_Preserving
Map_CDC_Operation
Key_Generation
Table_Comparison

Explicación

Pregunta 76 de 80

1

58 de 80
Implement Change Data Capture
Which transforms can be connected directly to the Table Comparison transform’s output? (1)

Selecciona una o más de las siguientes respuestas posibles:

History_Preserving
Key_Generation
Map_Operation
Query

Explicación

Pregunta 77 de 80

1

69 de 80
Implement Change Data Capture
In which situation is it appropriate to use an update timestamp column to capture changes in source data? (1)

Selecciona una o más de las siguientes respuestas posibles:

You need to capture intermediate changes
You need to capture physical deletes from source
Almost all of the rows have changes
There is an index on the timestamp column

Explicación

Pregunta 78 de 80

1

8 de 80
Data Management
You have previously created and saved a database datastore.
Which properties can you change in the Edit Datastore dialog box? (3)

Selecciona una o más de las siguientes respuestas posibles:

Database name
User name and password
Database server name
Datastore name
Database version

Explicación

Pregunta 79 de 80

1

22 de 80
Data Management
As part of the project team for a data migration engagement, you have been assigned to help create the source-to-target mapping document.
What is the main information that needs to be captured during the process? (2)
Data flow mapping

Selecciona una o más de las siguientes respuestas posibles:

Data flow mapping
Business rules
User rules
Data Security

Explicación

Pregunta 80 de 80

1

49 de 80
Data Management
What is the relationship between datastore configurations and system configurations? (1)

Selecciona una o más de las siguientes respuestas posibles:

-A datastore configuration can only reference one system configuration
-System configurations and datastore configurations are exported together as one file
-Substitution parameters link system configurations to datastore configurations
-A system configuration consists of exactly one datastore configuration for each datastore in the repository

	Creado por Ginés Fernández Flores hace alrededor de 7 años

Cantajuegos

Cantajuegos

Cantajuegos

Pregunta 1 de 80

1 de 80 Basic Data Transformation From the account table you want to know how many accounts you have per account type, hence you output the ACCOUNT_TYPE, which is used in the GROUP BY tab as well, and an additional COUNTER column Which mapping would you use for the COUNTER column? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 80

7 de 80 Basic Data Transformation Which join types are supported in the Query Editor? (3)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 80

13 de 80 ok Basic Data Transformation You executed a job in a development environment and it raised primary key violation errors. Which option do you use to find which primary key values caused the errors? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 80

14 de 80 ok Basic Data Transformation Which of the following can be performed in the Query Transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 80

20 de 80 (D) Basic Data Transformation Which objects can you use to define an output schema in a Query transform? (3)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 80

35 de 80 Basic Data Transformation What is the expected result of the expression quarter(to_date(‘Feb 22, 2013’,’mon dd, yyyy’))? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 80

39 de 80 Basic Data Transformation In the source-target mapping document, a Target column is specified to contain a concatenation of a First Name column with a Last Name column from the source table. Where in the Query Editor can you accomplish this task? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 80

48 de 80 Basic Data Transformation You have just added a new template table to a data flow. You validate and save the data flow and its parent job. What happens during the save? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 80

54 de 80 (D) Basic Data Transformation You are part of a development team on a data integration project and have been instructed to use the error_number() function to identify errors while running the job. Where do you place the error_number() function? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 80

59 de 80 Basic Data Transformation Which options are available when using the Include in Transaction target table option? (2)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 80

61 de 80 Basic Data Transformation In which cases do you recommend using embedded data flows? (2)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 80

76 de 80 Basic Data Transformation You have multiple output schemas in a Query transform. All columns in the schema you want to edit are greyed-out. Which action do you perform in order to change the mapping of a column inside this schema? (3)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 80

79 de 80 Basic Data Transformation Which function will deliver the same results as nested IFTHENELSE functions? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 80

6 de 80 Advanced Data Transformation Your source table has a revenue column and a quantity column for each month (so 12 columns for revenue and 12 columns for quantity). You want to pivot the data to get 12 rows with 2 columns. What is the best way to achieve this? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 80

12 de 80 Advanced Data Transformation Which transforms can be used as a source in a dataflow? (2)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 80

29 de 80 Advanced Data Transformation What benefits does the Validation transform give you? (3)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 17 de 80

31 de 80 Advanced Data Transformation You have a Map Operation transform immediately before the target in a data flow. What happens if all operation codes are mapped to Discard in the transform? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 18 de 80

38 de 80 Advanced Data Transformation In a Slowly Changing Dimension Type 2 dataflow, all INSERT and UPDATE rows are passed through the Key_Generation transform. What does the Key_Generation transform do with UPDATE rows? (1)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 19 de 80

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 20 de 80

52 de 80 Advanced Data Transformation What are the source schema requirements when using the Hierarchy Flattening transform? (1)

1 de 80
Basic Data Transformation
From the account table you want to know how many accounts you have per account type, hence you output the ACCOUNT_TYPE, which is used in the GROUP BY tab as well, and an additional COUNTER column
Which mapping would you use for the COUNTER column? (1)

7 de 80
Basic Data Transformation
Which join types are supported in the Query Editor? (3)

13 de 80 ok
Basic Data Transformation
You executed a job in a development environment and it raised primary key violation errors.
Which option do you use to find which primary key values caused the errors? (1)

14 de 80 ok
Basic Data Transformation
Which of the following can be performed in the Query Transform? (3)

20 de 80 (D)
Basic Data Transformation
Which objects can you use to define an output schema in a Query transform? (3)

35 de 80
Basic Data Transformation
What is the expected result of the expression quarter(to_date(‘Feb 22, 2013’,’mon dd, yyyy’))? (1)

39 de 80
Basic Data Transformation
In the source-target mapping document, a Target column is specified to contain a concatenation of a First Name column with a Last Name column from the source table.
Where in the Query Editor can you accomplish this task? (1)

48 de 80
Basic Data Transformation
You have just added a new template table to a data flow. You validate and save the data flow and its parent job.
What happens during the save? (1)

54 de 80 (D)
Basic Data Transformation
You are part of a development team on a data integration project and have been instructed to use the error_number() function to identify errors while running the job.
Where do you place the error_number() function? (1)

59 de 80
Basic Data Transformation
Which options are available when using the Include in Transaction target table option? (2)

61 de 80
Basic Data Transformation
In which cases do you recommend using embedded data flows? (2)

76 de 80
Basic Data Transformation
You have multiple output schemas in a Query transform. All columns in the schema you want to edit are greyed-out.
Which action do you perform in order to change the mapping of a column inside this schema? (3)

79 de 80
Basic Data Transformation
Which function will deliver the same results as nested IFTHENELSE functions? (1)

6 de 80
Advanced Data Transformation
Your source table has a revenue column and a quantity column for each month (so 12 columns for revenue and 12 columns for quantity). You want to pivot the data to get 12 rows with 2 columns.
What is the best way to achieve this? (1)

12 de 80
Advanced Data Transformation
Which transforms can be used as a source in a dataflow? (2)

29 de 80
Advanced Data Transformation
What benefits does the Validation transform give you? (3)

31 de 80
Advanced Data Transformation
You have a Map Operation transform immediately before the target in a data flow.
What happens if all operation codes are mapped to Discard in the transform? (1)

38 de 80
Advanced Data Transformation
In a Slowly Changing Dimension Type 2 dataflow, all INSERT and UPDATE rows are passed through the Key_Generation transform.
What does the Key_Generation transform do with UPDATE rows? (1)

52 de 80
Advanced Data Transformation
What are the source schema requirements when using the Hierarchy Flattening transform? (1)

60 de 80
Advanced Data Transformation
In which cases do you use the Text_Data_Processing transform? (3)

67 de 80
Advanced Data Transformation
Your source vendor data needs to be loaded to one of three target tables, depending on the country code.
Which transform do you use to achieve this? (1)

70 de 80
Advanced Data Transformation
You have a Validation transform with two rules.
Rule #1: Action on Failure is “Send to Pass”
Rule #2: Action on Failure is “Send to Fail”
Where are the records that fail both Rule #1 and Rule #2 sent? (1)

73 de 80
Advanced Data Transformation
Why would you use a validation function instead of the Column Validation option in the Validation transform? (2)

75 de 80
Advanced Data Transformation
Why would you use the Map_CDC_Operation transform? (1)

78 de 80
Advanced Data Transformation
When would you check the Produce default output option in the Case transform? (1)

2 de 80
Data Integration Concepts
In which situation do you use the Data Services interactive debugger? (1)

3 de 80
Data Integration Concepts
Why would you use additional effort to build a job that can be restarted automatically? (2)

15 de 80
Data Integration Concepts
What can you control with Data Services system configurations? (2)

17 de 80
Data Integration Concepts
What benefits does the central repository bring to a development environment? (2)

30 de 80
Data Integration Concepts
A job you are designing requires you to extract source data that contains sales revenue facts for different regions, and separate the records for the regions into distinct output tables.
Which transform will allow you to accomplish this task? (1)

37 de 80
Data Integration Concepts
When using Data Services scripting language, which syntax must be followed when creating an expression? (2)

46 de 80
Data Integration Concepts
When analyzing your customer’s data, you discover a data entry error in the source system. The contact title “Director” has been entered as “Vice President”.
Which function should be used to correct these entries? (1)

57 de 80
Data Integration Concepts
In which of the following objects can built-in functions be used? (3)

63 de 80
Data Integration Concepts
What are the advantages of using the lookup_ext() function as a new function call compared to using it in a mapping? (2)

64 de 80
Data Integration Concepts
You are reading sales order data from a file. The file contains order numbers, but each one can have multiple rows (see screenshot below).
How can you populate an additional column with the order line number identifying each line item per order? (1)