Monday, 30 January 2017

C2020-004 IBM Cognos ICM Essentials

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

Related certifications:
IBM Certified Specialist - Cognos ICM Essentials

This IBM Cognos ICM Essentials exam for business partners covers fundamental knowledge necessary to implement the IBM Cognos ICM product according to design specifications that support variable incentive compensation processes. In preparation for the exam, see the recommended training and product documentation under the Test Preparation tab.

Calculations and Components (27%)
Identify the process for building calculations
Describe the use of Components
Identify basic standard build framework concepts
Describe how calculations interact with calendars

Model Administration (13%)
Identify Migration Tool concepts
Describe Scheduler concepts
Describe the use of Model Optimize
Describe how to configure admin client access

Data Modeling (17%)
Identify the table types and their purpose
Identify date effectiveness design concepts

Presenter and Workflow Manager (22%)
Identify the process for creating Data Stores
Describe how to design layout tables
Describe how to create a Workflow
Identify Presenter concepts

Installation and Configuration Concepts (10%)
Identify the different modules of the application
Identify the process how to configure admin client security
Identify the process how to configure Web client security

Portal Access Security (11%)
Describe how to configure portal access groups
Describe how to configure portal access trees
Identify the process how to configure Web tabs

QUESTION 1
When using an effective dated table as a source for a calculation, which two statements are true?
(Choose two.)

A. Join start and end date of the effective dated table to a single date.
B. Join the calendar table to the effective dated table.
C. Join on both effective dates.
D. Join an effective dated table to another effective dated table (not Time).

Answer: A,C

Explanation:


QUESTION 2
What is the impact of locking model calendars?

A. It affects calculations partitioned by the same calendar.
B. It has no effect on any calculations in the model.
C. It affects every calculation in the model regardless of calendars used.
D. It only affects calculations related to payout.

Answer: A

Explanation:


QUESTION 3
How does information from the Web client reach the database server?

A. from the Admin client
B. from the Web Application server
C. from the CognosICMService
D. from the Web Application server to the CognosICMService

Answer: B

Explanation:


QUESTION 4
Which table property can be changed after it is saved?

A. name
B. description
C. primary key
D. type

Answer: B

Explanation:

Thursday, 26 January 2017

C2020-002 IBM Algo Financial Modeler Developer Fundamentals

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

Related certifications:
IBM Certified Associate Developer - Algo Financial Modeler

Algo Financial Modeler (AFM) Concepts (37%)
Identify the approach to assumptions and data
Identify the role of modules in AFM
Identify the role of portfolio variables in AFM
Identify the role of Events in AFM
Identify the role of Layers in AFM
Identify the purpose of rollback variables
Describe how to build an AFM model

Algo Financial Modeler (AFM) Standard Code (25%)
Identify the best process for using Standard Code

Algo Financial Modeler (AFM) Troubleshooting (25%)
Describe generator errors and their resolution
Describe runtime errors and their resolution
Describe different troubleshooting techniques

Algo Financial Modeler (AFM) Outputs (13%)
Identify the types of output
Describe the use of output

QUESTION 1
In a model, to what would you attach an assumption set?

A. A data view
B. A module
C. A layer
D. A projection process

Answer: C

Explanation:


QUESTION 2
In which situation do we need to specify the initial value for portfolio variables?

A. When portfolio variables are referenced with a .index suffix in the formulae for step or event
variables in a program.
B. When portfolio variables are referenced with a .end suffix in the formulae for step or event
variables in a program.
C. When portfolio variables are referenced with a .prev suffix in the formulae for step or event
variables in a program.
D. When portfolio variables are referenced with a .curr suffix in the formulae for step or event
variables in a program.

Answer: C

Explanation:


QUESTION 3
Which statement is true regarding Rollback variables?

A. It is always required to specify an initial value for a Rollback variable.
B. An initial value of a Rollback variable is specified using the reset formula.
C. If the Initial value property is blank, a Rollback variable will have an initial value of 0.
D. A Rollback variable is defined in the Events page.

Answer: C

Explanation:


QUESTION 4
A colleague asks you to customize an Excel worksheet to read in values from an Algo Einancial
Modeler workspace. In each cell you need to return a value from output produced by AFM.
Which function would you use?

A. AFMWorkspaceInfo
B. AEMModelInfo
C. AEMOutput
D. AEMVariableInfo

Answer: C

Explanation:

Monday, 23 January 2017

C2010-597 IBM TRIRIGA Application Platform V3.2.1 Application Development

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

Related certifications:
IBM Certified Application Development - TRIRIGA Application Platform V3.2.1

Below are the high level objectives for this exam. We recommend reviewing the Study Guide for more detailed information on the test objectives to provide a better idea of the content which will be covered on the exam.

Section 1:Application Building
Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, create a module using the Data Modeler tool so that business objects can now be created under the new module.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a module is created, create a business object by using the Data Modeler tool so that fields, data sections, forms, and a state family can now be created for the new business object.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object exists, find/add a field to the business object by using the Data Modeler tool so that the field is available in the creation and modification of records of that business object type.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, create a list by using the Lists tool so that a new list is now available for selection by a list field.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, create a custom field in Business Object so that data is accepted in accordance with stated requirements.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, a module is created, a business object is created, and there are fields defined for this business object, create a publish name using the Data Modeler tool so that the business object may be published successfully.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object has been created, create a state family in Data Modeler so that the records of that business object type conform to a lifecycle consistent with business requirements.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, an applicable module, business object, and state transition saved; create a new sub action to perform the specified logic when the state transition is triggered.

Given the IBM TRIRIGA application and platform are installed and the user has an application builder license, create an association between two business objects so that an association has been created between two business objects and may be used during the creation of record level associations.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, a module is created, a business object is created, create a smart section by using the Data Modeler tool so that the business object may reference data from an associated business object.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object has been created, and a published name defined, and the business object remains in a Created or a Revision In Progress state, publish the business object in Data Modeler so that forms and subsequently records, may be created and so that records can reflect any changes made in the newly published version of the business object.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license a new classification exists and a root node record and children records are able to be created with it, create a classification so that a root node record and children records are able to be created with the classification.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license and an association has been created, add a Locator field so that the field creates an association to that record.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, a list is created, modify an existing list using the Lists tool so that any previously configured list fields linking to a modified list will display the updated list data.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object has been published, and one or more forms published, create a query so that a set of records may be returned to fulfill a specific business requirement.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license and the extended formula agent has been started; create an extended formula field so that the system will trigger the calculation whenever one of the inputs changes.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license and an association has been created between two business objects, create an association filter on a query so that data returned by that query is filtered based on criteria define in business case.

Given that IBM TRIRIGA application and platform are installed, the user has access to Report Manager, a report is created with fields selected to display, create one or more field filter so that you may filter the result set of the report based on a pre-specified value or a user defined value at runtime of the report.

Section 2:Application Presentation
Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object has been published, and a form created to support the business object, create a tab on the form and sort it in the manner desired for record presentation so that after publishing the form the new tab and/or tab order will be available throughout the application.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, an applicable module, business object, form, and tab exist; create and sort form sections so that a new form section has been created and/or the sections are sorted in the desired order.

Given that TRIRIGA application and platform are installed, the user has access to Form Builder, a form is created with one or more tabs, and one or more form sections are created, create a section action so that this is available as a live action button for the end user at runtime.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, configure an on change event within a form so that on change events can trigger application related processes as required when data is modified in a field.

Given that IBM TRIRIGA application and platform are installed, the user has access to Form Builder, a form is created with one or more tabs, one or more form sections are created, and one or more fields of type Form Action are created, configure an on-click event for a Form Action field so that this is available as an action button for the end user at runtime.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object has been published, and a form created to support the business object, modify the label or name of the form so that after publishing the form the new label and/or name will be available throughout the application.

Given that IBM TRIRIGA application and platform are installed, the user has access to Form Builder, a form is created with one or more tabs, import the state transition family into the form so that the form can operate through its designed state transition life cycle at runtime.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object, form, and any necessary queries have been published/created, create navigation items and collections to be available for menus and/or portals to enable a user to them.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, and the applicable Portal exists; customize a portal so that the desired portal has been customized.

Section 3:Application Workflow
Given a completed functional design document,explain different workflow types so that the determination can be made on the type of workflow to be used.

Given a functional TRIRIGA system and a properly configured user for, create a workflow so that the desired logic is performed.

Given a functional IBM TRIRIGA system, configured to show workflow instances and a properly configured user so that a workflow can be analyzed.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, review the design of helper objects so that the user is able to perform repeatable processes without the need to design new objects.

Section 4:Utilities
Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, create an Object Migration Package in the Object Migration tool so that configurations can be ported from one environment to another.

Given that IBM TRIRIGA application and platform are installed, the user has access to the Object Migration tool, an export and/or import object migration package is created, import or export the object migration package so that application design data is available to migrate into another TRIRIGA system, or application design data from another system is imported into this TRIRIGA system.

Given that IBM TRIRIGA application and platform are installed, the user has an application builder license, and a business object and form has been published, create a data integrator input file so that data can be loaded or updated within the TRIRIGA system.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, and the target object and fields of the DI file exist, import the DI file so that the specified DI file is processed and records are created or modified.

Given that IBM TRIRIGA application and platform are installed, the user has access to the Document Manager, and proper permissions on the target folder to create a document record, import a document from your local file system so that the document is available for use in the TRIRIGA system.

Section 5:Problem Determination
Given that IBM TRIRIGA application and platform are installed, the user has admin or developer level security access, troubleshoot associations when association related behavior is abnormal.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license so that the user knows how to use the builder tools to troubleshoot common problems with state families to resolve issues.

Given that IBM TRIRIGA application and platform are installed, the user has access to Form Builder, a form is created with one or more tabs, one or more form sections are created, and fields have been created, troubleshoot a form to resolve issues found at runtime.

Given that IBM TRIRIGA application and platform are installed, the user has admin or developer level security access, troubleshoot a query when the query is not returning desired results so that the problem may be identified and subsequently corrected.

Section 6:Application Administration
Given that IBM TRIRIGA application and platform are installed, user with adequate security to access the Security Manager tool, configure a security group so that security group members have the desired level of access.

Given that IBM TRIRIGA application and platform are installed, the user is a part of the Admin group, the user has access to Admin Console, the user has access to create and manage data at the database level, create and manage the status of a data connect job.

Given that IBM TRIRIGA application and platform are installed, the user has appropriate security access, create a document folder structure so that outside data can be organized within the TRIRIGA document manager.

Given that IBM TRIRIGA application and platform are installed and the user has an application builder license, create a workflow with instance logging turned on so that each time the workflow is run a history or instance of the workflow is saved for investigative purposes.

Given that IBM TRIRIGA application and platform are installed, the user is a part of the Admin group, and the user has access to Admin Console, use the Cache Manager to clear cache for various platform components.

Given that IBM TRIRIGA application and platform are installed, the user has admin console access, monitor workflow from within the admin console so that Admin console user can utilize the admin console to monitor a variety of workflow activities which can be critical in evaluating workflow issues.

Given that IBM TRIRIGA application and platform are installed, the user is a part of the Admin group, and the user has access to Admin Console, use the Platform Logging tool to enable debug logging for parts of or all platform functionality.

QUESTION 1
Where are the classifications’ hierarchical parents to child associations created?

A. In the Form Builder
B. In the Data Modeler
C. In the Association Manager
D. In the State Family Manager

Answer: B

Explanation:


QUESTION 2
An existing portal must be modified so that a new navigation collection will display in the portal.
Assuming that a navigation collection of type Quick Links exists and is populated with navigation
items, what additional new element must be created to display this collection in the existing portal?

A. Portal
B. Portal Section
C. Navigation Item
D. Navigation Collection

Answer: B

Explanation:


QUESTION 3
Which workflow type gets executed by an association of two objects?

A. synchronous workflow using temporary data
B. synchronous workflow using permanent data
C. asynchronous workflow using temporary data
D. asynchronous workflow using permanent data

Answer: D

Explanation:


QUESTION 4
When a transition occurs to move a record into a tri Active state, the expected behavior is that the
form is in a read-only state. This is not happening. What is the issue with the Read-Only property?

A. It is not configured in the Sub Action properties.
B. It is not configured in the Form Section properties.
C. It is not configured in the Business Object properties.
D. It is not configured in the State Transition properties for at least one transition.

Answer: D

Explanation:

Monday, 16 January 2017

C2010-555: IBM Maximo Asset Management v7.6 Functional Analyst

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

Related certifications:
IBM Certified Deployment Professional - Maximo Asset Management v7.6 Functional Analyst

An IBM Certified Deployment Professional - Maximo Asset Management v7.6 Functional Analyst is a technical professional responsible for supporting, implementing and maintaining an IBM Maximo Asset Management v7.6 solution, the asset life cycle including inventory, contracts, purchasing, resources, work management, preventive maintenance and security. This individual will be expected to perform these tasks with limited assistance from peers, product documentation, and support resources.

Asset Management (18%)
Describe managing and creating failure codes
Describe managing and creating locations and location hierarchies
Describe set up and use of meters
Describe the use of warranty contracts for assets
Describe moving, modifying and swapping assets
Describe using and applying Asset Templates
Identify asset relationships
Describe creating asset subassemblies and spare parts
Describe the difference between rotating and non-rotating assets

Predictive and Preventive Maintenance (10%)
Explain the use of Master PMs
Describe how to configure the various types of PMs
Identify using Routes
Describe how to generate and modify a PM forecast
Describe how Condition Monitoring can be configured to generate work orders
Describe time based and meter based PMs
Apply job plan sequencing to PMs

Work Management and Planning (21%)
Describe work orders, child work orders and tasks
Explain how to assign a work order
Describe the plans and actuals on a work order
Describe the work order status change life cycle
Describe the creation of Job Plans
Describe how to report labor hours

Procurement Management (10%)
Describe procurement related contracts
Describe the difference between a company and a company master
Describe the purchasing life cycle (PR, PO, RFQ, DR, Invoice)
Describe the receiving processes
Perform the return of a rotating asset or direct issue item

Inventory Management (15%)

Explain inventory and inventory balances
Define costing methods
Describe the use of item assembly structures
Describe the different types of items
Describe using the Inventory Usage application
Describe hard and soft inventory reservations
Define a service item
Describe tool records and stocked tools
Describe adding new units of measure and conversions
Define the item statuses
Apply the reorder process

Workflow and Escalations (8%)
Describe the use of workflow processes
Construct workflow processes
Describe the use of escalations

Analytics (8%)
Construct adhoc reports
Identify where KPIs can be viewed
Describe KPI Templates
Explain the different reporting options
Demonstrate knowledge of running and using reports

Administration (10%)
Describe the creation of organization and sites
Describe managing resources
Describe managing the security configuration
Describe configuration of the business financials
Describe the creation of Calendars and Work Periods
Describe managing Classifications and attributes
Describe edit mode and how to apply it

QUESTION: No: 1
A company has a requirement to report on actual labor hours, materials, services and tools used as work
progresses on a work order. What is the earliest point in the basic life cycle a user can start reporting?
A.APPR
B. COIVIP
C. WIVIATL
D. WAPPR

Answer: A


QUESTION: No: 2
A vendor requires a payment of 20% of the purchase price when the purchase order (PO) is sent and the
company wants to withhold of the payment until 90 days after receiving the item before final payment is
made.
How would this be accomplished'?

A. A Purchase Requisition would be created and three invoices would) be generated via the invoicing
application One invoice tor 20%. one for 60% and one for 20%
B. A Price Contract would be created with a payment schedule with an invoice of 20% at the time the PO
is Approved, an invoice of 60% at the time the item is received and another invoice for 20% 90 days after
receipt.
C. A Blanket Contract would be created with a payment schedule with an invoice of 20% at the time the
PO is Approved, an invoice of 60% at the time the item is received and another invoice for 20% 90 days
after receipt
D. A Purchase Contract would be created with a payment schedule with an invoice of 20% at the time the
PO is Approved, an invoice of 60% at the time the item is received and another invoice for 20% 90 days
after receipt

Answer: D


QUESTION: No: 3
A company wishes to group its location records into a hierarchy to assist users in searching for asset s.
How can this be accomplished?

A. Location Groups can be created and LIVE locations added
B. Locations can be linked by using the Related Records tab in the Locations application.
C. Location records will need to be added to a network and can only include locations with an ACTIVE status.
D. Location records need to be added a system and can only include locations with an OPERATING type.

Answer: D


QUESTION: No: 4
A company has assets at multiple locations that require maintenance There is a requirement to have a
single work order with charges rolled up to a single GL account.
How can that be achieved?

A. Create a task work order for each asset
B. Create a child work order for each asset
C. Add a job plan that has the assets associated
D. Add the assets in MuItipIe Assets, Locations and Cis

Answer: B



Monday, 9 January 2017

Developing SQL Databases (beta) Exam 70-762

Published: August 26, 2016
Languages: English
Audiences: Developers
Technology: SQL Server
Credit toward certification: MCP, MCSA
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.
Design and implement database objects (25–30%)
Design and implement a relational database schema
Design tables and schemas based on business requirements, improve the design of tables by using normalization, write table create statements, determine the most efficient data types to use
Design and implement indexes
Design new indexes based on provided tables, queries, or plans; distinguish between indexed columns and included columns; implement clustered index columns by using best practices; recommend new indexes based on query plans
Design and implement views
Design a view structure to select data based on user or business requirements, identify the steps necessary to design an updateable view, implement partitioned views, implement indexed views
Implement columnstore indexes
Determine use cases that support the use of columnstore indexes, identify proper usage of clustered and non-clustered columnstore indexes, design standard non-clustered indexes in conjunction with clustered columnstore indexes, implement columnstore index maintenance
Implement programmability objects (20–25%)
Ensure data integrity with constraints
Define table and foreign key constraints to enforce business rules, write Transact-SQL statements to add constraints to tables, identify results of Data Manipulation Language (DML) statements given existing tables and constraints, identify proper usage of PRIMARY KEY constraints
Create stored procedures
Design stored procedure components and structure based on business requirements, implement input and output parameters, implement table-valued parameters, implement return codes, streamline existing stored procedure logic, implement error handling and transaction control logic within stored procedures
Create triggers and user-defined functions
Design trigger logic based on business requirements; determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers; recognize results based on execution of AFTER or INSTEAD OF triggers; design scalar-valued and table-valued user-defined functions based on business requirements; identify differences between deterministic and non-deterministic functions
Manage database concurrency (25–30%)
Implement transactions
Identify DML statement results based on transaction behavior, recognize differences between and identify usage of explicit and implicit transactions, implement savepoints within transactions, determine the role of transactions in high-concurrency databases
Manage isolation levels
Identify differences between Read Uncommitted, Read Committed, Repeatable Read, Serializable, and Snapshot isolation levels; define results of concurrent queries based on isolation level; identify the resource and performance impact of given isolation levels
Optimize concurrency and locking behavior
Troubleshoot locking issues, identify lock escalation behaviors, capture and analyze deadlock graphs, identify ways to remediate deadlocks
Implement memory-optimized tables and native stored procedures
Define use cases for memory-optimized tables versus traditional disk-based tables, optimize performance of in-memory tables by changing durability settings, determine best case usage scenarios for natively compiled stored procedures, enable collection of execution statistics for natively compiled stored procedures
Optimize database objects and SQL infrastructure (20–25%)
Optimize statistics and indexes
Determine the accuracy of statistics and the associated impact to query plans and performance, design statistics maintenance tasks, use dynamic management objects to review current index usage and identify missing indexes, consolidate overlapping indexes
Analyze and troubleshoot query plans
Capture query plans using extended events and traces, identify poorly performing query plan operators, create efficient query plans using Query Store, compare estimated and actual query plans and related metadata, configure Azure SQL Database Performance Insight
Manage performance for database instances
Manage database workload in SQL Server; design and implement Elastic Scale for Azure SQL Database; select an appropriate service tier or edition; optimize database file and tempdb configuration; optimize memory configuration; monitor and diagnose scheduling and wait statistics using dynamic management objects; troubleshoot and analyze storage, IO, and cache issues; monitor Azure SQL Database query plans
Monitor and trace SQL Server baseline performance metrics
Monitor operating system and SQL Server performance metrics; compare baseline metrics to observed metrics while troubleshooting performance issues; identify differences between performance monitoring and logging tools, such as perfmon and dynamic management objects; monitor Azure SQL Database performance; determine best practice use cases for extended events; distinguish between Extended Events targets; compare the impact of Extended Events and SQL Trace; define differences between Extended Events Packages, Targets, Actions, and Sessions
QUESTION: No: 01
You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O
problems.
What should you create?

A. a System IV|onitor report
B. a sys.dm_exec_query_stats dynamic management view query
C. a sys.dm_exec_session_wait_stats dynamic management view query
D. an ActMty Monitor session in Microsoft SQL Management Studio.

Answer:


QUESTION: No: 02
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
-Return a value of 0 if data inserted successfully into the Customers table.
-Return a value of 1 if data is not inserted successfully into the Customers table.
-Support logic that is written by using managed code.
What should you create'?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. DDL trigger
F. scalar-valued function
G. table-valued function

Answer:


QUESTION: No: 03
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
-Return a value of 0 if data inserted successfully into the Customers table.
-Return a value of 1 if data is not inserted successfully into the Customers table.
-Support TRY CATCH error handling
- Be written by using Transact-SOL statements.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer:


QUESTION: No: 04
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
- Launch when table data is modified.
- Evaluate the state a table before and after a data modification and take action based on the difference.
- Prevent malicious or incorrect table data operations.
- Prevent changes that violate referential integrity by cancelling the attempted data modification.
-Run managed code packaged in an assembly that is created in the Microsoft.NET Framework and
located into Microsoft SQL Server.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer:


QUESTION: No: 05
You are developing and application to track customer sales.
You need to return the sum of orders that have been finalized, given a specified order identifier. This
value will be used in other Transact-SOL statements.
You need to create a database object.
What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. scalar-valued function
F. table-valued function

Answer: