Tuesday, 31 October 2017

SY0-501 CompTIA Security+ (501)

Exam Details
Exam Codes SY0-401 SY0-501
Launch Date May 1, 2014 October ​4, 2017
Exam Description The CompTIA Security+ exam will certify the successful candidate has the knowledge and skills required to install and configure systems to secure applications, networks, and devices; perform threat analysis and respond with appropriate mitigation techniques; participate in risk mitigation activities; and operate with an awareness of applicable policies, laws, and regulations. The successful candidate will perform these tasks to support the principles of confidentiality, integrity, and availability.
Number of Questions Maximum of 90 questions
Type of Questions Multiple choice and performance-based
Length of Test 90 minutes
​Passing Score 750 (on a scale of 100-900)
Recommended Experience CompTIA Network+ and two years of experience in IT administration with a security focus
Languages English, Japanese, Portuguese and Simplified Chinese. English (Japanese, Portuguese and Simplified Chinese estimated Q2 2018)
Retirement
English retirement: July 31, 2018;
Japanese, Portuguese and Simplified Chinese: December 15, 2018
Usually three years after launch
CompTIA Security+ is the certification globally trusted to validate foundational, vendor-neutral IT security knowledge and skills. As a benchmark for best practices in IT security, this certification covers the essential principles for network security and risk management – making it an important stepping stone of an IT security career.
Jobs that use Security+
Security Specialist/Administrator
Security ​Consultant
Security or ​Systems ​Administrator
Network ​Administrator
Companies that use CompTIA Security+ include:
Apple
Dell
HP
IBM
Intel
U.S. Department of Defense
4 Steps to a Cybersecurity Career
Want more CompTIA Security+ information?
Overview
IT security is paramount to organizations as cloud computing and mobile devices have changed the way we do business. With the massive amounts of data transmitted and stored on networks throughout the world, it’s essential to have effective security practices in place. That’s where CompTIA Security+ comes in. Get the Security+ certification to show that you have the skills to secure a network and deter hackers and you’re ready for the job.
Security+ is government approved
CompTIA Security+ meets the ISO 17024 standard and is approved by U.S. Department of Defense to fulfill Directive 8570.01-M requirements. It is compliant with government regulations under the Federal Information Security Management Act (FISMA).
Security+ is globally recognized
CompTIA Security+ is a globally recognized credential with certified professionals working in over 147 countries throughout the world.
Security+ provides substantial earnings potential
According to the Bureau of Labor Statistics, Security Specialists, Administrators and Managers earn over $86,000 per year.
Security+ is industry supported
Security+ is developed and maintained by leading IT experts. Content for the exams stems from a combination of industry-wide survey feedback and contributions from our team of subject matter experts. Learn more about the people behind the CompTIA Security+ Advisory Committee.
Certkingdom.com is CompTIA’s intelligent online learning tool to help you learn for your Security+ exam. It can verify what you already know and fill in knowledge where you need it. It’s a great addition to your learning prep and will be your guide on your path to master the Security+ curriculum.
Training Materials
There’s a wealth of training materials available that match your learning needs and learning style. Whether you are studying on your own, or in a classroom environment, we recommend CompTIA Authorized Quality Curriculum (CAQC) training materials that will help you get ready for your certification exam and pass the test.
For all training options, visit our training overview.

Instructor-Led Training
Instructor-led training provides a comfortable teaching environment with instructors that are familiar with the certification process and can help you master your certification exam. Find your instructor now.
Ready for the Test?
When you’ve completed your training and you know you can take your certification exam with confidence, head over to the CompTIA Marketplace and purchase your exam voucher that you will need to sign up for the test.
Once you’ve purchased your voucher, you can find a testing location and schedule your test.
Renewal
Keep your certification up to date with CompTIA’s Continuing Education (CE) program. It’s designed to be a continued validation of your expertise and a tool to expand your skillset. It’s also the ace up your sleeve when you’re ready to take the next step in your career.
Get the most out of your certification
Information technology is an incredibly dynamic field, creating new opportunities and challenges every day. Participating in our Continuing Education program will enable you to stay current with new and evolving technologies and remain a sought-after IT and security expert.
The CompTIA Continuing Education program
Your CompTIA Security+ certification is good for three years from the day of your exam. The CE program allows you to extend your certification in three-year intervals through activities and training that relate to the content of your certification. Like Security+ itself, CompTIA Security+ ce also carries globally-recognized ISO/ANSI accreditation status.
It’s easy to renew
You can participate in a number of activities and training programs, including higher certifications, to renew your CompTIA Security+ certification. Collect at least 50 Continuing Education Units (CEUs) in three years, upload them to your certification account, and Security+ will automatically renew.

QUESTION 1
A security analyst wishes to increase the security of an FTP server. Currently, all trails to the FTP server is unencrypted. Users connecting to the FTP server use a variety of modem FTP client software. The security analyst wants to keep the same port and protocol, while also still allowing unencrypted connections. Which of the following would BEST accomplish these goals?
A. Require the SFTP protocol to connect to the file server.
B. Use implicit TLS on the FTP server.
C. Use explicit FTPS for the connections.
D. Use SSH tunneling to encrypt the FTP traffic.
Answer: B

QUESTION 2
A company has three divisions, each with its own networks and services. The company decides to make its secure web portal accessible to all employees utilizing their existing usernames and passwords, The security administrator has elected to use SAML to support authentication. In this scenario, which of the following will occur when users try to authenticate to the portal? (Select TWO)
A. B. The portal will function as an identity provider and issue an authentication assertion
B. C. The portal will request an authentication ticket from each network that is transitively trusted
C. D. The back-end networks will function as an identity provider and issue an authentication assertion
D. The back-end networks will request authentication tickets from the portal, which will act as the third-party service provider authentication store
E. F. The back-end networks will verify the assertion token issued by the portal functioning as the identity provider
Answer: C

QUESTION 3
Which of the following would a security specialist be able to determine upon examination of a server’s certificate?
A. CA public key
B. Server private key
C. CSR
D. OID
Answer: B

Thursday, 24 August 2017

C5050-300 Foundations of IBM DevOps V1

Test information:
Number of questions: 61
Time allowed in minutes: 90
Required passing score: 70%
Languages: English, Japanese

Related certifications:
IBM Certified Solution Advisor - DevOps V1

Section 1 - DevOps Principles
Define DevOps
Summarize different development approaches
Explain and identify delivery pipelines
Explain lean principles
Explain DevOps practices
Describe Collaborative Development
Describe Continuous Integration
Describe Continuous Delivery
Describe Continuous Deployment
Describe Continuous Availability / Service Management / Monitoring
Describe Continuous Security / Security for DevOps
Explain Shift-Left Test /Continuous Test
Explain Shift Left Ops
Explain Multi-speed IT
Explain Continuous Feedback
Explain the implications of the �12 Factor app� design principles for DevOps
ITIL and DevOps

Section 2 - Adopting DevOps
Describe business and IT drivers of DevOps
Explain the barriers to adoption of DevOps
Explain how to build a roadmap for DevOps adoption
Explain how to adopt DevOps in Multi-speed IT environment
Explain other continuous improvement approaches
Illustrate the cultural & organizational differences when transforming from traditional to DevOps processes
Explain the benefits of Design Thinking for DevOps process adoption

Section 3 - IBM DevOps Reference Architecture & Methods
Describe IBM DevOps Reference Architecture pattern
Explain the IBM point of view on DevOps
Explain DevOps for Microservices
Explain DevOps for Cloud Native
Explain DevOps for Cloud Ready
Explain Cloud Service Management Operations
Describe the IBM Bluemix Garage Method
Define and identify the common components of a DevOps Tool chain
Describe the key architectural decisions made to adopt DevOps
Describe the concepts of Software Defined Environments

Section 4 - Open Standards, Open Source & Other Common Components of DevOps
Identify tools for Build & Deploy
Identify other common tools and their uses
Describe common container technology
Explain the applicability of open standards for DevOps

Section 5 - IBM Solution for DevOps
Describe the IBM solutions for the THINK phase in DevOps
Describe the IBM solutions for the CODE phase in DevOps
Describe the IBM solutions for the DELIVER phase in DevOps
Describe the IBM solutions for the RUN phase in DevOps
Describe the IBM solutions for the MANAGE phase in DevOps
Describe the IBM solutions for the LEARN phase in DevOps
Describe the IBM solutions for the CULTURE phase in DevOps
Describe the IBM solutions for Security in DevOps
Describe the IBM solutions for transformation and connectivity in DevOps
IBM Certified Solution Advisor - DevOps V1

Job Role Description / Target Audience
An IBM Certified Solution Advisor - DevOps V1 is a person who can clearly explain the benefits and underlying concepts of DevOps, and has practical experience of implementing DevOps processes and solutions for clients. They can advise stakeholders on how to adopt DevOps, how to overcome barriers, and how to realize the business benefits of DevOps. They can also demonstrate how the leading industry, Open and IBM solution offerings can help customers realize these benefits.

Key areas of competency include:
Clearly articulate the benefits of DevOps for driving business agility and continuous innovation.
Advise stakeholders on how to remove barriers to the adoption of DevOps, and implement organizational change and continual process improvement.
Have a deep working experience of Continuous delivery (integration, delivery, collaboration, innovation) practices.
Experience of application development lifecycle, operational methods, SCM, version control and common tooling for cloud-ready and cloud-native application development.
Working knowledge of development, test automation and virtualization, deployment, and operational best practices.
Understand the IBM DevOps reference architecture patterns, and can apply them to DevOps solutions.
Recommend the best approach, tooling and consumption models (on premises / public / SaaS) across the IBM solution portfolio (and leading open toolchain components).

Recommended Prerequisite Skills

The following qualifications are requirements for success:
Advanced knowledge of DevOps principles, practices, and development approaches
Advanced experience of Continuous delivery (integration, delivery, collaboration, innovation) practices.
Working knowledge of the IBM DevOps Reference Architecture and associated adoption patterns.
Working knowledge of tooling and consumption models (on-premises / public / SaaS) from the IBM DevOps portfolio.
Working knowledge of the IBM DevOps solution offerings.

Requirements
This certification requires 1 test(s).



QUESTION 1
Which type of tests are designed to verify that security features such as authentication and logout work as expected?

A. build verification
B. network vulnerability
C. functional security
D. synthetic user

Answer: B


QUESTION 2
When long lived source control management (SCM) branches are merged, significant amounts of network can be required to resolve code conflicts. Which DevOps practice addresses this problem?

A. continuous integration
B. test-driven development
C. A/B testing
D. continuous deployment

Answer: B


QUESTION 3
What are two key metrics for cloud native applications? (Choose two.)

A. performance
B. stability
C. mean time between failures (MTBF)
D. first failure data capture (FFDC)
E. speed of change

Answer: A,E

Explanation: References:


QUESTION 4
Which volume of the Information Technology Infrastructure Library (ITIL) should be an integral part of every stage of the ITIL service management framework?

A. ITILService Design
B. ITIL Service Operations
C. ITIL Continual Service Improvement
D. ITIL Service Strategy

Answer: C

Explanation: References:


QUESTION 5
How does adopting DevOps help improve insight into the real value of applications?

A. by using mean time between failure (MTBF) metrics
B. by using customer feedback
C. by using usage statistics for cloud native applications
D. by using analytical analysis for return on investment (ROI) calculations

Answer: A


Friday, 11 August 2017

C2150-210 IBM Security Identity Governance Fundamentals V5.1

Test information:
Number of questions: 47
Time allowed in minutes: 90
Required passing score: 58%
Languages: English, French, Latin American Spanish, Portuguese (Brazil)

Related certifications:
IBM Certified Associate - Security Identity Governance V5.1

Certifications (13%)
Define certification dataset and campaign�
Define signoff options
Define supervisor and reviewer activities
Define notification configuration�

Role Management (9%)
Define role structure
Publish role and define visibility
Consolidate role

Role Mining (15%)
Load Access Optimizer data
Create Role Mining session
Analyse statistics charts to identify candidate role
Analyse assignment map to identify candidate role
Analyse entitlement and user coverage to identify candidate role�
Leverage candidate role in IAG warehouse

Role Maintanence and Health (6%)
Identify unused roles
Retire role
Setup Role Certification campaign

Reporting (13%)
Identify standard report
Customize report layout
Configure scope visibility
customize query and add filter criteria
configure authorization to report for selected users

Separation of Duties (17%)
Define Business Activities
Define SoD Policy
Define Technical Transformation
Analyse Risk Violations
Define Mitigation Controls
Setup Risk Violation Certification Campaign

Installation (9%)
Prepare database server and schema
Configure virtual machine
Install virtual appliance
Configure database connections

Enterprise Integration (4%)
Identity ISIM and ISIG integration options
Identify supported connectors

ISIG Authorization Model (9%)
Define functional authorization for ISIG users
Restrict the data portion for a functional authorization
Define and use Attribute Groups

Access Request Management (9%)
Identify common process activities
Identify UI customization options
Review access request status

IBM Certified Associate - Security Identity Governance V5.1
Job Role Description / Target Audience
An IBM Certified Associate - Security Identity Governance V5.1 is an individual with entry level knowledge and experience with IBM Security Identity Governance V5.1 . This individual is knowledgeable about the fundamental concepts of IBM Security Identity Governance V5.1 through hands on experience. The associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day use of IBM Security Identity Governance V5.1 . The individual should be able to complete these tasks with little to not assistance from documentation, peers or support.

Key Areas of Competency
IBM Security Identity Governance UI from an admin and end user perspective
Identify the key ISIG features
Understand the benefits of using ISIG for identity and access governance.

Recommended Prerequisite Skills
Working end user knowledge of IBM Security Identity Governance V5.1
Understand Identity Governance, Risk and Compliance (GRC) infrastructure such as audit, reporting, access
review, and certification.
Experience with role modeling and role mining
Experience with role healthcare and maintenance.
Understand the ISIG entitlement model and how to leverage it to build target application authorization models.
Understand the ISIG authorization model and access governance responsibilities.
Experience performing an RFP in the access governance space.
Understand business activity-based separation of duties modeling for better business and auditor readability.
Understand typical functionality of access request workflows such as manager approvals.

Requirements
This certification requires 1 test(s).


Tuesday, 8 August 2017

70-773 Analyzing Big Data with Microsoft R

Exam 70-773
Analyzing Big Data with Microsoft R


Published: January 3, 2017
Languages: English
Audiences: Data scientists
Technology Microsoft R Server, SQL R Services
Credit toward certification: MCP, MCSE

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.

Read and explore big data
Read data with R Server
Read supported data file formats, such as text files, SAS, and SPSS; convert data to XDF format; identify trade-offs between XDF and flat text files; read data through Open Database Connectivity (ODBC) data sources; read in files from other file systems; use an internal data frame as a data source; process data from sources that cannot be read natively by R Server
Summarize data
Compute crosstabs and univariate statistics, choose when to use rxCrossTabs versus rxCube, integrate with open source technologies by using packages such as dplyrXdf, use group by functionality, create complex formulas to perform multiple tasks in one pass through the data, extract quantiles by using rxQuantile
Visualize data
Visualize in-memory data with base plotting functions and ggplot2; create custom visualizations with rxSummary and rxCube; visualize data with rxHistogram and rxLinePlot, including faceted plots

Process big data
Process data with rxDataStep
Subset rows of data, modify and create columns by using the Transforms argument, choose when to use on-the-fly transformations versus in-data transform trade-offs, handle missing values through filtering or replacement, generate a data frame or an XDF file, process dates (POSIXct, POSIXlt)
Perform complex transforms that use transform functions
Define a transform function; reshape data by using a transform function; use open source packages, such as lubridate; pass in values by using transformVars and transformEnvir; use internal .rx variables and functions for tasks, including cross-chunk communication
Manage data sets
Sort data in various orders, such as ascending and descending; use rxSort deduplication to remove duplicate values; merge data sources using rxMerge(); merge options and types; identify when alternatives to rxSort and rxMerge should be used
Process text using RML packages
Create features using RML functions, such as featurizeText(); create indicator variables and arrays using RML functions, such as categorical() and categoricalHash(); perform feature selection using RML functions

Build predictive models with ScaleR
Estimate linear models
Use rxLinMod, rxGlm, and rxLogit to estimate linear models; set the family for a generalized linear model by using functions such as rxTweedie; process data on the fly by using the appropriate arguments and functions, such as the F function and Transforms argument; weight observations through frequency or probability weights; choose between different types of automatic variable selections, such as greedy searches, repeated scoring, and byproduct of training; identify the impact of missing values during automatic variable selection
Build and use partitioning models
Use rxDTree, rxDForest, and rxBTrees to build partitioning models; adjust the weighting of false positives and misses by using loss; select parameters that affect bias and variance, such as pruning, learning rate, and tree depth; use as.rpart to interact with open source ecosystems
Generate predictions and residuals
Use rxPredict to generate predictions; perform parallel scoring using rxExec; generate different types of predictions, such as link and response scores for GLM, response, prob, and vote for rxDForest; generate different types of residuals, such as Usual, Pearson, and DBM
Evaluate models and tuning parameters
Summarize estimated models; run arbitrary code out of process, such as parallel parameter tuning by using rxExec; evaluate tree models by using RevoTreeView and rxVarImpPlot; calculate model evaluation metrics by using built-in functions; calculate model evaluation metrics and visualizations by using custom code, such as mean absolute percentage error and precision recall curves
Create additional models using RML packages
Build and use a One-Class Support Vector Machine, build and use linear and logistic regressions that use L1 and L2 regularization, build and use a decision tree by using FastTree, use FastTree as a recommender with ranking loss (NDCG), build and use a simple three-layer feed-forward neural network

Use R Server in different environments
Use different compute contexts to run R Server effectively
Change the compute context (rxHadoopMR, rxSpark, rxLocalseq, and rxLocalParallel); identify which compute context to use for different tasks; use different data source objects, depending on the context (RxOdbcData and RxTextData); identify and use appropriate data sources for different data sources and compute contexts (HDFS and SQL Server); debug processes across different compute contexts; identify use cases for RevoPemaR
Optimize tasks by using local compute contexts
Identify and execute tasks that can be run only in the local compute context, identify tasks that are more efficient to run in the local compute context, choose between rxLocalseq and rxLocalParallel, profile across different compute contexts
Perform in-database analytics by using SQL Server
Choose when to perform in-database versus out-of-database computations, identify limitations of in-database computations, use in-database versus out-of-database compute contexts appropriately, use stored procedures for data processing steps, serialize objects and write back to binary fields in a table, write tables, configure R to optimize SQL Server ( chunksize, numtasks, and computecontext), effectively communicate performance properties to SQL administrators and architects (SQL Server Profiler)
Implement analysis workflows in the Hadoop ecosystem and Spark
Use appropriate R Server functions in Spark; integrate with Hive, Pig, and Hadoop MapReduce; integrate with the Spark ecosystem of tools, such as SparklyR and SparkR; profile and tune across different compute contexts; use doRSR for parallelizing code that was written using open source foreach
Deploy predictive models to SQL Server and Azure Machine Learning
Deploy predictive models to SQL Server as a stored procedure, deploy an arbitrary function to Azure Machine Learning by using the AzureML R package, identify when to use DeployR

Question No : 1

Note: This question Is part of a series of questions that use the same or similar answer choice. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided In a question apply only to that question. You need to evaluate the significance of coefficient that are produced by using a model that
was estimated already.

Which function should you use?

A. rxPredict
B. rxLogit
C. Summary
D. rxLinMod
E. rxTweedie
F. stepAic
G. rxTransform
H. rxDataStep

Answer: D

Explanation: https://docs.microsoft.com/en-us/r-server/r/how-to-revoscaler-linear-model

Question No : 2
You need to build a model that looks at the probability of an outcome. You must regulate between L1 and L2. Which classification method should you use?

A. Two-Class Neural Network
B. Two-Class Support Vector Machine
C. Two-Class Decision Forest
D. Two-Class Logistic Regression

Answer: A

Wednesday, 2 August 2017

C2090-730 DB2 9 Family Fundamentals

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

Related certifications:
IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows
IBM Certified Database Administrator - DB2 9.7 for Linux, Unix and Windows
IBM Certified Advanced Deployment Professional - Tivoli Service Management Solutions 2008
IBM Certified Advanced Database Administrator - DB2 9.7 for Linux, UNIX and Windows
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS
IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows
IBM Certified Solution Designer -- DB2 Business Intelligence V8
IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Solution Developer - DB2 9.5 SQL Procedure Developer
IBM Certified Solution Developer - DB2 9.7 SQL Procedure
IBM Certified Application Developer - DB2 9
IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows
IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1
IBM Certified System Administrator - DB2 9 for z/OS
IBM Certified System Administrator - DB2 10 for z/OS

This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 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 how DB2 9 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 - Planning (14%)
Knowledge of restricting data access
Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed +space - i.e., control center, configuration advisor, configuration assistant, command line processor)
Knowledge database workloads (OLTP vs warehousing)
Knowledge of non-relational data concepts (extenders)
Knowledge of XML data implications (non-shreading)

Section 2 - Security (11%)
Knowledge of DB2 products (client, server, etc.)
Knowledge of different privileges and authorities
Knowledge of encryption options (data and network)
Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)

Section 3 - Working with Databases and Database Objects (17%)
Ability to identify and connect to DB2 servers and databases
Ability to identify DB2 objects
Knowledge of basic characteristics and properties of DB2 objects
Given a DDL SQL statement, knowledge to identify results (ability to create objects)

Section 4 - Working with DB2 Data using SQL (23.5%)
Given a DML SQL statement, knowledge to identify results
Ability to use SQL to SELECT data from tables
Ability to use SQL to SORT or GROUP data
Ability to use SQL to UPDATE, DELETE, or INSERT data
Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
Ability to call a procedure or invoke a user defined function
Given an XQuery statement, knowledge to identify results

Section 5 - Working with DB2 Tables, Views and Indexes (23.5%)
Ability to demonstrate usage of DB2 data types
Given a situation, ability to create table
Knowledge to identify when referential integrity should be used
Knowledge to identify methods of data constraint
Knowledge to identify characteristics of a table, view or index
Knowledge to identify when triggers should be used
Knowledge of schemas
Knowledge of data type options for storing XML data

Section 6 - Data Concurrency (11%)
Knowledge to identify factors that influence locking
Ability to list objects on which locks can be obtained
Knowledge to identify characteristics of DB2 locks
Given a situation, knowledge to identify the isolation levels that should be used

QUESTION 1
Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2CPUs?

A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition

Answer: B


QUESTION 2
Which of the following products is allowed to access other DB2 servers, but cannot accept requests from otherremote clients?

A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition

Answer: A


QUESTION 3
A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

A. DB2 Connect Enterprise Edition
B. DB2 Workgroup Server Edition
C. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition
D. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Answer: D


QUESTION 4
Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

A. DB2 Express-C
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Enterprise Server Edition

Answer: D


QUESTION 5
Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

A. DB2 Enterprise Server Edition
B. DB2 Personal Developer's Edition
C. DB2 UniversalDeveloper's Edition
D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Answer: C

Saturday, 29 July 2017

C2090-645 IBM Cognos 10 BI Multidimensional Author

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

Related certifications:
IBM Certified Designer - Cognos 10 BI Multidimensional Reports
IBM Certified Solution Expert - Cognos BI

The Cognos 10 BI Multidimensional Author 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, and a detailed review of product documentation.

Dimensional Data Components (28%)
Distinguish between relational, DMR, and dimensional data sources
Identify dimensional data items and expressions
Define multidimensional data structure components
Describe the importance of report context
Identify the default measure of a report
Describe default members and their purpose
Describe what a MUN is and identify the impact of using the wrong MUN
Describe what a set is
Describe what a tuple is

Focus Reports (14%)
Distinguish between dimensional and relational filtering styles
Identify techniques to focus data using the dimensional style
Interpret data that is focused based on members
Interpret data that is filtered based on measure values
Describe the purpose of a slicer

Drilling in Reports (14%)
Describe default drill-down behavior
Describe default drill-up behavior
Describe cases for advanced drilling configuration
Appraise reports generated with calculations that are preserved during drilling
Describe how member sets work

Drill-through Access (8%)
Identify supported drill-through data item combinations
Set-up drill-through access
Describe a conformed dimension

Calculations and Dimensional Functions (36%)
Describe the use of arithmetic operations in queries
Analyze the use of dimensional functions in queries
Examine coercion
Apply prompts to focus reports
Compose complex expressions that combine and reuse existing expressions

QUESTION 1
To display all individual campaigns in a crosstab report, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])". Which statement is true about the method that was used?

A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.
B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.
C. The report author should not have used the method chosen, as the first method is best
in this situation.
D. To be accurate, the report author should avoid using a set expression.

Answer: B


QUESTION 2
Which of the following statements is correct about the order function?

A. The currentMeasure function must be used with the order function as the sort by criterion.
B. It arranges members of all sets in the report by ascending or descending values.
C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
D. It arranges members of a set alphabetically by ascending or descending captions.

Answer: C

QUESTION 3
A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?

A. Using these dimensional methods will not work with an OLAP data source.
B. The mapped string values will not pass through to the target report.
C. There is nothing wrong with this approach.
D. Mixing dimensional styles and relational styles in a single query can create unexpected results.

Answer: D

QUESTION 4
When must a report author use the caption function?

A. As the first parameter of the roleValue function.
B. To return the display name for the specified business key.
C. To see the string display name for the specified element.
D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.

Answer: D

QUESTION 5
Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?

A. This is not possible because a prompt must always be populated with all members of a level.
B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
C. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?
D. Create a tree prompt, and populate it using an expression on the [Northern Europe]
member to retrieve its children at the country level.

Answer: B

Monday, 24 July 2017

C2090-632 IBM Cognos 10 BI Metadata Model Developer

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

Related certifications:
IBM Certified Advanced Developer - Risk Information Governance for BI
IBM Certified Solution Expert - Cognos BI
IBM Certified Developer - Cognos 10 BI Metadata Models
IBM Certified Solution Expert - Cognos 8 BI Migration

The Cognos 10 BI Metadata Model Developer 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, and a detailed review of product documentation.

Common Data Structures and Traps (16%)
Identify Common Data Structures
Identify different data traps

Framework Manager Basics (16%)
Identify the different model types that can be published from Framework Manager
Define the purpose of Framework Manager
Create a project
Identify recommendations for preparing metadata

Predictable Results (16%)
Identify recommendations to achieve predictable results
Describe why and how to implement a time dimension
Identify techniques for creating intuitive business views

Security (9%)
Describe the Cognos 10 security environment
Describe how to implement security on models and packages

Project Management and Maintenance (5%)
Identify techniques for managing Framework Manager projects
Identify techniques for managing Framework Manager packages

Query Subject Types (9%)
Identify different query subject types and uses

Generated SQL and Complex Queries (17%)
Identify SQL Generation in Complex Queries
Identify aggregated result sets for multi-fact queries
Identify aggregations in Report Studio SQL

Optimization and Tuning (5%)
Describe the performance impact of queries

Advanced Techniques (7%)
Describe how to leverage user defined functions
Describe how to resolve a recursive relationship
Identify considerations for drill-through values and managing MUNs

QUESTION 1
Which of the following is correct regarding the Cognos 10 security environment?

A. Cognos 10 must be configured to use only one authentication provider at a time.
B. To perform authentication of users, a connection to the Cognos namespace must be defined.
C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
D. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.

Answer: C


QUESTION 2
In Framework Manager, which of the following statements is correct when working with a multi-lingual project?

A. The design language can be changed at any point.
B. A project language cannot be deleted once defined in Framework Manager.
C. A language must be added to the project before it can be published with a package.
D. When a new language is added to a project, all locales for that language are added as well.

Answer: C


QUESTION 3
The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

A. Query items.
B. Data sources.
C. Relationships.
D. Parameter maps.

Answer: A


QUESTION 4
What must a modeler consider when modeling for drill-through between multiple data sources?

A. Drill-through values must be cast.
B. Drill-through values must be conformed.
C. Drill-through values must be consolidated.
D. Drill-through values must be identifiers.

Answer: B