PR000005 practice question 19 of 25
Which of the following is NOT a required step for using DQ for Excel?
Full set: 140 questionsThe Informatica DQ for Excel feature operates by exposing Data Quality mappings as web services directly from the Informatica domain's Data Integration Service (DIS). The required workflow involves creating a web service-enabled mapping in the Developer tool, deploying it as an application to the DIS, and then configuring the DQ for Excel add-in to connect to that service. Exporting the mapping to PowerCenter is a separate integration pattern used for batch processing within the PowerCenter environment and is not a prerequisite for using the real-time web service functionality consumed by DQ for Excel.
A. This is incorrect because configuring the connection from Excel to the Informatica web service is a mandatory step. The add-in requires the service's location (URL/WSDL) to function.
B. This is incorrect because a web service-enabled mapping containing the data quality logic must be built in the Developer tool. This mapping is the core component that will be exposed as a service.
D. This is incorrect because in the Informatica platform, any object, including a web service mapping, must be deployed as part of an application to a running service (the DIS) to be accessible.
1. Informatica 10.5 Data Quality for Microsoft Excel Guide, Chapter 2: "Using Data Quality for Microsoft Excel", Section: "Before You Begin", Page 9.
This section explicitly states the prerequisites: "Before you can use Data Quality for Microsoft Excel, an Informatica administrator must perform the following tasks: 1. Create one or more mappings in the Developer tool that can cleanse the data in a worksheet. 2. Deploy the mappings as applications to a Data Integration Service." This directly supports that options B and D are required steps.
2. Informatica 10.5 Application Service Guide, Chapter 10: "Web Services", Section: "Web Service Components".
This chapter details how web services are created from mappings and deployed to a Data Integration Service. It describes the architecture where the DIS hosts the web service, which is then consumed by clients like DQ for Excel. There is no mention of a required PowerCenter export step in this workflow.
3. Informatica 10.5 Data Quality for Microsoft Excel Guide, Chapter 2: "Using Data Quality for Microsoft Excel", Section: "Connect to an Informatica Domain", Page 10.
This section details the process of connecting the Excel add-in to the Informatica domain and service. It requires the user to "Enter the domain connection information," which is functionally equivalent to providing the service URL or connection details as described in option A.
Keep practicing
Take the free PR000005 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000005 practice questions
- Question 1When you select Suggestion List mode what statement is true?
- Question 2How much data can DQA handle?
- Question 3What is the primary purpose of grouping data?
- Question 4Which definition describes Column Profiling?
- Question 5Which parameter function is supported in IDQ 9.1?
- Question 6Which of the following is not true when it comes to creating and updating Reference Table…
