Thursday, 20 July 2017

C2090-622 IBM Cognos 10 BI Administrator

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

The Cognos 10 BI Administrator 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.

Manage Administrative Content (11%)
Define the steps of creating a data source
Define the steps and options to deploy content from one Cognos 10 environment to another

Manage Report Content (21%)
Identify techniques to organize report content in the portal
Describe techniques to manage report content
Describe the technique to allow users to navigate from one report to another

Manage the Server Environment (51%)
Identify Cognos 10 architecture and components
Describe how Cognos 10 processes requests
Identify installation options and configurations
Identify load balancing options
Describe tasks to implement baseline configuration and performance tuning in Cognos 10
Describe tasks used to manage dispatchers and services
Describe how to implement logging
Identify troubleshooting techniques and resources in the server environment

Manage the Security Environment (17%)
Define how authentication is implemented in Cognos 10
Define how authorization is achieved and implemented in Cognos 10
QUESTION 1
After the installation of IBM Cognos BI, what must be done to ensure that only select users have unrestricted access to Public Folders in IBM Cognos Connection?

A. Add the Anonymous user to the Directory Administrators role.
B. Remove the Everyone group from the Server Administrators role.
C. Remove the Everyone group from the System Administrators role.
D. Remove the All Authenticated Users group from the Directory Administrators role.

Answer: C

QUESTION 2
To administer the contents of namespaces, the administrator must be a member of which predefined role?

A. Report Administrators
B. Server Administrators
C. Directory Administrators
D. System Administrators

Answer: C

QUESTION 3
What permission is needed to view and change the permissions of a IBM Cognos BI object?

A. Read
B. Set Policy
C. Traverse
D. Execute

Answer: B

Posted by at No comments:
Labels: , , , , , , ,

Monday, 17 July 2017

Exam 70-696 Administering System Center Configuration Manager and Intune

Published: January 23, 2015
Languages: English, Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil)
Audiences: IT professionals
Technology: Windows 8.1, Windows Server 2012 R2, Microsoft Intune
Credit toward certification: MCP, MCSE

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.

As of February 2016, this exam was updated to reflect Windows 10 scenarios, requirements, and any related service pack updates. To learn more about these changes and how they affect the skills measured, please download and review the Exam 70-696 change document.

Deploy and manage virtual applications (10–15%)
Prepare virtual applications
Sequence applications, install and configure the sequencer environment, prepare applications for deployment in different environments, configure virtual application interaction and sharing
Manage application virtualization environments
Configure App-V, manage application cache, configure System Tray/SFTTray.exe switches, configure application extensions with virtualized applications, configure application settings using group policies
Deploy and manage RemoteApp
Configure RemoteApp and Desktop Connections settings, configure Group Policy Objects (GPOs) for signed packages, subscribe to the RemoteApp and Desktop Connections feeds, support iOS and Android, configure Remote Desktop web access for RemoteApp distribution, configure and deploy Azure RemoteApp

Deploy and manage desktop and mobile applications (15–20%)
Plan an application distribution strategy
Considerations, including impact on clients due to offline access, deployment infrastructure, and remote locations; choose the appropriate application distribution method; plan to distribute applications to mobile devices, including Windows Phone, iOS, and Android, by using Microsoft Intune; plan to distribute applications to devices including Windows Store Apps
Deploy applications using Microsoft System Center Configuration Manager
Choose and configure deployment types, configure user device affinity, configure requirements, manage the software library and application catalog
Deploy applications using Microsoft Intune
Choose between automatic and manual deployment, configure application deployment policies, add software packages, configure the company portal
Plan for application upgrades
Considerations, including application version co-existence, compatibility issues, and migrating application settings and configurations; re-sequence/redeploy applications
Monitor applications
Monitor offline application usage; monitor real-time sessions; monitor application licensing usage; configure Asset Intelligence in Configuration Manager; monitor applications, using Software Center
Manage content distribution
Manage distribution points, distribution point groups, and Content Library; monitor log files

Plan and implement software updates (15–20%)
Plan and deploy third-party updates
Plan for third-party support, integrate System Center Updates Publisher with Configuration Manager
Deploy software updates by using Configuration Manager and Windows Server Update Services (WSUS)
Configure software update point synchronization to Windows Update, use reports and In Console Monitoring to identify required updates, create update groups, create and monitor deployments, analyze log files, configure Automatic Deployment Rules (ADR), provide secondary access to Windows Update, configure GPO settings
Servicing Windows using Microsoft Intune and the Windows as a Service Model
Use reports and In Console Monitoring to identify required updates, approve or decline updates, configure automatic approval settings, configure deadlines for update installations, deploy Microsoft and non-Microsoft updates, plan for a service branch

Manage compliance and Endpoint Protection settings (15–20%)
Build a Configuration Item (CI)
Create a CI, import a CI, set CI versioning, remediate rules
Create and monitor a baseline
Deploy a baseline, import a configuration pack, build a custom baseline
Configure Endpoint Protection
Create and manage the Endpoint Protection policy; configure definitions within the client policy; export policies; choose which template to use; select exclusions; configure Endpoint Protection, using Microsoft Intune; use In Console Monitoring to monitor client compliance

Manage Configuration Manager clients (15–20%)
Deploy and manage the client agent
Identify deployment methods, manage client agent settings
Manage collections
Plan the collection structure; define rules for collections; customize collection-specific settings, including maintenance windows and power management
Configure and monitor client status
Configure client status settings, use In Console Monitoring to determine client health, configure alert thresholds, configure client health auto-remediation

Manage inventory using Configuration Manager (10–15%)
Manage hardware and software inventory
Extend hardware inventory WMI classes, export and import WMI class settings, configure standardized vendor names, analyze the identified inventory and generate reports
Manage software metering
Create software metering rules, enable or disable auto-generated rules, report software metering results
Create reports
Clone and modify reports, create custom reports, import and export reports, manage asset intelligence, install the asset intelligence sync point, enable the WMI classes, modify categories and labels, analyze reports

Provision and manage mobile devices (10–15%)
Integrate Configuration Manager with the Exchange ActiveSync Connector
Configure and apply ActiveSync policies, view inventory on mobile devices, configure connection to an on-premises or Hosted Exchange server environment, monitor the Exchange connector log file
Manage devices with Microsoft Intune
Provision user accounts, enroll devices, integrate Microsoft Intune with Configuration Manager, view and manage all managed devices, configure the Microsoft Intune subscriptions, configure the Microsoft Intune connector site system role, manage profiles and conditional access by using Microsoft Intune
Manage connection profiles, by using Configuration Manager
Configure Remote Desktop profiles, certificate profiles, email profiles, and Wi-Fi profiles



Question 1
You need to recommend a deployment solution for App6.
What is the best recommendation? More than one answer choice may achieve the goal.
Select the BEST answer.

B. a local installation
C. a RemoteApp program
D. a Microsoft Application Virtualization (App-V) package

Answer: D

Question 2
You need to resolve the Windows update issue.
What should you do?

A. Modify the Group Policy objects (GPOs) in Active Directory.
B. Synchronize software updates from Configuration Manager.
C. Create an automatic deployment rule.
D. Add distribution points to each branch office.

Answer: D



Question 3
You need to ensure that the personal devices that run Windows 8.1 meet the corporate
security policy requirements.
What should you do first?

A. Create a federated trust with Windows Azure Active Directory.
B. Create a federated identity relationship with the Microsoft Federation Gateway.
C. Enroll the device in Windows Intune.
D. Join the devices to the domain by using an offline domain join.

Answer: C



Question 4
You need to make App4 available to all of the users.
What should you do?

A. Package App4 as an MSI package and upload the installer to Windows Intune.
B. Sequence App4 and use streaming delivery.
C. Deploy App4 as a Configuration Manager package.
D. Deploy App4 to a Remote Desktop Session Host (RD Session Host) server.

Answer: D
Posted by at No comments:
Labels: , , , , , , ,

Saturday, 8 July 2017

C2090-612 DB2 10 DBA for z/OS

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically
the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing,
performance, and installation and migration/upgrades specific to the z/OS operating system.

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

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.

Section 1 - Database Design and Implementation (30%)
Design tables and views
Explain the different performance implications of identity column, row ID, and sequence column definitions (applications, utilities), reorder row format, hash access
Design indexes
Design table spaces (choose a DB2 page size, clustering) and determine space attributes
Perform partitioning
Normalize data (E-R model, process model) and translate data model into physical model (denormalize tables)
Implement user-defined integrity rules
Use the appropriate method to alter DB2 objects
Create and Manage XML and LOB objects
Understand impacts of different encoding schemes
Implementing data distribution and replication

Section 2 - Operation and Recovery (28.5%)
Knowledge of commands for normal operational conditions
Knowledge of commands and utility control statements for use in abnormal conditions
Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
Load and unload data into and from the created tables
Reorganize objects when necessary
Monitor the object by collecting statistics
Monitor and manage threads and utilities
Identify and respond to advisory/restrictive statuses on objects
Understanding the significance of checkpoints
Identify and perform problem determination
Perform health checks
Develop backup and recovery scenarios
Describe the special considerations for recovery in a data sharing environment
Understand the concept of disaster recovery
Understanding the concept of virtual storage constraints and limitations

Section 3 - Security and Auditing (9%)
Understanding privileges and authorities
Protect access to DB2 and its objects
Audit DB2 activity and resources and identify primary audit techniques
Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
Create and maintain roles and trusted contexts
Implementing column and row level authorizations

Section 4 - Performance (28.5%)
Plan for performance monitoring by setting up and running monitoring procedures
Analyze performance
Analyze and respond to RUNSTATS statistics analysis
Determine when and how to perform REBIND
Calculate cache requirements for new applications
Understanding and implementing data distribution and replication
Describe DB2 interaction with WLM
Interpret traces and explain the performance impact of different DB2 traces
Identify and respond to critical performance metrics
Review and tune SQL
Dynamic SQL Performance
Design features for performance

Section 5 - Installation and Migration / Upgrade (4%)
Understand the critical ZPARMs
Identify the migration/upgrade modes
Identify & explain Datasharing components

IBM Certified Database Administrator - DB2 10 for z/OS

Job Role Description / Target Audience
The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.

Recommended Prerequisite Skills
Experience as a database administrator on DB2 10 for z/OS DBA and system programming DBA areas
At least two years experience in database administration for the z/OS operating system
Some knowledge and experience in both the application DBA and system programming DBA areas
Knowledge of SQL

Capability to work independently and effectively in complex environments


QUESTION 1
Workload Manager (WLM) manages how many concurrent stored procedures can run in an
address space and the number of concurrent stored procedures in an address space cannot
exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is
correct?

A. NUMTCB parameter must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2
utilities.

Answer: B

Explanation:

QUESTION 2
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite
columns, what is indicated?

A. The next sort step will perform two sorts.
B. There are multiple sorts in the plan step.
C. One sort in the plan step will accomplish two tasks.
D. Two sorts are performed on the new table of a star join.

Answer: C

Explanation:

QUESTION 3
What IBM provided stored procedure will access DB2 real time statistics tables?

A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR

Answer: C

Explanation:

QUESTION 4
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which
information is part of the DSN_STATEMENT_CACHE_TABLE?

A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.

Answer: D

Explanation:

QUESTION 5
Which two of the following DB2 performance features will ignore clustering in favor of faster insert
performance? (Choose two.)

A. Append
B. Inline LOBs
C. Member cluster
D. Volatile table
E. Include columns

Answer: A,C

Explanation:
Posted by at No comments:
Labels: , , , , , , ,
Subscribe to: Posts (Atom)