Cantajuegos

Question 1 of 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)

Select one or more of the following:

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

Explanation

Question 2 of 80

1

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

Select one or more of the following:

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

Explanation

Question 3 of 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)

Select one or more of the following:

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

Explanation

Question 4 of 80

1

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

Select one or more of the following:

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

Explanation

Question 5 of 80

1

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

Select one or more of the following:

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

Explanation

Question 6 of 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)

Select one or more of the following:

Null
Q1
1
An error

Explanation

Question 7 of 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)

Select one or more of the following:

SELECT
GROUP BY
ORDER BY
MAPPING

Explanation

Question 8 of 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)

Select one or more of the following:

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

Explanation

Question 9 of 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)

Select one or more of the following:

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

Explanation

Question 10 of 80

1

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

Select one or more of the following:

Transaction order
Auto correct load
Rows per commit
Use overflow file

Explanation

Question 11 of 80

1

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

Select one or more of the following:

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

Explanation

Question 12 of 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)

Select one or more of the following:

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

Explanation

Question 13 of 80

1

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

Select one or more of the following:

Literal
Match_pattern
Word_ext
Decode

Explanation

Question 14 of 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)

Select one or more of the following:

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

Explanation

Question 15 of 80

1

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

Select one or more of the following:

Effective Date
SQL
Row Generation
Hierarchy Flattening

Explanation

Question 16 of 80

1

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

Select one or more of the following:

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

Explanation

Question 17 of 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)

Select one or more of the following:

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

Explanation

Question 18 of 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)

Select one or more of the following:

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

Explanation

Question 19 of 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)

Select one or more of the following:

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

Explanation

Question 20 of 80

1

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

Select one or more of the following:

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

Explanation

Question 21 of 80

1

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

Select one or more of the following:

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

Explanation

Question 22 of 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)

Select one or more of the following:

Validation transform
Map_Operation transform
Merge transform
Case transform

Explanation

Question 23 of 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)

Select one or more of the following:

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

Explanation

Question 24 of 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)

Select one or more of the following:

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

Explanation

Question 25 of 80

1

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

Select one or more of the following:

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

Explanation

Question 26 of 80

1

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

Select one or more of the following:

-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

Explanation

Question 27 of 80

1

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

Select one or more of the following:

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

Explanation

Question 28 of 80

1

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

Select one or more of the following:

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

Explanation

Question 29 of 80

1

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

Select one or more of the following:

Substitution parameters
Global variables
Job server used
Datastore configurations

Explanation

Question 30 of 80

1

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

Select one or more of the following:

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

Explanation

Question 31 of 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)

Select one or more of the following:

Country_ID
Pivot
Case
Map_Operation

Explanation

Question 32 of 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)

Select one or more of the following:

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

Explanation

Question 33 of 80

1

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

Select one or more of the following:

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 [ ]

Explanation

Question 34 of 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)

Select one or more of the following:

Word_ext
Ltrim
Search_Replace
Match_pattern

Explanation

Question 35 of 80

1

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

Select one or more of the following:

Query transform
Merge transform
Map CDC transform
Conditionals
Scripts

Explanation

Question 36 of 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)

Select one or more of the following:

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

Explanation

Question 37 of 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)

Select one or more of the following:

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

Explanation

Question 38 of 80

1

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

Select one or more of the following:

XML file
Open hub
File format
Tables

Explanation

Question 39 of 80

1

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

Select one or more of the following:

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

Explanation

Question 40 of 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)

Select one or more of the following:

-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

Explanation

Question 41 of 80

1

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

Select one or more of the following:

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

Explanation

Question 42 of 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)

Select one or more of the following:

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

Explanation

Question 43 of 80

1

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

Select one or more of the following:

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

Explanation

Question 44 of 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)

Select one or more of the following:

-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

Explanation

Question 45 of 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)

Select one or more of the following:

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

Explanation

Question 46 of 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)

Select one or more of the following:

-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

Explanation

Question 47 of 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)

Select one or more of the following:

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

Explanation

Question 48 of 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)

Select one or more of the following:

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

Explanation

Question 49 of 80

1

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

Select one or more of the following:

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

Explanation

Question 50 of 80

1

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

Select one or more of the following:

Local repository
Job server
Designer
Central repository

Explanation

Question 51 of 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)

Select one or more of the following:

-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

Explanation

Question 52 of 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)

Select one or more of the following:

-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

Explanation

Question 53 of 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)

Select one or more of the following:

-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

Explanation

Question 54 of 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)

Select one or more of the following:

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

Explanation

Question 55 of 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)

Select one or more of the following:

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

Explanation

Question 56 of 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)

Select one or more of the following:

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

Explanation

Question 57 of 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)

Select one or more of the following:

Embedded dataflow
Sub-dataflow
Job
Workflow
Dataflow

Explanation

Question 58 of 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)

Select one or more of the following:

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

Explanation

Question 59 of 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)

Select one or more of the following:

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

Explanation

Question 60 of 80

1

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

Select one or more of the following:

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

Explanation

Question 61 of 80

1

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

Select one or more of the following:

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

Explanation

Question 62 of 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)

Select one or more of the following:

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

Explanation

Question 63 of 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)

Select one or more of the following:

-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

Explanation

Question 64 of 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)

Select one or more of the following:

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

Explanation

Question 65 of 80

1

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

Select one or more of the following:

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

Explanation

Question 66 of 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)

Select one or more of the following:

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

Explanation

Question 67 of 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)

Select one or more of the following:

-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

Explanation

Question 68 of 80

1

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

Select one or more of the following:

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

Explanation

Question 69 of 80

1

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

Select one or more of the following:

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

Explanation

Question 70 of 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)

Select one or more of the following:

-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

Explanation

Question 71 of 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)

Select one or more of the following:

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

Explanation

Question 72 of 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)

Select one or more of the following:

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

Explanation

Question 73 of 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)

Select one or more of the following:

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

Explanation

Question 74 of 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)

Select one or more of the following:

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

Explanation

Question 75 of 80

1

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

Select one or more of the following:

Data_Transfer
History_Preserving
Map_CDC_Operation
Key_Generation
Table_Comparison

Explanation

Question 76 of 80

1

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

Select one or more of the following:

History_Preserving
Key_Generation
Map_Operation
Query

Explanation

Question 77 of 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)

Select one or more of the following:

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

Explanation

Question 78 of 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)

Select one or more of the following:

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

Explanation

Question 79 of 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

Select one or more of the following:

Data flow mapping
Business rules
User rules
Data Security

Explanation

Question 80 of 80

1

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

Select one or more of the following:

-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

	Created by Ginés Fernández Flores about 7 years ago

Cantajuegos

Cantajuegos

Question 1 of 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)

Select one or more of the following:

Explanation

Question 2 of 80

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

Select one or more of the following:

Explanation

Question 3 of 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)

Select one or more of the following:

Explanation

Question 4 of 80

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

Select one or more of the following:

Explanation

Question 5 of 80

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

Select one or more of the following:

Explanation

Question 6 of 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)

Select one or more of the following:

Explanation

Question 7 of 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)

Select one or more of the following:

Explanation

Question 8 of 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)

Select one or more of the following:

Explanation

Question 9 of 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)

Select one or more of the following:

Explanation

Question 10 of 80

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

Select one or more of the following:

Explanation

Question 11 of 80

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

Select one or more of the following:

Explanation

Question 12 of 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)

Select one or more of the following:

Explanation

Question 13 of 80

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

Select one or more of the following:

Explanation

Question 14 of 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)

Select one or more of the following:

Explanation

Question 15 of 80

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

Select one or more of the following:

Explanation

Question 16 of 80

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

Select one or more of the following:

Explanation

Question 17 of 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)

Select one or more of the following:

Explanation

Question 18 of 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)

Select one or more of the following:

Explanation

Question 19 of 80

Select one or more of the following:

Explanation

Question 20 of 80

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

Select one or more of the following:

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)