Archive for May, 2017:

C2090-320 DB2 11 Fundamentals for z/OS

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

This Database Associate certification is an entry level exam for a user of any of the DB2 for z/OS family of products. This individual is knowledgeable about the fundamental concepts of DB2 11 for z/OS through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 11, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 – Working with SQL and XML (14%)
Basic ability to write a DML SQL statement
Basic ability to access and process XML data (XQuery, Xpath)
Basic knowledge of most commonly used special registers
Basic knowledge of built-in functions

Section 2 – Security (8%)
Basic knowledge of restricting data access (authorities, privileges, views, profiles, roles, trusted contexts)
Basic ability to write a Data Control Language (DCL) SQL statement

Section 3 – Planning (17%)
Basic ability to connect to DB2 servers (demonstrate ability to use remote access)
Basic knowledge of different types of tables (Base, MQT, Auxiliary, Partitioned, Temporal � at a high level; when is it appropriate to use each type) and table spaces
Basic knowledge of subsystem parameters
Basic knowledge of DB2 architecture (address spaces, logs, IRLM)
Basic knowledge of data sharing concepts
Basic knowledge of database workloads (transactional processing vs. analytics)
Basic knowledge of encoding scheme concepts

Section 4 – Operations (14%)
Basic knowledge of DB2 commands and DSN commands
Basic knowledge of DB2 utilities
Basic knowledge of troubleshooting (Explain, SQL Codes)

Section 5 – Data Concurrency (10%)
Basic knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINT)
Basic knowledge of locking
Given a situation, basic knowledge to identify the isolation levels that should be used

Section 6 – Application Design (19%)
Basic ability to create and call a stored procedure or a user defined function (understanding of passing parameters and obtaining results)
Basic knowledge of temporary tables (how they are created and when they should be used)
Basic knowledge of triggers (how they function; when they might be used)
Basic knowledge of program preparation and BIND options
Basic knowledge of referential integrity and constraints
Basic knowledge of non-relational data concepts (XML data, LOB data)
Basic knowledge of Temporal (Time Travel) Tables – System-period, Application-period, and Bi-temporal – ability to create and query

Section 7 – Working with Database Objects (17%)
Basic ability to demonstrate usage of IBM-supplied and user-defined data types
Basic ability to write a DDL SQL statement
Basic ability to identify characteristics and properties of DB2 objects (Tables, Indexes, Views,…)
Basic ability to look up information in the DB2 catalog

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

MCTS Training, MCITP Trainnig

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


Continue Reading

C2090-313 DB2 11 Application Developer for z/OS

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

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

Database Objects (13%)
Create and alter database demonstrating knowledge of database attributes
Create and alter tables demonstrating knowledge of table attributes
Demonstrate knowledge of types, attributes, and purpose of indexes
Create table columns demonstrating knowledge and application of various data types
Apply constraints to database tables and columns
Correctly apply encoding schemes to tables
Manage sequences and identities on tables
Create views and understand the best practices for the use of those views

Data Retrieval & Manipulation (12%)
Create table joins using best practices
Merge / select from data change table reference
Demonstrate knowledege of when to use truncate versus delete
Create functions & expressions
Apply knowledge of best practices for grouping, aggregation, and uniqueness
Apply knowledge of best practices for inserts, updates & deletes
Apply knowledge of best practices for Predicates (BETWEEN, IN, LIKE)

Distributed Access to DB2 (8%)
Manage connections to optimize performance
Identify what makes a cursor ambiguous
Determine whether limited fetch or optimize clause should be used in a query
Use best practices to determine generic program options
Set up a data source (dot net, java, odbc)

Coding SQL in Application Programs (10%)
Manage the use of cursors within a program
Apply best practices for error handling
Demonstrate knowledge of when to use dynamic versus static SQL
Demonstrate knowledge of multi-row syntax
Understand when and how to use DCLGEN
Understand how to prepare the program for execution

Processing Options that affect program design (8%)
Understand when and how to use precompile options
Understand when and how to use Bind Options & Connection Settings
Understand when and how to use Special Registers & Built-in Global Variables
Understand when and how to use options at the statement level

Performance Considerations (7%)
Identify examples of accounting trace usage
Understand the use of explain data and IBM Data Studio
Identify differences in DB2 access paths
Identify Stage 1 versus Stage 2 Predicates

Units of work, concurrency, and checkpoint/restart (10%)
Ability to use Isolation Levels & bind release options
Identify the differences between COMMIT, ROLLBACK, and SAVEPOINTS
Ability to recognize and code basic Units of Work
Ability to recognize and code Data Currency options
Knowledge of best practices and restrictions for Autonomous Transactions
Applies Process control and Checkpoint / Restart processing

Application Design & Lifecycle (8%)
Ability to validate execution results are correct
Ability to test connections and stored procedures
Ability to work with DB2 LOAD and UNLOAD utilities
Ability to troubleshoot application performance
Ability to properly utilize DB2 Performance Features

Access to Non-Structured Data (8%)
Ability to work with native XML data
Ability to work with JSON data
Ability to perform schema Validation for XML
Ability to work with XML Built-In Functions
Ability to access Hadoop Data

Advanced Programming Topics (15%)
Ability to work with Stored Procedures
Ability to make use of UDF’s
Ability to use Triggers
Ability to manage relationships between tables using Referential Integrity
Ability to work with Temporal and Archive Tables
Ability to work with MQTs
Ability to work with Temporary Tables
Ability to work with Data Masking techniques

IBM Certified Application Developer – DB2 11 for z/OS

Job Role Description / Target Audience
This certification is intended for the IBM DB2 for z/OS application developers. This is a highly skilled individual responsible for the development of applications that utilize the DB2 product on the z/OS operating system. This individual has significant experience as a designer and developer and has extensive knowledge of DB2 application development constructs, including new features and functionality related to version 11.

This person is capable of performing intermediate to advanced tasks related to application design and implementation, SQL programming, multi-platform deployment (local and/or multi-tiered applications), performance, testing, troubleshooting, and programming specific to DB2 for z/OS. The IBM Certified DB2 for z/OS Application Developer should also, at a minimum, be aware of, and have some experience with, best practices for interfacing with DB2.

To attain the IBM DB2 for z/OS Application Developer certification, candidates must pass one test. To gain additional knowledge and skills, and prepare for the tests 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
Familiarity with: z/OS, TSO/ISPF, CICS, Application Server (e.g. WebSphere, etc.), IBM Data Studio, Visual Explain, Eclipse, RDz, z/OS Management Framework, SPUFI, DB2I, WLM, Performance Tuning, DB2 Objects. Proficient with: DB2 for z/OS, IBM Data Server Client, SQL & SQLPL, Stored Procedures

 

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

MCTS Training, MCITP Trainnig

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

 


Continue Reading

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

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


Continue Reading

C2090-305 IBM InfoSphere Information Analyzer v9.1

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

 


Continue Reading

C2090-180 IBM Cognos BI Professional

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

 


Continue Reading

C2090-103 Apache Spark 1.6 Developer

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


Continue Reading

C2090-101 IBM Big Data Engineer

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


Continue Reading

Exam 77-886 SharePoint 2010

Published: June 30, 2011
Languages: English
Audiences: Information workers
Technology: Microsoft Office 2010 suites
Credit toward certification: MOS: SharePoint 2010

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Create and format content (25–30%)
Navigate the SharePoint hierarchy
Use Quick Launch, All Site Content, and breadcrumb trails; add content to Quick Launch; and use content and structure for navigation
Manage lists and libraries
Create lists or libraries, edit properties for new items, enable email notifications on a library or list, provide a shortcut to a mobile site URL, manage document templates, manage list views, create an alert on a list or library, enable rating, add a column, add content validation, manage column properties for various column types, and manage workflows
Manage list items
Create a new item, edit content, delete a list item or a document, version items, publish assets, manage workflows, and upload documents
Manage document sets
Create a document set, and add a document to a document set

Preparation resources
Site navigation overview (SharePoint Server 2010)
Manage lists and libraries with many items
Create and manage Document Sets

Manage SharePoint sites (15–20%)
Manage pages
Create, edit, and delete pages
Administer a site
Create a new site, configure the site structure, configure the Content Organizer, display a list of all user alerts, modify the look and feel of a site, and recover a list, library, document, or list item
Manage Web Parts on a page
Add a Web Part, configure a Web Part, hide or remove a Web Part, and export or import a Web Part
Manage content types
Associate a content type to a list, and extend the columns of a content type
Manage users and groups
Manage user access, groups, and group permissions
Create SharePoint workspace sites
Use document and meeting workspaces
Analyze site activity
View site web analytics, and view detailed reports

Preparation resources
Connect data in Web Parts
Manage membership of SharePoint groups

Participate in user communities (15–20%)
Configure My Site
Add keywords, add colleagues, select a theme, configure the Colleague Tracker Web Part, configure RSS feeds, and configure profiles
Collaborate through My Site
Update profile status, share pictures in My Site, manage personal documents, share documents in My Site, browse the organization hierarchy, and add Web Parts to My Site
Tag and note content
Add notes on the Note Board for a list or a library, add tags for a list or a library, rate an item, use tag clouds, and review tags on My Site

Preparation resources
Build a My Site profile to help people find you
Collaboration site planning (SharePoint Server 2010)
Social tagging overview (SharePoint Server 2010)

Configure and consume site search results (20–25%)
Administer search at the site level
Configure searchable columns, configure list search, and configure site search visibility
Search SharePoint for content
Perform search by using Windows Internet Explorer, Windows Explorer, Office Word 2010 Research Pane, or SharePoint Workspace 2010
View search results
Browse search results, use best bet results, use the refinement panel, use alerts and RSS feeds, and view document previews
Perform advanced searches
Use Boolean operators in searches, use wild cards in searches, run property searches, and run phonetic searches
Search for people
Use People Search, refine people searches, and use advanced searches

Preparation resources
Search for content
Quickly find the resources you need to get your job done
Customize the Search Center site

Integrate SharePoint 2010 services and Microsoft Office 2010 applications (15–20%)
Configure SharePoint 2010 services
Use Form Services, Excel Services, Access Services, and Visio Services
Run Microsoft Office 2010 applications with SharePoint 2010 services
Integrate with Microsoft Outlook, access content with SharePoint Workspace 2010, and integrate with Office Web Apps
Create dashboards
Create a dashboard page; add and configure the Key Performance Indicator (KPI) Web Part, KPI Details Web Part, Chart Web Part, Current User Filter Web Part, and Excel Web Access Web Part; display business data actions; and create KPI lists

Preparation resources
Getting started with Excel Services and Excel Web Access
Synchronize SharePoint 2010 content with Outlook 2010
Creating dashboards by using PerformancePoint Dashboard Designer

QUESTION 1
You need to perform a search for only PowerPoint files that contain the keyword ski.
Which method should you use?

A. Search for ski,and then select PowerPoint in the refinement panel.
B. Search for FileType:pptx, and then select ski In the refinement panel.
C. Click PowerPoint Presentations in the View All Site Content page, and then search for ski.
D. Perform an advanced search for PowerPoint, and then select skifrom the result type drop-down.

Answer: A
Explanation
The refinement options found on the left side of the results page provide drill-down capability filtered on the refinement and the general search results.

 

QUESTION 02
You need to display a list of all Microsoft Word documents in the site collection that contain the keyword ski. Which steps should you take?

A. 1. Navigate to the home page for the site.
2. In the Document web part apply filters to the Type and Name columns.

B. 1. From Site Content and Structure, navigate to Documents tor the site.
2. Apply filters to the Type and Name columns.

C. 1. Navigate to the home page for the site.
2. Search using the search term ski.
3. Refine the search to display Word documents.

D. 1. Navigate to the search page and perform an advanced search
2. Specify ski as the Result
3. Add a property restriction for the type Word.

Answer: C

Click here to view complete Q&A of 77-886 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft Microsoft Certified Specialist 77-886 Certification, Microsoft 77-886 Training at certkingdom.com


Continue Reading

Exam MB6-705 Microsoft Dynamics AX 2012 R3 CU8 Installation and Configuration

Published: January 22, 2015
Languages: English, Chinese (Simplified), Japanese
Audiences: IT professionals
Technology: Microsoft Dynamics AX
Credit toward certification: MCP

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Plan a Microsoft Dynamics AX 2012 installation (15–20%)
Manage organizational hierarchies
Identify legal entities, operating units, and organizational hierarchies; define hierarchy purposes; create organizations and hierarchies; add organizations to a hierarchy
Plan a deployment
Identify Microsoft Dynamics AX 2012 R3 CU8 architectural components, compare minimum versus complete server setup, identify other servers in the environment, identify necessary service accounts for Microsoft Dynamics AX 2012 R3 CU8, identify necessary service accounts for SQL Server services
Manage pre-installation tasks
Pre-installation checklists, plan system topology, identify current hardware and software

Install, configure, and update Microsoft Dynamics AX 2012 R3 CU8 (15–20%)
Install and configure Microsoft Dynamics AX 2012 R3 CU8
Use the Setup Wizard and automatic update installer, validate that prerequisite software is installed, install an environment, troubleshoot installation issues, identify considerations for cloud-hosted environments, configure the Application Object Server (AOS), use the Server Configuration Utility, perform post-installation configuration steps
Configure and initialize the Microsoft Dynamics AX 2012 R3 CU8 environment
Configure clusters, load balancing, and batch servers; specify help system parameters; identify and configure client performance options; specify system service accounts; view and configure licenses; configure system parameters; prepare initialization; synchronize the database; initialize the system
Deploy Microsoft Dynamics AX 2012 R3 CU8 clients
Install a client, create a Group Policy logon script, deploy multiple clients, create a shared configuration file, create a batch file to install clients, understand considerations for installing multiple instances on one computer, identify and describe Microsoft Office add-ins, configure Office add-ins, import data from Microsoft Excel, edit data in Excel, use Office templates and documents
Update Microsoft Dynamics AX 2012 R3 CU8
Describe Lifecycle Services, identify tools for updating the environment, understand and implement slipstream installations

Manage users and security (15–20%)
Understand security concepts and components
Understand the pluggable authentication architecture; identify features that support compliance, auditing, and reporting; implement custom authentication; integrate security with the organizational model; determine proper placement of system components to secure the environment
Manage authentication, users, and Active Directory user groups
Create Active Directory users and groups; describe claims-based authentication; import users from Active Directory; identify role-based security features including process cycles, duties, privileges and permissions; align application security with business needs; assign roles to users roles, duties, and process cycles; add a role; modify a role; override permissions for a role; add duties to a role; remove duties from a role; edit a duty
Manage the extensible data security framework
Control access to past, present, and future records; develop data security policies; identify data security filters; implement record-level security
Secure OLAP data and reports
Identify default Analysis Services roles, assign users to database roles, specify user access to cubes, restrict access to specific members of a dimension, identify report security considerations, control access to data and assemblies, implement role-based security to reports and resources, mitigate injection attacks

Implement services and manage workflows (10–15%)
Describe workflow architecture
Identify workflow types, identify workflow features, identify uses and limitations of workflow types
Implement support for workflows
Specify the workflow execution account; run the Workflow infrastructure configuration wizard; create email notification templates; specify workflow templates; set up work item queue groups, queues, and queue assignments
Create, configure, and monitor workflows
Create a workflow with the graphical workflow editor, configure workflow approval elements, configure workflow decisions, create performance analysis reports, view workflow history

Manage reporting and analytics (10–15%)
Understand reporting components
Identify the reporting architecture, identify services that are used in reporting, identify SQL Server Reporting Services features, describe .rdl files, understand report generation from end-user requests through report rendering
Understand analytics components
Differentiate between online analytical processing (OLAP) and online transaction processing (OLTP) databases; describe cubes; define facts, dimensions, and measures; identify types of cubes; identify default cubes; work with date dimensions; configure the Gregorian calendar
Deploy and configure cubes
Deploy default cubes, connect SQL Server Analysis Server to the Application Object Server (AOS), automate cube processing, configure access to cubes, configure default cubes and analysis servers
Install and configure report servers
Identify reporting components, install prerequisite software, configure report servers, validate settings, set up reports as batches, use Windows PowerShell to deploy reports

Manage the Enterprise Portal (10–15%)
Describe Enterprise Portals
Identify Enterprise Portal components and features including Role Centers, sites, and pages; describe enterprise search architecture; describe the Enterprise Portal security process flow; describe perimeter networks
Install and deploy Enterprise Portals
Identify installation tasks, understand search components, describe relationships between search components, install Enterprise Portal and Role Centers, deploy objects from the Application Object Tree (AOT), deploy changes to the Enterprise Portal, use the AdUpdatePortal utility, manage remote Enterprise Portal deployments
Configure and administer Enterprise Portals
Identify and configure Enterprise Portal parameters, publish images, manage Enterprise Portal websites, configure collaboration workspace settings, configure search, update the search crawler role

Manage Microsoft Dynamics AX 2012 R3 CU8 installations (15–20%)
Manage models
Identify model store components; understand model store uses; identify files related to the model store including .aod, .axmodel, and .xpo files; understand the difference between the current model store architecture and earlier versions of the model store
Manage batch processes
Understand task processing order, create a batch group, create batch jobs, add tasks to a batch job, run batch tasks, view batch job history
Set up and manage email messages and alerts
Integrate Microsoft Dynamics AX with Microsoft Outlook, identify forms that support sending email messages, send email messages to distribution groups, define alert parameters, create alert rules and alerts, use rule templates, process alerts, connect templates with alerts
Monitor Microsoft Dynamics AX 2012 R3 CU8
Describe system monitoring tools including Management Pack, Microsoft Baseline Configuration Analyzer, and Performance Monitor; identify Microsoft Dynamics AX 2012 R3 CU8-specific Performance Monitor counters
Manage infrastructure and deployment components
Install and configure web services on Internet Information Services (IIS), create service groups, configure integration ports and adapters, migrate configuration settings between environments, describe and configure inbound and outbound ports, understand the differences between basic and enhanced ports
Troubleshoot and manage services
Start and stop batch services, debug services, understand Queue Manager message status values, view and manage queued messages, view information about Application Integration Framework (AIF) exceptions

QUESTION 1
You need to create a new service group in Microsoft Dynamics AX 2012 R3. What should you do?

A. Publish all services in the service group to multiple web services description language (WSDL) files.
B. Configure the service group by the using Microsoft Dynamics AX 2012 Server Configuration utility.
C. Associate the service group with an enhanced integration port.
D. Use the Application Object Tree (AOT) to create the service group.

Answer: D


QUESTION 2
Which statement about Microsoft Dynamics AX 2012 security authentication is true?

A. Microsoft Dynamics AX 2012 can use authentication providers other than Active Directory.
B. You can configure Microsoft Dynamics AX 2012 to apply data security before authenticating users.
C. Microsoft Dynamics AX 2012 can only use Active Directory authentication
D. You can configure Microsoft Dynamics AX 2012 to apply security role authorization before authenticating users

Answer: A


QUESTION 3
A batch job is not processing and remains in the waiting status. You need to identify why the batch job is not processing What is the cause?

A. The batch job does not have a batch group assigned.
B. The user that created the batch job does not have permissions to the Batch processing form
C. The batch tasks do not have a batch group assigned.
D. The Application Object Server (AOS) assigned to the batch group is not enabled as a batch server.

Answer: A


QUESTION 4
You need to configure the data sources for Microsoft Office add ins.
What should you do?

A. Specify the data source module and type in the Microsoft Dynamics AX 2012 client.
B. Specify the data source connection string and type in the Microsoft Dynamics AX 2012 client.
C. Specify the data source connection string and type in the Microsoft Dynamics AX 2012 Configuration utility.
D. Specify the data source module and type in the Microsoft Dynamics AX 2012 Configuration utility.

Answer: D

 

Click here to view complete Q&A of MB6-705 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft Microsoft Certified Specialist MB6-705 Certification, Microsoft MB6-705 Training at certkingdom.com


Continue Reading

Exam 70-348 Managing Projects and Portfolios with Microsoft PPM

Published: July 28, 2016
Languages: English
Audiences: IT professionals
Technology: Office 365 Project Portfolio Management
Credit toward certification: MCP

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Create projects and programs
Define strategy
Define business drivers, create multiple driver prioritizations, analyze consistency ratio
Optimize portfolios
Capture project requests and ideas, rate projects against business drivers, determine primary cost constraints, determine resource constraints, set project dependencies, create a portfolio analysis, review and modify prioritizations in an analysis, force projects in and out of analysis, determine hired resources, compare and run simulations for project portfolio selection, add additional constraints
Create a new enterprise project
Create a project and manage workflow, use workflow approvals, import projects through Project Professional, create and manage project schedules using Project Web App, save and check in projects, import projects from Excel
Create programs
Insert sub-projects, create cross-project task dependencies, calculate sub-project summary fields, associate programs to portfolios, associate projects to programs

Plan projects and programs
Define deliverables
Add deliverables, set dependencies on deliverables, synchronize deliverables with project, link related items
Create tasks and a Work Breakdown Structure (WBS)
Create and modify summary tasks and subtasks, rearrange tasks, create milestones, create manually scheduled tasks, set tasks as active or inactive
Schedule the project
Set date constraints, deadlines, dependencies, links, duration equations, effort-driven tasks, and formulas; choose task types; enter duration; set or change the task mode (manual or auto); display warnings and suggestions; use estimated durations and user-controlled summary tasks
Manage resources and teams
Edit resources with Project Web App, edit resources with Project Pro for Office 365, create team resources, create team assignments, add a team task to a task page or timesheet, map resource roles (Portfolio analysis)
Perform resource engagement
Submit, accept, modify, and reject a resource engagement request; build a team for a resource plan; build a resource plan for a project; set resource utilization; use committed versus proposed assignments
Build a project team
Build a Project Team through Project Pro for Office 365 or Project Web App, build a Project Team through Project Web App, replace generic resources, work with proposed assignments
Resolve resource over allocations across projects
Level resources using leveling methods; plan resource allocations using Team Planner, Task usage, Resource Requests page, and Resource Utilization
Build a financial plan
Plan program financial requirements using the resource rate table, cost per use, cost resources

Track projects and programs
Baseline enterprise projects
Set a protected baseline, set a baseline from Project Web App and Project Pro for Office 365, clear and copy a baseline
Select tracking method
Use percent complete, hours per period, actual work remaining, freeform, done, and not done fields
Manage task assignments
Publish assignments, select a status manager, select an assignment owner, set the published values for individual tasks
Update tasks and timesheets
Submit and recall timesheets, insert and remove tasks, reassign tasks, submit updates from My Tasks, submit updates from a mobile app
Approve tasks and timesheets
Accept task updates from tasks or timesheets, view impact of updates on a project, reject updates, approve and reject timesheets, manage delegations
Update the project plan
Reschedule uncompleted work, update cost resources, publish schedule changes, utilize task update history, update schedules with protected user updates, close tasks for updates
Collaborate and communicate projects and programs
Create a project site; add Document Library; add Lists, Calendar, and Folders; modify site layout; create program (master-sub) structure using subsites; add risks and issues

Control, report, manage, and extend the PPM solution

Customize Project Web App views and reports
Create a portfolio report using Excel; create dashboards; copy and edit views; set default views; rename field names; group, filter, and sort views
Advanced Reporting
Load the content pack with Power BI, create reports and dashboards, ask natural language questions, leverage filters, pin results to the dashboard, create views with tiles from multiple datasets and reports, create reports using the out-of-the-box reporting capability
Manage configurable enterprise objects
Create and manage enterprise project templates, define enterprise custom fields, define Project workflows, define enterprise global objects, extend with Office Store apps, add social elements
Implement a security model
Change between SharePoint Security mode and Project Security mode, create users, create and modify security groups and categories, set up Project Site permissions

QUESTION 1
Your company has had several large projects fail due to cost overruns and the lack of available resources. These projects use an enterprise project type named Large IT Project and use a workflow to govern the approval of the projects. The workflow consists of four phases; Initiate, Plan, Execute, and Close.
You need to use Microsoft PPM to compare the value that a new project provides with the cost of implementing the project.
Which three configuration changes should you make? Each correct answer presents part of the solution.

A. Navigate to PWA Settings Edit the Large IT Project project type, and in the Available Project Detail Page section, add the Strategic Impact form.
B. Create a project-level custom field that will be used to enter the total cost of a project
C. Define your company’s strategic drivers, and enter them into the Strategic Impact form.
D. Create a project-level custom field that will be used to enter the value statements of why this project should be undertaken.
E. Define your company’s strategic drivers and enter them into the driver library.
F. In PWA Settings, edit and then save the stage information. In the Available Project Detail Page section, add the Strategic Impact.

Answer: B,C,E


QUESTION 2
You are using Microsoft PPM to manage an e-commerce portal development program. The program is separated into individual projects that represent each area of development.
You have the following requirements:
• All work and progress on individual projects must be reflected in the e-commerce portal development program.
• Each group must be able to manage their own tasks.
You need to set up the e-commerce portal development program and its associated projects in Microsoft PPM.
Where should you add resources?

A. in the e-commerce portal development program project site
B. in the individual project schedules
C. in Build Team, in the e-commerce portal development program schedule
D. in the individual project sites

Answer: C

Click here to view complete Q&A of 70-348 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best Microsoft Microsoft Certified Specialist 70-348 Certification, Microsoft 70-348 Training at certkingdom.com


Continue Reading

C2090-011 IBM SPSS Statistics Level 1 v2

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


Continue Reading

C2070-993 IBM Case Manager V5.2.1 Solution Designer

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


Continue Reading

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

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

 


Continue Reading

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

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


Continue Reading

C2070-987 IBM Content Manager V8.5 Solution Designer

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


Continue Reading

Follow Us

Bookmark and Share


Popular Posts