What are performance advantages when using an InfoCube instead of a DataStore Object? There are 2 correct answers.
A. Navigational attributes can be used.
B. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.
C. Surrogate IDs (SIDs) replace master data values in dimension tables.
D. Reporting access to granular data using standard dimensions is faster.
What are the features of using the Operational Data Provisioning (ODP) Infrastructure in BW 7.4? There are 3 correct answers.
A. Extract once and deploy many times.
B. Relies on the proven Delta Queue technology.
C. High compression rate up to 90% of extracted data.
D. Single point of monitoring.
E. Makes complete use of mandatory PSA's.
There is a need to extract millions of records from an Oracle database into BW for analysis. Which of the following represents the best ETL strategy? Select the correct answer.
A. Modify a BI Content DataSource to include the Teradata fields in the extraction.
B. Use the File interface to extract manageable files of no more than 20,000 records each.
C. Use a WebService DataSource to stream the records into the PSA of the DataSource.
D. Use DB Connect for the ETL process.
E. Use UD Connect for the ETL process.
A Flat interface DataSource is used to extract file data into the PS
A. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer.
B. The BW Delta Queue is empty.
C. The BW DTP is set to Full extraction.
D. The DataSource has a delta process of FIL0.
E. The InfoPackage is not active.
F. The Transformation does not have rules for all destination fields.
Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers.
A. Complete data history.
B. Fast load of mass data.
C. A single version of the truth.
D. Ability to extract once and deploy many times.
E. A single version of the truth.
Which of the following types of join are possible with an InfoSet? (3)
A. Union
B. Unbalanced
C. Temporal
D. Inner
E. Left Outer
F. Temporal
You have been asked to delete a request from an InfoCube. What best describes the situation? Select the correct answer.
A. You cannot delete the request since it is compressed.
B. You cannot delete the request if it has a red status.
C. You have to create Aggregates before you delete the request.
D. You must change the request status to green before you can delete.
You have created a new Data Flow object in the graphical sAP BW data Flow tool by copying a Data Flow template. What must you do to use the new Data Flow? (1)
A. Copy non-persistent SAP BW Objects
B. Validate non-persistent SAP BW Objects
C. Activate non-persistent SAP BW Objects
D. Replace non-persistent SAP BW objects with active SAP BW objects
A process chain has encountered an error before its conclusion. What are possible troubleshooting steps? There are 3 correct answers.
A. Review the message in the context menu of the failed step.
B. Repeat the scheduled trigger of the process chain.
C. If available, use the Manage object context menu option of the failed step.
D. Use either the Repeat or Repair context menu option of the failed step.
E. Reschedule the process chain for the next day.
Which of the following actions must you perform to design the dimensions of an InfoCube when you want to accelerate query performance? (3)
A. Assign two characteristics that have an N:M relationship to different dimensions
B. Each dimension should have the same number of characteristics
C. Place the most selective characteristics first in the dimensions
D. Use the line item dimensions for characteristics with high cardinality
E. Assign two compounded characteristics to different dimensions
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_TBW60_74 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.