|Exam Name||:||SAP Certified Application Associate (Edition 2014) - SAP HANA|
|Questions and Answers||:||271 Q & A|
|Updated On||:||July 19, 2017|
|PDF Download Mirror||:||C_HANAIMP142 Brain Dump|
|Get Full Version||:||Pass4sure C_HANAIMP142 Full Version|
Which of the following are characteristics of an agile data mart running on SAP HANA? (Choose two)
Transformed application data is stored in the database.
Queries run on highly normalized application data.
Application data is transformed at query runtime.
Application data is transformed before loading.
In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result?
Where can you reactivate a user after too many invalid logon attempts? (Choose two)
In the INVALID_CONNECT_ATTEMPS view
In the user-specific schema
In the user properties in the SAP HANA studio
In the SQL Console
Which of the following is a best practice in calculation views?
Change an attribute to a measure.
Apply a static filter on a projection node.
Push calculations down to the attribute views.
Combine analytic views with a join node.
You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? (Choose two)
In the Catalog node of SAP HANA studio
In the SAP BusinessObjects Data Services job monitor
In the Content node of SAP HANA studio
In the SAP BusinessObjects Data Services table preview
Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three)
SAP System Landscape Directory (SLD)
SAP BusinessObjects Data Services
SAP Landscape Transformation (SLT)
SAP HANA Direct Extractor Connection (DXC)
When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do?
It prevents the RFC connection from reading the source system logging tables.
It deletes the database triggers and the logging tables in the source system.
It stops the RFC connection and deletes the target tables in SAP HANA.
It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.
Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two)
OLAP connection using MDX
Relational connection using BICS
Relational connection using ODBC
Relational connection using MDX
Relational connection using JDBC
What is one of the advantages of using SAP BusinessObjects Analysis, edition for Microsoft Office?
Direct access to attribute views in SAP HANA
Direct access to column tables in SAP HANA
Direct connection to SAP HANA via MDX
Direct connection to SAP HANA via BICS
You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorized". Which of the following 4 statements do you execute to resolve the error before you reactivate the model?
GRANT SELECT on SCHEMA XYZ to _SYS_REPO
GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION
GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION
What happens when you turn on replication of an SAP ERP source system using SAP Landscape Transformation (SLT)?
SLT creates ABAP code in the ERP system that writes to application tables.
SLT creates ABAP code in the ERP system that writes to logging tables.
SLT creates database triggers in the ERP system that write to logging tables.
SLT creates database triggers in the ERP system that write to application tables.
You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three)
Use SAP Landscape Transformation (SLT).
Use the data preview in SAP HANA studio.
Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence).
Use the database schema _SYS_REPO.
Write and execute an appropriate SQL statement.
Which of the following tasks must you perform before you publish a universe within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose two)
Add the INFORMATION_CONSUMER role to the user.
Add dimensions and measures to the business layer.
Add information models to the data foundation.
Add an information space to the business layer.
You modify an existing view. How can you determine which models are affected by this change?
Use the audit trail.
Use the History feature for the changed model.
Use the "Where-Used List" feature for the changed model.
Use the "Auto Documentation" to compare the object version of the changed model.
Download SAP HANA Certification Dumps of 100 % Pass Guaranteed from this link : BS9dkb
C_HANAIMP151 : SAP Certified Application Associate -SAP HANA (Edition 2015)
C_HANASUP_1 : SAP Certified Support Associate -SAP HANA 1.0
C_HANATEC141 : SAP Certified Technology Associate (Edition 2014) -SAP HANA
C_HANATEC142 : SAP Certified Technology Associate -SAP HANA (Edition 2014)
C_HANATEC151 : SAP Certified Technology Associate -SAP HANA (Edition 2015)
C_HANATEC_10 : SAP Certified Technology Associate -SAP HANA (Edition 2015)
D_HANAIMP_10 : SAP Certified Application Associate – SAP HANA SPS10
D_HANATEC_10 : SAP Certified Technology Associate – SAP HANA SPS10
E_HANAAW141 : SAP Certified Development Specialist (Edition 2014) - ABAP for SAP HANA
E_HANAAW142 : SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2014)
E_HANAAW151 : SAP Certified Development Specialist (Edition 2015) - ABAP for SAP HANA
E_HANABW141 : SAP Certified Application Specialist (Edition 2014) - SAP BW powered by SAP HANA
E_HANABW151 : SAP Certified Application Specialist -SAP BW on SAP HANA (Edition 2015)
E_HANAINS141 : SAP Certified Technology Specialist (Edition 2014) - SAP HANA Installation
E_HANAINS142 : SAP Certified Technology Specialist (Edition 2014) -SAP HANA Installation
E_HANAINS151 : SAP Certified Technology Specialist -SAP HANA Installation (Edition 2015)
P_HANAIMP141 : SAP Certified Application Professional -SAP HANA - (Edition 2014)
P_HANAIMP142 : SAP Certified Application Professional -SAP HANA (Edition 2014)
Topics: Introduction to SAP HANA, the difference between HANA and other tools available in the market, the best of OLAP and OLTP in one tool, the expansive nature of SAP HANA, understanding SAP BW, SAP in-memory strategy.
2. Architecture of SAP HANA
Topics: An overview of the SAP HANA architecture, the various component and concepts on which SAP HANA works, the basic terminology, learning about ABAP based scenarios, understanding the SAP Landscape Transformation, trigger-based approach, working with the multi system support, configuring and monitoring dashboard, start and stop replication, integration with SLT, SLT and HANA compatible matrix.
3. Non-application server: ABAP-based scenarios
Topics: Understanding the ABAP language for developing SAP R3 platform, learning about the various non-application server ABAP-based scenarios.
4. Transformations in SAP HANA
Topics: Learning about the data transformation in SAP HANA, the process of data integration, data cleansing and consolidation, the process of loading data from one BI object to another, converting a field of source into target object format, various types of transformation, merge transformation, history preservation transformation, row generator, table comparison, slowly changing dimensions.
5. Introduction to HANA Studio Modeler
Topics: Introduction to SAP HANA Studio, connection and session management, request processing and execution control, learning about Transaction and Metadata Manager, row and column data storage, system generated schema, backup and recovery, defining Star Schema, introduction to Studio Modeler, grasping the different terminologies, the Graphical User Interface in SAP HANA.
6. Deep dive into HANA Modeling
Topics: Clear understanding of SAP HANA modeling, creating modeling views, types of information views like analytical, attribute and calculation view, view processing using various engines in SAP HANA.
7. HANA Searching Types
Topics: Introduction to search in SAP HANA, the various type of data search available, searching for tables, and views, querying data suing OData services, deploying SQL queries.
8. Database Connectivity with SAP HANA
Topics: Learning about SAP HANA database connectivity, studying detailed interface between SAP HANA and SAP BO, designing universe using HANA tables, report creation, crystal report in HANA database using ODBC connection, report creation in dashboard based on HANA universe.
9. SAP BO Analysis
Topics: Introduction to SAP BusinessObjects analysis, learning about multidimensional ad hoc analysis of OLAP sources in Excel, working with SAP HANA Explorer.
10. Important Rules of Model Validation
Topics: Managing and processing of models, rules of model validation, understanding referencing to Model, deploying auto documentation and learning about delivery units.
11. Ensuring backup and recovery
Topics: Introduction to HANA backup and recovery processes, understanding High Availability, Disaster Tolerance, learning about Persistent Layer, method of taking data backup and facilitating recovery, the concept of sizing in SAP HANA.
12. Techniques of Storage
Topics: Learning about HANA Appliance and Appliance Model, the various techniques of data storage in HANA, row-based and column-based storage, deployment options in HANA.
13. User Management, Provisioning and Security
Topics: Managing the SAP HANA platform, understanding user provisioning, concepts of SAP HANA sizing for working in different scenarios, security management and authorization features, learning about multi-tenant database containers.
14. Privileges and Managing Connections
Topics: The various types of privileges in SAP HANA – system, object, analytic and package, understanding various entities and relationships, managing of connection attempts, learning about SQL analytic and class analytic privileges, creating procedure using NoSQL methods.
15. Calculated attributes
Topics: Learning about attributes, creation of attribute views, learning about derived attributes, the concept of calculated attributes, understanding levelled hierarchy, calculated and restricted measure.
16. Creation of Calculation Views
Topics: Introduction to calculation view, powerful and flexible information view, deploying complex calculations on tables, creating calculation view using graphical and SQL scripting.
17. Data Provisioning Overview
Topics: Learning about data provisioning, designing and enabling a network to provide data to users, loading of data to SAP HANA before it is loaded to front-end, provisioning of data using flat files, SAP BO Data Services, configuring database and data services platform, ETL transformation.
18. ABAP Dataflow
Topics: Introduction to ABAP dataflow to work with large volumes of records, generating ABAP program files, deploying SAP Landscape Transformation, the business features of it.
19. Configure and Monitor Dashboard
Topics: Use of SAP HANA Modeler, Template tables, Configure and Monitor dashboard
SAP HANA Projects
Project –Develop reports using SAP HANA
Dataset – Sales
Topics –This project is involved with creation of reports using SAP HANA. You will get in-depth understanding of creating SAP HANA reports with SAP Business Objects explorer, learning to deploy different SAP HANA views like attribute, analytic and calculation views, understanding how to create SAP HANA Crystal Report, deploying MDX Provider for connecting HANA system to Excel data, data modeling techniques. Upon completion of the project you will gain expertise to develop reports from multiple data sources and view it to glean valuable insights.
Start display at page:
Download "List of certification codes for SAP TechEd, Bangalore"
1 List of certification codes for SAP TechEd, Bangalore Solution Solution Part Short Text (new) Product Name BI Planning Planning BI Web Intelligence SAP Enterprise Information Data Services Portal Afaria 7.0 C_AFARIA_01 Afaria 7 C_AFARIA_02 Associate - Strategic C_APO1_72 Associate - C_APO2_72 C_AUDSEC_731 Development Associate - C_BITWF_73 C_BOBIP_40 C_BOBIP_41 Crystal C_BOCR_11 Associate C_BODI_20 C_BOE_30 Associate C_BOWI_30 C_BOWI_40 C_BOWI_41 Associate - Data C_DS_41 Solution C_E2E100_718 Change Control Expert - SAP C_E2E200_713 Associate - Business C_E2E300_713 Associate - NetWeaver C_EP_731 Development Associate - C_EP120_701 C_EPMBPC_10 C_EPMBPC_75 C_EPMFC_10 Associate - Financial C_EPMFC_75
2 Enterprise SOA SAP SRM Extendedware House SAP for Banking Insurance SAP for Banking SAP for Utilities GRC solutions SAP for Retail Enterprise SOA Enterprise Modeling Associate - Extended C_EWM_90 Associate - Analytical Banking in SAP C_FSABAN_80 for C_FSIINS_66 Associate - Transactional Banking in C_FSTBAN_80 Associate - Utilities with 6.0 C_FSUTIL_60 Associate - Access Control with SBO C_GRCAC_10 Associate (Edition 2014) - C_HANAIMP141 Associate (Edition 2014) - ">C_HANAIMP142 Associate (Edition 2014) - C_HANATEC141 Associate - HCM Payroll C_HCMY_65 HCM C_HCMY_67 Associate - Retail with SAP C_ISR_60 Solution Manager C_LT100_713 Associate Project Manager C_PM_71 Development Associate C_SAPWMGR_01 Associate - C_SASEAA157 Associate - Development C_SASEDA_157 Solution C_SM100_718 Solution C_SM200_718 Associate Business C_SM300_713 Mobile C_SMDM_23 Development Associate C_SMPNHB_23 Associate Enterprise Architect C_SOA200_70 Development Associate - C_SPBDA_125 Development Associate - C_SPDDA_165 Associate Supplier C_SRM_71
3 SAP SRM System Business Warehouse Associate - Supplier C_SRM_72 Associate - Sybase C_SUDM_01 Development Associate - C_SUPDEV_01 Associate - System C_TADM50_731 Associate - System C_TADM50702 Associate - System C_TADM51_731 Associate - System C_TADM51702 Associate - System C_TADM53_70 Associate - System C_TADM53702 Associate System C_TADM54_731 Associate - System C_TADM56_731 Associate - System C_TADM56702 Associate - OSDB C_TADM70_73 Associate development consultant C_TAW12_71 Development Associate - C_TAW12_731 Associate Business C_TBI30_73 Development Associate - C_TBIT44_73 Development Associate - C_TBIT44_731 Associate - Process C_TBIT51_73 Associate - Process C_TBIT51_731 Associate- Business C_TBW45_70 Associate Modeling and C_TBW55_73 Associate Modeling and C_TBW60_74 Associate C_TBW65_73 Associate - CRM C_TCRM20_71 Associate - CRM C_TCRM20_72
4 Success Factors Cloud HCM Other Solution Employee Central SAP for Oil and Gas Transportation Transportation Corporate and Support Functions Operations: Cross Functioons Quality SCM Planning Sales and Services Operations: Sales and Customer Service Solution C_TE2E10_718 Associate - C_TFIN22_65 Associate - C_TFIN22_66 Associate - Financial C_TFIN52_65 Associate - Financial C_TFIN52_66 Associate - C_THR12_65 Associate C_THR12_66 Associate C_THR12_67 Associate Cloud HCM C_THR81_1405 Associate - Supply Chain C_TIOG20_65 C_TM_80 Associate - Transportation C_TM_90 Associate - Project C_TPLM22_60 Associate - Project C_TPLM22_64 Associate - Enterprise C_TPLM30_65 Associate - C_TPLM30_66 Associate - Quality C_TPLM40_65 Portfolio C_TPLM50_95 Associate - Extended C_TSCM12_65 Associate - - C_TSCM42_64 Associate - - C_TSCM42_65 Associate - - C_TSCM42_66 Associate - Planning and C_TSCM44_65 Associate - C_TSCM52_66 Associate - Order C_TSCM62_65 Associate - Sales and C_TSCM62_66
5 SAP SRM Site Logistics (Warehousing) Logistics Execution and Warehouse Extended Warehouse Extended Warehouse and Logistics Execution Planning Order Fulfillment Associate - Logistics C_TSCM66_65 Associate - Logistics C_TSCM66_66 - C_TSM10_718 System P_ADMSEC_731 System P_ADMSYS_731 Enterprise P_BIE_70 Modeling P_BIE_73 Reporting P_BIR_70 Business P_BIR_73 Marketing P_CRMMKT_71 Sales with P_CRMSLS_71 Marketing P_CRMSRV_71 SAP P_EWM_90 EWM with P_EWMWM_65 Financial P_FINACC_65 Financial P_FINACC_66 P_FINMGT_65 Professional (Edition P_HANAIMP141 HCM Talent P_HCMTM_65 HCM P_HCMWPM_65 Logistics P_LEWM_64 P_PRO_65 P_PRO_66 P_PROD_66 Order P_SD_65 Supplier P_SRM_72
Liste des e-learnings SAP Education
A1BASe SAP Business All-in-One ERP Basics 16 (with demos) 700 disponible ECC 6.0 83 Anglais A1LOGe SAP Business All-in-One Logistics Specialization 20 (with demos) 875 disponible ECC 6.0 83 Anglais A1FINe
More information Calendário de Formação
Calendário de Formação Julho a Dezembro de 2013 PORTUGAL Oracle Portugal Edifi cio 8, Lagoas Park 2740-244 Porto Salvo Oeiras Portugal Calendário de Formação Julho a Dezembro de 2013 Para obter mais informações,
More information SAP Education Solutions
The Rise of Non-Traditional Classroom Training The trends that are revolutionising IT training Page 4 SAP Workforce Performance Builder Reducing the time, risk and cost of change Page 10 SAP HANA Courses
More information SAP Fiori UX. March 2015. Customer
SAP Fiori UX March 2015 Customer The world is changing Consumer user experience is the new standard 2015 SAP SE or an SAP affiliate company. . Public 2 Our mission Simplify your world
More information Enterprise Data Management
Enterprise Data Management Master Data Governance and Management Ensuring Intelligence in Business Intelligence Andreas Hofer SAP Enterprise Architect NetWeaver Solution Consulting SAP Canada Ontario Chapter
More information SUPPLY CHAIN AND LOGISTICS SERVICES
SUPPLY CHAIN AND LOGISTICS SERVICES OUR FOCUS YOUR GROWTH The global supply chain execution market is expected to reach approximately $3.8 billion by 2016, according to a Gartner report. However, growing
More information Master Data Management
Master Data Management Patrice Latinne ULB 3032010 Agenda Master Data Management case study Who & services roadmap definition data How What Why technology styles business 29032010 2 Why Master Data