IBM

C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

0

Test information:
Number of questions: 30
Time allowed in minutes: 60
Required passing score: 60%
Languages: English, Japanese

If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.

Section 1 – DB2 Server Management (17%)
Demonstrate the ability to configure DB2 workload for analytics system
DB2_WORKLOAD=ANALYTICS
DB CFG DFT_TABLE_ORG COLUMN
DB CFG DATABASE PAGE SIZE = 32K
DB CFG DFT_DEGREE=ANY
DB CFG DFT_EXTENT_SZ=4
Importance of UTIL_HEAP_SZ CFG for COLUMN ORGANIZED tables load
Demonstrate the ability to use autonomic features in DB2 10.5 BLU Acceleration
AUTO_RUNSTATS is not supported for COLUM ORGANIZED tables
Automatic Space Reclaims in BLU acceleration tables
Demonstrate knowledge of Data Studio 4.1
Demonstrate the ability to use Automated workload management when workload set to ANALYTICS

Section 2 – Physical Design (37%)
Demonstrate the ability to understand industry leading DB2 10.5 BLU Acceleration 7 big ideas
Simple to Impement and Use – No Indexes, No MDC, No MQT, No Partitioning, No Statistical Views
Friendly Huffman encoding – More frequent the values, the fewer bits in dictionary and packed registers. Performing most operations on encoded values.
Usage of SIMD Instruction Sets
Maximize CPU cache
Column Store – Minimal IO / Work performed directly on columns / Improved memory density / Cache efficiency
Memory Caching Facility – Leave the interesting data instead of traditional LRU or MRU algorithms
Data Skipping through SYNOPSIS Tables
Demonstrate the ability to understand and implement compression features
Table Compression – Data Compression / Value Compression / Adaptive Compression / COLUMN ORGANIZED table compression
Database backup compression
Demonstrate the ability to use expression based indexes and the statistics on those expression based indexes
Using RUNSTATS
Using Statistics Profiles
Automatic Statistics Collection
Knowledge of Oracle Migration and Compatibility Features in DB2 10.5
Demonstrate the ability to use Information Uniqueness Constraints
Knowledge of SQL compatibility enhancements
Extended row size support
Exclude null keys support

Section 3 – Monitoring DB2 Activity (17%)
Demonstrate the ability to use new monitor elements
Demonstrate the ability to use new monitor elements to monitor dynamic prefetch requests for data in column-oriented tables.
Demonstrate the ability to use new new monitor elements to measure column data size.
Demonstrate the ability to use new monitor elements to measure time spent in Columnar Data Engine (CDE)
Demonstrate knowledge of the new EXPLAIN enhancements Knowledge of SQL compatibility enhancements
Demonstrate the ability to understand new CTQ (Column Table Queue) Operator in the explain
Knowledge of new monitoring function – MON_GET_ROUTINE
Demonstrate knowledge of HADR monitoring enhancements
HEARTBEAT_MISSED
HEARTBEAT_EXPECTED
STANDBY_SPOOL_PERCENT
STANDBY_ERROR_TIME

Section 4 – High Availability (17%)
Knowledge of enhancements to pureScale
Understand the ability to use Online REORG in pureScale
Knowledge of replay member in pureScale standby cluster
Knowledge of HADR setup in a pureScale cluster environment
Demonstrate the ability to undestand Rolling Fix Pack Updates in pureScale
Demonstrate the ability to undestand STMM Multi-Tenancy Feature in pureScale
Demonstrate the ability to understand Explicit Hierarchical Locking Multi-Tenancy in pureScale system
Knowledge of DB2 Advanced Copy Services customized scripts

Section 5 – Utilities (13%)
Demonstrate the ability to use IBM Optim Query Workload Tuner
The Workload Table Organization Advisor
Support for comparing access plans before and after
Access Plan Explorer and in access plan graphs for the new CTQ operator
Demonstrate the ability to use DB2 10.5 Utilities
db2convert
LOAD Command – Additional ANALYZE phase for COLUMN ORGANIZED tables
Default AUTOMATIC STATISTICS COLLECTION in LOAD command for COLUMN ORGANIZED tables

IBM Certified Database Administrator – DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Job Role Description / Target Audience
If you are knowledgeable with DB2 10.5 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.

This exam covers only the new features and functionality of DB2 10.5 for Linux, UNIX and Windows – you must possess the DB2 10.1 DBA for Linux, UNIX and Windows certification in order to qualify for the upgrade exam.

C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

QUESTION 1
How is the Query Workload Tuner license installed and enabled?

A. With Data Studio, using the license activation kit.
B. By executing the db2licm command after data server installation.
C. With the Optim Performance Manager Server, using the license activation kit.
D. By running the Query Workload Tuner license activation command on the appropriate
WebSphere server.

Answer: A

Explanation:


QUESTION 2
If the DB2_WORKLOAD registry variable has not been set which database manager configuration
parameter must be modified, before a query that accesses a column-organized table can be
executed?

A. INTRA_PARALLEL
B. QUERY_HEAP_SZ
C. MAXIMUM DEGREE
D. SHEAPTHRES SHR

Answer: A

 

Click here to view complete Q&A of C2090-311 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-311 Certification, IBM C2090-311 Training at certkingdom.com

C2090-305 IBM InfoSphere Information Analyzer v9.1

0

Test information:
Number of questions: 64
Time allowed in minutes: 90
Required passing score: 64%
Languages: English

The IBM Certified Solution Developer – IBM InfoSphere Information Analyzer v9.1 exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to conduct a baseline assessment of the data/information being analyzed. This included characterizing the data or information condition in terms of completeness, validity, structural integrity, relational integrity, technical standards, and business rule compliance including quality monitoring and information governance.

Section 1 – Environment (9%)
List key components and configuration steps
Given a scenario, describe how to plan for a large data environment
Identify the minimum requirements for installation

Section 2 – Data Setup (9%)
Identify steps necessary to make data sources available for analysis
Given a scenario, describe project activity security

Section 3 – Profiling Process (25%)
Identify the purposes of each analysis
Interpret system flag icons throughout the system
Identify the common steps that are needed to perform data profiling
Given a scenario, describe the process needed to assess and use data profiling results

Section 4 – Data Rules / Monitoring (36%)
Describe the purpose of data rule validation
Given a scenario, describe the process to implement and deploy the data rule
Identify the steps needed to implement data rule monitoring and baselining
Identify the steps needed to perform data rule execution
Describe the purpose and process of exception management (output tables, Data Quality Console)
Identify the steps necessary to deploy and execute a data rule in an external process

Section 5 – Populating / Reporting / Publishing (14%)
Demonstrate how to populate/report/publish
Demonstrate knowledge of content creation and scheduling
Given a scenario, describe the process to deliver outputs to a broad community

Section 6 – Troubleshooting / Tuning (6%)
Given a scenario, demonstrate troubleshooting techniques
Given a scenario, demonstrate system and process tuning techniques

IBM Certified Solution Developer – InfoSphere Information Analyzer v9.1

Job Role Description / Target Audience
The IBM Certified Solution Developer – InfoSphere Information Analyzer v9.1 is a Source System Analyst, Data Analyst, Business Analyst, Data Quality Analyst, Data Steward, Data Modeler, Data Architect, ETL Developer, and Data Scientist.


QUESTION 1
What feature permits the addition of data from one or more columns into one column allowing column analysis on this newly formed concatenated column?

A. Virtual table
B. Logical table
C. Virtual column
D. Logical column

Answer: C
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 70)


QUESTION 2
When importing published analysis results into a different Information Analyzer project which two contents are included?

A. Median value
B. Frequency values
C. Data Classification
D. Cardinality Percent
E. Uniqueness Code

Answer: C,D


QUESTION 3
You are searching for an employee named Kristie Jones who has accounts on various applications, in which she has used the first names Kristie, Kristin, and Kristen as her first name.
Which is the correct rule logic for addressing this problem?

A. name like (‘KristieTKristinTKristen’)[ ]’Jones’
B. name matches (,KristieTKristinTKristen,)[]’Jones,
C. name contains (‘KristieTKristinTKristen’^rJones’
D. name matches_regex (‘Kristie’l’KristinTKristen^j’Jones’

Answer: D


QUESTION 4
You are working with a System Administrator who must move an Information Analyzer project to a new Information Server environment using the command line tools. You need to ensure that the project is established with the same metadata and reports as in the original environment.
Which parameter must be included to successfully complete the export?

A. -includeCommonMetadata; -includeCommonReports; -includeAIIDataClasses
B. -includeAssignedAssets; -includeProjectReports; -includeAIIDataSources
C. -includeCommonMetadata; -includeReports; -includeAIIDataClasses
D. -includeProjectMetadata; -includelAReports; -includeDependentClasses

Answer: D

Click here to view complete Q&A of C2090-305 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-305 Certification, IBM C2090-305 Training at certkingdom.com

 

C2090-180 IBM Cognos BI Professional

0

Test information:
Number of questions: 66
Time allowed in minutes: 90
Required passing score: 71%
Languages: English

The Cognos BI Professional exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience.

Iterative Development and CSIM (9%)
Identify different approaches for implementing BI projects
Identify the value of using a methodology
Distinguish between an approach and a methodology
Describe the iterative development process

Dimensional Design and Key Metrics (14%)
Describe the relationship between dimensions, facts, and granularity
Identify the differences between SQL and MDX
Define the Key Performance Indicators and identify their business purpose
Map Cognos components to KPI process flow
Describe the functional and organizational scope of Corporate Performance Management

Identify the Right Tool for the Business Need (16%)
Identify the differences between reporting, querying, and analysis
Map the Cognos products to reflect relationship between interactivity and formatting
Identify the need for scorecarding
Identify the need for planning
Identify the need for data manager
Identify the need for event management
Identify the need for analysis, reporting and querying
Identify different roles and categories of users

Determine User Requirements (15%)
Describe the importance of and the activities in the Analyze phase
Identify the elements of conducting a successful interview
Identify the dimensional elements of how users think about their business
Identify the metric elements and KPI of the dimensional design
Identify the business area to prototype with the highest return on investment
Identify methods of enriching the dimension map

Common Data Stores (14%)
Describe the data normalization process
Identify the difference between relational and OLAP data structures
Compare data store designs
Identify variations on data warehouse designs
Compare operational vs. reporting database designs
Identify considerations for modeling dimensionally (DMR) in Framework Manager

Cognos BI Architecture (12%)
Identify components and services of the Cognos Services Oriented Architecture
Describe benefits of the Cognos Application Firewall (CAF)
Describe the installation process
Identify considerations for installing to environments that include separate instances of a security provider
Identify considerations for addressing high availability and failover
Identify a properly designed installation map

Cognos BI Request Flows and Queues (8%)
Identify the correct flow of the request between architectural components and services for a given request
Identify the differences between high affinity and low affinity report execution requests and associated connections
Identify the relationship between scheduled jobs and batch reporting

Design, Build, and Deploy Considerations (8%)
Understand the use of the V-model testing
Considerations for moving between environments
Identify the important considerations for monitoring and tuning for performance
Identify application design and system considerations for performance

Maintain the BI Application (4%)
Identify the importance of ongoing monitoring the performance of the application
Describe the tracking and planning for enhancement requests and subsequent development phases
Identify integrating the new solution into regular backups and maintenance programs

IBM Certified Solution Expert – Cognos BI

Job Role Description / Target Audience
The BI Solution Expert (Professional) is responsible to analyze, plan, design, deploy, and operate Cognos applications using an appropriate methodology and development approach.

To achieve the IBM Certified Solution Expert – Cognos BI certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass four (4) exams.

Click the test link below to see the overview, objectives, and test preparation recommendations.

Recommended Prerequisite Skills
Prior to your preparation for this professional-level certification, the following knowledge and skills are recommended and assumed:
Knowledge of the Cognos Solutions Implementation Methodology
Technical proficiency in features of the Cognos Managers and Studios

 


QUESTION 1
A multi-server installation of Cognos BI must be performed. Which of the following is a valid strategy for installing across multiple servers?

A. Separate the gateway component from other server components to restrict report request processing to the Web server tier.
B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act as a primary dispatcher for routing requests to other dispatchers.
C. Scale the system vertically by installing one instance of all Cognos 8 services on a larger computer capable of managing more concurrent request threads.
D. Enable load balancing of requests for content management services by installing multiple instances of Content Manager.

Answer: B


QUESTION 2
Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?

A. Drill down from summary to detailed information within individual subject areas.
B. Drill across from one subject area to another through conformed dimensions.
C. Star schema data marts designed to facilitate analysis and reporting.
D. Event management designed to monitor the status of Key Performance Indicators.

Answer: B


QUESTION 3
A company has several operational data stores. They wish to compare data from the various data stores against one another. The data in the various stores must be manipulated to match. Eventual report performance is more important than development time. Which of the following Cognos 8 components would BEST address their requirements?

A. Report Studio and Query Studio
B. Analysis Studio and Report Studio
C. Data Manager and Analysis Studio
D. Planning, Data Manager, and Report Studio

Answer: C


QUESTION 4
Why should an application’s performance be monitored on an ongoing basis after it goes into production?

A. Initial performance tests are usually too optimistic.
B. There is little value in performance tests before a system goes into production.
C. Usage patterns on applications tend to change over time.
D. New releases of system and application software usually degrade performance.

Answer: C


QUESTION 5
Which of the following describes common methods for enriching an initial dimension map?

A. Add exception and range band dimensions and include additional metrics and calculations.
B. Merge dimensions and include additional metrics and calculations.
C. Include additional metrics and calculations and core metrics and dimensions from related business areas.
D. Include additional metrics, calculations, and hierarchy levels, and dimensions from related subject areas.

Answer: A

 

 

Click here to view complete Q&A of C2090-180 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-180 Certification, IBM C2090-180 Training at certkingdom.com

 

C2090-103 Apache Spark 1.6 Developer

0

Test information:
Number of questions: 60
Time allowed in minutes: 120
Required passing score: 65%
Languages: English

This test will certify that the successful candidate has the necessary skills to work with, transform, and act on data at a very large scale. The candidate will be able to build data pipelines and derive viable insights into the data using Apache Spark. The candidate is proficient in using streaming, machine learning, SQL and graph processing on Spark. This candidate may be a member of a Data Scientist team and/or Analytics team and has applied knowledge with deployment architectures and can assist in tuning, troubleshooting, and optimization.

Section 1 – Architecture (12%)
Compare and contrast Spark with Hadoop MapReduce
Explain memory management in Spark
Explain concepts such as master, drivers, executors, stages and tasks
Explain Spark transformations and actions with respect to lazy evaluation
Configure your application to run on a cluster

Section 2 – Performance and Troubleshooting (22%)
Manage partitions to improve RDD performance and apply different partition strategies
Identify what operations cause shuffling
Optimize memory usage with serialization options
Use caching, checkpoint, and persistence in appropriate situations
Debug Spark code
Monitor Spark applications
Manage runtime issues and performance bottlenecks in Spark

Section 3 – Core Skills (48%)
Read/writre data from multiple data sources and file types
Create and work with RDDs and related APIs
Create and work with DataFrames and related APIs
Create Spark config contexts for different requirements
Work with key value pairs and associated Spark APIs for key value pairs
Work with SparkSQL
Define and work with accumulators
Define and work with broadcast variables
Launch applications with spark-submit

Section 4 – Advanced Skills (18%)
Build a pipeline with Streaming, MLLib, SQL, and Graph on Spark
Work with Spark Streaming APIs
Work with SparkML and MLLib APIs
Work with GraphX

IBM Certified Developer – Apache Spark 1.6

Job Role Description / Target Audience
This test will certify that the successful candidate has the necessary skills to work with, transform, and act on data at a very large scale. The candidate will be able to build data pipelines and derive viable insights into the data using Apache Spark. The candidate is proficient in using streaming, machine learning, SQL and graph processing on Spark. This candidate may be a member of a Data Scientist team and/or Analytics team and has applied knowledge with deployment architectures and can assist in tuning, troubleshooting, and optimization.

Recommended Prerequisite Skills
Read and write Python code
Read and write Scala code
Create and work with RDDs and related APIs
Create and work with DataFrames and related APIs
Create and work with Dstreams and related APIs
Read/writre data from multiple data sources and file types
Read and write SQL statements
Compare and contrast Spark with Hadoop MapReduce
Manage partitions to improve RDD performance and apply different partition strategies
Identify what operations cause shuffling
Optimize memory usage with serialization options
Create Spark config contexts for different requirements
Use caching, checkpoint, and persistence in appropriate situations
Explain memory management in Spark
Work with key value pairs and associated Spark APIs for key value pairs
Define and work with accumulators
Configure your application to run on a cluster
Explain core concepts such as master, drivers, executors, stages and tasks
Debug your spark code
Define and work with broadcast variables
Explain Spark transformations and actions with respect to lazy evaluation
Monitor Spark applications
Launch applications with spark-submit
Manage runtime issues and performance bottlenecks in Spark
Build a pipeline with Streaming, MLLib, SQL, and Graph on Spark
Work with Spark Streaming APIs
Work with SparkML and MLLib APIs
Work with GraphX
Work with SparkSQL

Click here to view complete Q&A of C2090-103 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-103 Certification, IBM C2090-103 Training at certkingdom.com

C2090-101 IBM Big Data Engineer

0

Test information:
Number of questions: 53
Time allowed in minutes: 75
Required passing score: 65%
Languages: English

This test consists of 5 sections containing a total of 53 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Data Loading (34%)
Load unstructured data into InfoSphere BigInsights
Import streaming data into Hadoop using InfoSphere Streams
Create a BigSheets workbook
Import data into Hadoop and create Big SQL table definitions
Import data to HBase
Import data to Hive
Use Data Click to load from relational sources into InfoSphere BigInsights with a self-service process
Extract data from a relational source using Sqoop
Load log data into Hadoop using Flume
Insert data via IBM General Parallel File System (GPFS) Posix file system API
Load data with Hadoop command line utility

Data Security (8%)
Keep data secure within PCI standards
Uses masking (e.g. Optim, Big SQL), and redaction to protect sensitive data

Architecture and Integration (17%)
Implement MapReduce
Evaluate use cases for selecting Hive, Big SQL, or HBase
Create and/or query a Solr index
Evaluate use cases for selecting potential file formats (e.g. JSON, CSV, Parquet, Sequence, etc�)
Utilize Apache Hue for search visualization

Performance and Scalability (15%)
Use Resilient Distributed Dataset (RDD) to improve MapReduce performance
Choose file formats to optimize performance of Big SQL, JAQL, etc.
Make specific performance tuning decisions for Hive and HBase
Analyze performance considerations when using Apache Spark

Data Preparation, Transformation, and Export (26%)
Use Jaql query methods to transform data in InfoSphere BigInsights
Capture and prep social data for analytics
Integrating SPSS model scoring in InfoSphere Streams
Implement entity resolution within a Big Data platform (e.g. Big Match)
Utilize Pig for data transformation and data manipulation
Use Big SQL to transform data in InfoSphere BigInsights
Export processing results out of Hadoop (e.g. DataClick, DataStage, etc.)
Utilize consistent regions in InfoSphere Streams to ensure at least once processing

IBM Certified Data Engineer – Big Data

Job Role Description / Target Audience

This certification is intended for IBM Big Data Engineers. The Big Data Engineer works directly with the Data Architect and hands-on Developers to convert the architect’s Big Data vision and blueprint into a Big Data reality. The Data Engineer possesses a deep level of technical knowledge and experience across a wide array of products and technologies. A Data Engineer understands how to apply technologies to solve big data problems, and has the ability to build large-scale data processing systems for the enterprise. Data engineers develop, maintain, test and evaluate big data solutions within organizations. They provide input on the needed hardware and software to the architects.

Big Data Engineers focus on collecting, parsing, managing and analyzing large data sets, in order to provide the right data sets and visual tools for analysis to the data scientists. They understand the complexity of data and can handle different data variety (structured, semi-structured, unstructured), volume, velocity (including stream processing), and veracity. They also address the information governance and security challenges associated with the data. They have a good background in software engineering and extensive programming and scripting experience.

To attain the IBM Certified Big Data Engineer, candidates must pass one test. To gain additional knowledge and skills, and prepare for the test based on the job roles and test objectives, click on the link to the test below and refer to the Test Preparation tab.

Recommended Prerequisite Skills
Understand the data layer and particular areas of potential challenge/risk in the data layer
Ability to translate functional requirements into technical specifications.
Ability to take overall solution/logical architecture and provide physical architecture.
Understand Cluster Management
Understand Network Requirements
Understand Important interfaces
Understand Data Modeling
Ability to identify/support non-functional requirements for the solution
Understand Latency
Understand Scalability
Understand High Availability
Understand Data Replication and Synchronization
Understand Disaster Recovery
Understand Overall performance (Query Performance, Workload Management, Database Tuning)
Propose recommended and/or best practices regarding the movement, manipulation, and storage of data in a big data solution (including, but not limited to:
Understand Data ingestion technical options
Understand Data storage options and ramifications (for example , understand the additional requirements and challenges introduced by data in the cloud)
Understand Data querying techniques & availability to support analytics
Understand Data lineage and data governance
Understand Data variety (social, machine data) and data volume
Understand/Implement and provide guidance around data security to support implementation, including but not limited to:
Understand LDAP Security
Understand User Roles/Security
Understand Data Monitoring
Understand Personally Identifiable Information (PII) Data Security considerations

Software areas of central focus:
BigInsights
BigSQL
Hadoop
Cloudant (NoSQL)

Software areas of peripheral focus:
Information Server
Integration with BigInsights, Balanced Optimization for Hadoop, JAQL Push down capability, etc
Data Governance
Security features of BigInsights
Information Server (MetaData Workbench for Lineage)
Optim Integration with BigInsights (archival)
DataClick for BigInsights (Future: DataClick for Cloudant – to pull operation data into Hadoop for Analytics – scripts available today)
BigMatch (trying to get to a single view)
Guardium (monitoring)
Analytic Tools (SPSS)
BigSheets
Support in Hadoop/BigInsights
Data Availability and Querying Support
Streams
Interface/Integration with BigInsights
Streaming Data Concepts
In memory analytics
Netezza
DB2 BLU
Graph Databases
Machine Learning (System ML)

Click here to view complete Q&A of C2090-101 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-101 Certification, IBM C2090-101 Training at certkingdom.com

C2090-011 IBM SPSS Statistics Level 1 v2

0

C2090-011 IBM SPSS Statistics Level 1 v2

Test information:
Number of questions: 55
Time allowed in minutes: 90
Required passing score: 67%
Languages: English

Operations/Running IBM SPSS Statistics (15%)
General use
Operations
Settings
Syntax
Variables

Reading and Defining Data (16%)
Datasets
Reading data
Variables

Data Understanding/Descriptives (9%)
Crosstabs
Descriptive statistics
Dispersion
Procedure
Frequencies
Means procedure
Statistics

Data Management (15%)
Adding cases
Aggregation
Duplicate cases
SelectCases
SplitFile

Data Transformations (16%)
Categorical variables
Computing variables
Counting values across variables
Counting values across cases
IfConditions
Recoding
Variables

Output: Editing and Exploring (7%)
Charts
Exporting results
OMS
Output
Pivot Tables Editor
ScaleData::Boxplots
ScaleVariable charts
Scatterplots
TableLooks

Basic Inferential Statistics (22%)
Chi-square
Correlations
Regression
Samples
Statistics::Error
T-Test
Statistics

IBM Certified Specialist – SPSS Statistics Level 1 v2

Job Role Description / Target Audience
This certification is for individuals with a working knowledge of IBM SPSS Statistics version 15 or higher, including: analysts, statisticians, and individuals in academia, business, or research who use the IBM SPSS product. The IBM Certified Specialist – SPSS Statistics Level 1 v2 may utilize the IBM SPSS Statistics product for predictive analysis, market research and statistical research.

Requirements
This certification requires 1 test(s).


QUESTION 1
Suppose you want to copy and paste variable definitions from 481 variables in one data file to 481 corresponding variables in a second data file.
The only way to do this is to select and copy each variable’s definitions in the first file and paste to the corresponding variable in the second file.

A. True
B. False

Answer: B


QUESTION 2
In order to import data from database sources such as Access and Oracle into IBM SPSS Statistics, you must first export the data from the database to a tad file and then import this tad file into IBM SPSS Statistics?

A. True
B. False

Answer: B


QUESTION 3
Which variable name is correctly formed for use in an IBM SPSS Statistics data file?

A. 3job_categories
B. job_3_categories
C. Respondents’ age
D. Employee safety

Answer: B


QUESTION 4
Which transformation feature would you use to convert a string variable with values such as Female and Ma/e to a numeric variable with values I and 2?

A. Define Variable Properties
B. Automatic Recode
C. Visual Binning
D. Shift Values

Answer: B


QUESTION 5
Which options are available to edit bar charts? (Choose three.)

A. Changing patterns displayed in bars
B. Changing the major increment on the Y axis scale
C. Displaying data value labels
D. Changing the variable displayed on the X axis

Answer: A,B,C

 

Click here to view complete Q&A of C2090-011 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-011 Certification, IBM C2090-011 Training at certkingdom.com

C2070-993 IBM Case Manager V5.2.1 Solution Designer

0

Test information:
Number of questions: 62
Time allowed in minutes: 120
Required passing score: 57%
Languages: English

The test contains five sections, totaling 62 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 – Planning and Architecture (18%)
Demonstrate an understanding of IBM Case Manager Architecture
Identify solutions best addressed by Case Manager
Identify key differences between development and production environments
Identify integrated products and add-on software capabilities including licensing

Section 2 – Designing a Case Solution (30%)
Demonstrate an understanding of the Case Manager object model
Demonstrate an understanding of Case Builder and its Artifacts
Demonstrate an understanding of external documents
Demonstrate an understanding of Case Task and Process Fragments
Demonstrate an understanding of the Page Designer
Demonstrate an understanding of IBM Content Navigator integration
Demonstrate an understanding of the security model
Demonstrate the use of the Case Operations Component

Section 3 – Deploying, Testing and Troubleshooting a Case Solution (15%)
Demonstrate an understanding of the deployment structure and its limitations
Demonstrate knowledge of project areas
Demonstrate the use of the Case Manager Administration Client
Demonstrate knowledge of solution deployment troubleshooting
Demonstrate knowledge of solution comparison

Section 4 – Extending a Case Management Solution (16%)
Demonstrate knowledge of integrating custom widgets and business rules
Identify IBM capabilities to extend Case Manager
Demonstrate an understanding of building a custom application using REST service and JavaScript APIs
Demonstrate an understanding of mobile integration

Section 5 – Solution Migration (13%)
Demonstrate an understanding of Case Manager Configuration Manager, Case Manager Administration Client and FileNet Deployment Manager
Demonstrate an understanding of the requirements and steps to migrate a solution
Demonstrate an understanding of configuring security in a production environment

Section 6 – Business Metrics and Analytics (8%)
Demonstrate knowledge of using Case Analyzer
Demonstrate knowledge of using Case Monitor and Cognos RTM
Demonstrate knowledge of using Watson Content Analytics with Enterprise Search

IBM Certified Solution Designer – Case Manager V5.2.1

Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has the knowledge to create the theoretical and/or detailed technical design of an application, solution, and infrastructure using IBM Case Manager v5.2.1 (ICM). Provide expertise to evaluate and choose between alternatives; assist with balancing costs with capabilities and priorities. Identify products / technologies / processes to be included, and determine points of required integration and customization. Identify sizing and capacity issues, as well as conflicts with existing processes or environments.

Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed for your environment:
– Knowledge of IBM Case Manager
– Knowledge of IBM FileNet Content Platform Engine
– Knowledge of supported Application Servers
– Knowledge of Content Navigator
– Knowledge of Cognos RealTime Monitoring
– Knowledge of Watson Content Analytics
– Knowledge of Box integration
– Knowledge of VCS integration

Click here to view complete Q&A of C2070-993 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2070-993 Certification, IBM C2070-993 Training at certkingdom.com

C2070-991 IBM FileNet P8 V5.2.1, Deployment Professional

0

Test information:
Number of questions: 61
Time allowed in minutes: 120
Required passing score: 64%
Languages: English

The test contains seven sections, totaling 61 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 – Planning, Preparation and Security (Users and Groups) (19%)
Identify requirements for high availability, architecture and supported environments (Installation/upgrade worksheet)
Demonstrate knowledge of defining appropriate operating system accounts and privileges
Demonstrate knowledge of defining LDAP user/group roles for use in IBM FileNet P8
Show knowledge of operating system and network configuration pre-requisites for IBM FileNet P8
Demonstrate knowledge of defining database requirements
Demonstrate knowledge of storage areas options for object stores
Demonstrate knowledge of application server configuration requirements
Identify basic performance tuning parameters

Section 2 – Installation, Upgrade and Migration (30%)
Demonstrate knowledge of prerequisites for software installation and upgrade
Demonstrate an understanding of the Composite Platform Installation Toolkit (CPIT) for a single server install
Demonstrate an understanding of installing a distributed system:
Demonstrate knowledge of installation using GUI and Silent modes
Identify the sequence of P8 component installation
Identify specific High Availability installation methods
Demonstrate an understanding of P8 CPE client installation and files
Demonstrate knowledge of using the Configuration Manager tool
Identify and demonstrate the differences in upgrades processes and procedures between IBM FileNet P8 V4.5.X and V5.X to IBM +FileNet P8 V5.2.1
Demonstrate knowledge of migrating and deploying applications

Section 3 – Configuration (30%)
Identify the proper procedures for initial startup tasks, creating and configuring object stores, database storage areas, filestores and fixed content devices
Demonstrate knowledge of creating and configuring the workflow system
Demonstrate knowledge of Content Search Services
Demonstrate a basic understanding of Content Federation Services (CFS) configuration
Demonstrate knowledge of Secure Socket Layer (SSL) and Single Sign On (SSO) configuration
Demonstrate knowledge of client application connections to CPE

Section 4 – System Validation (8%)
Demonstrate ability to test IBM FileNet P8 CPE server status
Demonstrate the ability to validate basic IBM FileNet P8 CPE system interaction and functionality
Explain High Availability (HA) testing methodology

Section 5 – Troubleshooting (13%)
Demonstrate knowledge and use of the MustGather technical document
Demonstrate knowledge of application server log location
Demonstrate knowledge of CPE component logging and tracing
Demonstrate ability to interpret log files and decide on courses of action
Demonstrate knowledge of evaluating and applying system fixpacks

IBM Certified Deployment Professional – FileNet P8 V5.2.1

Job Role Description / Target Audience
This intermediate level certification test certifies that the successful candidate has important knowledge, skills, and abilities necessary to perform planning, installation, upgrade, configuration, configuration documentation, security, basic performance tuning and troubleshooting on IBM FileNet P8 V5.2.1.

The deployment professional is generally self-sufficient and is able to perform most of the tasks involved in the role with limited amount of assistance from peers and vendor support services. The deployment professional efficiently uses product documentation.

Recommended Prerequisite Skills

Before preparing for this certification, basic understanding of the following is recommended and assumed for your environment:
working knowledge of supported operating systems
working knowledge of supported application servers
working knowledge of supported relational databases
working knowledge of supported Lightweight Directory Access Protocol (LDAP) servers
working knowledge of Content Navigator
working knowledge of supported High Availability (HA): load balancing, farming, and clustering technologies
working knowledge of Secure Socket Layer (SSL) / Single Sign On (SSO)
working knowledge of P8 performance tuning

Click here to view complete Q&A of C2070-991 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2070-991 Certification, IBM C2070-991 Training at certkingdom.com

 

C2070-989 IBM Content Collector (IBM Domino) V4.0, Solution Designer

0

Test information:
Number of questions: 69
Time allowed in minutes: 150
Required passing score: 63%
Languages: English

The test contains seven sections, totaling 69 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 – Solution Planning and Design (9%)
Describe the client requirements (prerequisites)
Determine the solution components
Design solution architecture

Section 2 – System Preparation and Installation (17%)
Verify base system (HW prereqs, OS/SW prereqs, network, storage)
Show knowledge of IBM Content Collector Cluster
Verify ICC Service Account Permissions
Prepare and verify the Collection Sources
Prepare and verify the Repository
Prepare and verify the Repository
Install Content Search Service Support
Install Content Collector Text Search Support
Show knowledge of the ICC Web Application Server and its configuration
Show knowledge of Notes API installation

Section 3 – Initial Configuration and Configuration Manager (17%)
Understand Initial Configuration Tool and set-up tools
Configure collection source connectors (SMTP, File Source, Email systems, Sharepoint, etc)
Configure target repository connectors�
Configure Web Service connector
Add Custom Metadata to a Text Search
Configure general settings (web services, archive data access, search, configuration for ICC client functions)
Configure Task Route Service

Section 4 – Email Clients (Domino) (15%)
Show an understanding of IBM Content Collector functions in IBM Notes and iNotes and how to enable them
Enable and test Domino Template for basic IBM Content Collector functions in IBM Notes and iNotes
Enable and test an Offine repository for offline users in IBM Notes
Install and test Content Collector Notes Extension for automatic document retrieval in IBM Notes
Install and test Content Collector Search plugin for unified search in IBM Notes
Show knowledge of uploading a local NSF file for archiving in IBM Notes

Section 5 – Task Route Design (13%)
Create task routes
Show understanding of scheduling of collectors and configuration of sources
Show understanding of different stubbing options
Show understanding of how to use decision point, rules, expression editor
Configure an audit task
Import and export task routes
Show an understanding of using the error task route

Section 6 – Administration and Execution (13%)
Show an understanding of ICC Windows services
Show knowledge of administering an ICC cluster
Show an understanding of Expiration Manager and Retention Manager
Configure and use logging in various components
Configure and schedule the CM indexer
Backup and restore the ICC Configuration Catalog�

Section 7 – Monitoring and Troubleshooting (16%)
Monitor using blacklist, system dashboard, report viewer
Monitor using mailbox statistics task route
Configure and use performance counters
Monitor and troubleshoot P8 and CM indexing
Troubleshoot configuration web service, search and restore issues
Troubleshoot Task Route failures
Collect logs using must gather documents

IBM Certified Solution Designer – Content Collector V4.0 (IBM Domino)

Job Role Description / Target Audience
This intermediate level certified solution designer is an individual that has the required knowledge, skills, and abilities necessary to design and implement IBM Content Collector based archiving and compliance solutions.

Recommended Prerequisite Skills
Before preparing for this certification, basic understanding of the following is recommended and assumed for your environment:
– Working knowledge of IBM ECM repositories
– Knowledge of ICC capabilities, features and the ability to design and implement solutions
– Working knowledge of IBM Domino and SMTP email systems OR Working knowledge of Microsoft Exchange and SMTP email systems
– Working knowledge of IBM Connections
– Working knowledge of Microsoft SharePoint
– Working knowledge of supported File Systems

 

Click here to view complete Q&A of C2070-989 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2070-989 Certification, IBM C2070-989 Training at certkingdom.com

C2070-987 IBM Content Manager V8.5 Solution Designer

0

Test information:
Number of questions: 67
Time allowed in minutes: 120
Required passing score: 62%
Languages: English

The test contains six sections, totaling 67 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 – Planning and Architecture (23%)
Design Data Model
Describe performance planning
Identify Workload and Storage Requirements
Design Configuration Topology
Design Authentication Methodology
Design Transport Security
Design Policy for High Availability and Disaster Recovery
Planning for Clients

Section 2 – Installation and Configuration (6%)
Identify installation prerequisites
Identify installation Methods
Configure Base Installation based on Customer Requirements

Section 3 – System Administration (21%)
Configure library server parameters
Define and configure administrative domains
Set up LDAP configuration
Configure resource managers
Define users and assign to user groups
Set up access controls
Define data modeling entities such as attributes and item types
Define document routing processes

Section 4 – Resource Manager Administration (17%)
Define storage hierarchies and devices
Integrate Tivoli Storage Manager with Resource Manager
Manage Resource Manager services
Define Resource Manager migration rules
Define Resource Manager replication rules
Define workstation collections
Define LAN Cache
Identify the Resource Manager Administration Console

Section 5 – Maintenance and Performance Tuning (9%)
Evaluate performance criteria against:
Timing (batch loads/retrieves, image loads, user response, maximum loads)
System Resources (file, size, CPU usage, memory usage, DASD usage, network traffic)
Identify server performance optimization techniques
Identify Resource Manager performance tuning techniques

Section 6 – Application Integration (9%)
Identify requirements for customer client
Indentify CM integration options
Custom application
User Exits
Event Handler
Explain IBM Content Navigator integration with CM

Section 7 – Application Security (6%)
Configure transport security
Configure content security
Configure DB credential security

Section 8 – Troubleshooting (9%)
Determine functionality/component issue
Run traces to diagnose the problem
Review error messages in logs to determine problem
Verify system configuration and associated files
Perform database instance sourcing
Validate system configuration files

IBM Certified Solution Designer – Content Manager V8.5

Job Role Description / Target Audience
This intermediate level certification credential enables information management and database professionals to prove their competency on the industry’s most advanced content management technology to solve the critical business issue of managing and integrating all forms of information, including scanned images, audio, video and information from multiple sources. IBM content management helps integrate and deliver critical business information on demand. IBM’s comprehensive content management portfolio assists organizations that must improve productivity, enhance responsiveness, comply with regulatory demands, and offers a uniquely open and flexible platform for capturing, integrating, managing, records-enabling and delivering all information assets throughout their lifecycle.

Recommended Prerequisite Skills

Before preparing for this certification, the following knowledge and skills are recommended and assumed:
Hands-on experience implementing IBM Content Manager Version V8.5 in a multi-platform customer environment
Working knowledge of the supported operating systems
Working knowledge of supported IBM Content Manager clients
Working knowledge of relational database concepts
Working knowledge of System Managed Storage, including Tivoli Storage Manager, NAS, SAN
Working knowledge of WebSphere Application Server
General knowledge of LDAP


QUESTION 1
A solution designer is designing an IBM Content Manager system. As part of planning, the designer needs to make sure the hardware will be powerful enough to meet the throughput requirements.
Which of following can be used to measure throughput of an IBM Content Manager system in a given interval of time?

A. The number of database transactions in resource manager.
B. The total number of operations that can be executed per user.
C. The number of concurrent users that can be served by the system.
D. The total number of workload operations that can be executed for the entire system.

Answer: D


QUESTION 2
An IHM Content Manager solution designer wants to configure two resource managers so that an object is available for both store and retrieval if the resource manager that contains the primary object is offline.
Which of the following options will meet this requirement?

A. Replication between the resource managers.
B. Remote migration between the resource managers.
C. Deploy the resource managers in a WebSphere cluster.
D. Synchronous replication between the resource managers.

Answer: C


QUESTION 3
A human resources department agrees to share their IBM Content Manager V8.5 infrastructure with the audit department. Both departments want to exclusively administer their users.
Which of the Following options will accomplish this objective?

A. Create user groups
B. Enable administrative domains
C. Create different Resource Managers
D. Create different privilege sets and AC Ls

Answer: B


QUESTION 4
Multiple users of an IBM Content Manager Enterprise Edition system have reported the following condition:
While using IBM Content Navigator, they are able to search for items and get results.When they try to retrieve stored items, they receive an error. They are also unable to store new items to the IBM Content Manager Enterprise Edition repository.
Based upon the problem description, which component should be checked first?

A. Library server database
B. Resource manager database
C. Resource manager application -server
D. IBM Content Navigator application server

Answer: D


QUESTION 5
Content is migrated to Tivoli Storage Manager in aggregation mode.
Which of the following changes to settings will enable partial retrieval for Tivoli Storage Manager aggregate object members?

A. TSM_PARTIAI__RETRIEVE_D<SABLED in RMCONFIGURATION table is set to YES.
B. TSM_PARTIAL_RETRIEVE_DISABLED in RMCONFIGURATION table is set to NO. with Tivoli Storage Manager client encryption is used.
C. TSM_PARTIAL_R£TR1EVE_DISABLED in RMCONFIGURATION table is set to NO. with Tivoli Storage Manager client compression is used.
D. TSM_PARTIAL_RETRIEVE_DISABLEDin RMCONFIGURATION tables set to NO, and
neither Tivoli Storage Manager client compression nor Tivoli Storage Manager client encryption is used

Answer: A

 

Click here to view complete Q&A of C2070-987 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2070-987 Certification, IBM C2070-987 Training at certkingdom.com

Go to Top