单选题You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）ACustom event handlersBData flow error outputCSSIS log provider for SQL ServerDExecute SQL tasks with failure precedence constraints
单选题
You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）
A
Custom event handlers
B
Data flow error output
C
SSIS log provider for SQL Server
D
Execute SQL tasks with failure precedence constraints
参考解析
解析：
暂无解析
相关考题：
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.What should you do?A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
Certkiller.com has given you the task of serializing an object and writing it to a data file using binary serialization.You need to ensure that you meet these requirements.What should you do?() A.B.C.D.
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?() A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）A. A template needs to be associated with the task.B.A workload needs to be associated with the task.C. The partial or complete workload scope needs to be associated with the task.D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A．Select the commit on successful completion check box of the DTS package.B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.
You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
You install a TV tuner card on your computer. You need to record two different TV shows that runon two different channels at the same time.What should you do?() A.AB.BC.CD.D
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package
Your company has a domain controller that runs Windows Server 2008 and the DNS role. The DNS domain is named contoso.com You need to ensure that inquries about contoso.com are sent to dnsadmin@contoso.com What should you do？（）A、Create a signature （SIG） record for the domain controllerB、Modify the Name Server （NS） record for the domain controllerC、Modify the Service Locator （SRV） record for the domain controllerD、Modify the Start of Authority （SOA） record ont he domain controller
You are designing a Windows Azure web application. The application will be accessible at a standard cloudapp.net URL. You need to recommend a DNS resource record type that will allow you to configure access to the application through a custom domain name. Which type should you recommend？（）A、 AB、 CNAMEC、 MXD、 SRV
You use Microsoft Application Virtualization for Desktops to virtualize applications for client computers.A virtual application that was installed by using a Windows Installer Package (.msi) file has become corrupted. You need to restore access to the virtual application. Which two actions should you perform？（）A、Reload the virtual application package.B、Reinstall the virtual application package.C、Use the Repair function in the Windows Installer Package. Use the Microsoft Application Virtualization (App-V) to re-sequence the application.D、Use the Microsoft Application Virtualization (App-V) Sequencer to edit the virtual application package.
Your network consists of an Active Directory domain named contoso.com. You have a computer namedcomputer1.contoso.com. Your network is configured to use only IPv6. You need to request that a DNS record be created to enable users to connect to your computer by using the name dev.contoso.com. Which type of record should you request ?（）A、AB、AAAAC、HINFOD、NAPTR
You have an Exchange Server 2010 organization.You need to create a resource record in DNS to support Autodiscover from the Internet.What type of resource record should you create？（）A、Host（A）B、Text（TXT）C、Pointer（PTR）D、Mail exchange（MX）
You have an Exchange Server 2010 organization.The organization is authoritative for the domain contoso.com.You create a federated trust.You need to ensure that federated partners can automatically locate the Client Access servers in the organization. What should you create from an external DNS server？（）A、an A record for autodiscover.contoso.comB、an A record for FederatedSharing.contoso.comC、an SRV record for _autodiscover._TCP._msdcs.contoso.comD、an SRV record for _FederatedSharing._UDP._msdcs.contoso.com
单选题To generate recommendations to improve the performance of a set of SQL queries in an application， you execute the following blocks of code： BEGIN dbms_advisor.create_task（dbms_advisor.sqlaccess_advisor，’TASK1’）； END； / BEGIN dbms_advisor.set_task_parameter（’TASK1’，’ANALYSIS_SCOPE’，’ALL’）； dbms_advisor.set_task_parameter（’TASK1’，’MODE’，’COMPREHENSIVE’）； END； / BEGIN dbms_advisor.execute_task（’TASK1’）； dbms_output.put_line（dbms_advisor.get_task_script（’TASK1’））； END； / The blocks of code execute successfully；however，you do not get the required outcome. What could be the reason？（）A A template needs to be associated with the task.B A workload needs to be associated with the task.C The partial or complete workload scope needs to be associated with the task.D The type of structures （indexes， materialized views， or partitions） to be recommended need to be specified for the task.
单选题Your company has a server that runs Windows Server 2008 R2.You have a new application that locates remote resources by name. The new application requires IPv6.You need to ensure that the application can locate remote resources by using IPv6.What should you do？（）ACreate a new Pointer (PTR) DNS record.BCreate a new Quad-A (AAAA) DNS record.CCreate a new Signature (SIG) DNS record.DCreate a new Route Through (RT) DNS record.
单选题You have an Exchange Server 2010 organization.The organization is authoritative for the domain contoso.com.You create a federated trust.You need to ensure that federated partners can automatically locate the Client Access servers in the organization. What should you create from an external DNS server？（）Aan A record for autodiscover.contoso.comBan A record for FederatedSharing.contoso.comCan SRV record for _autodiscover._TCP._msdcs.contoso.comDan SRV record for _FederatedSharing._UDP._msdcs.contoso.com
单选题You create a package that contains PL/SQL variables that must be shared among several forms in the Travel application. You place the package in a library and attach the library to all the forms that need to share the data. Which parameter in the OPEN_FORM built-in must you set to ensure that changes made by one form are visible to the other forms in the application?（）Adata_mode Bparamlist Cquery_mode Dsession_mode
单选题You have a Terminal Server that runs Windows Server 2008. You create a Windows Installer package for Microsoft Office Word 2007 by using Terminal Services RemoteApp （TS RemoteApp）. You install the package on a client computer. You double-click on a Word document and receive the following error. Windows cannot open this file. You need to ensure that you can open the Word document by double-clicking on the file. What should you do？（）ARecreate the Windows Installer package.BModify the file association on the client computer.CModify the file association on the TS RemoteApp server.DInstall the Windows Installer package by using msiexec.exe.
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）AThe SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.BThe SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.CThe SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.DThe SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
单选题You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the databaseCCreate Flashback Data Archive in the tablespace where the tables are stored.DCreate Flashback Data Archive and enable Flashback Data Archive for specific tables
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below， which utility should you choose to use？（）Abcp.exe Bdta.exe Cdtexec.exe Dsqlmaint.exe
单选题You have an Exchange Server 2010 organization.You plan to enable Federated Sharing.You need to create a DNS record to store the Application Identifier （AppID） of the domain for the federated trust. Which type of record should you create？（）AABCNAMECSRVDTXT
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）Aby using the ANALYZE utilityBby using the DBVERIFY utilityCby using the DB_BLOCK_CHECKING parameterDby using the DBMS_REPAIR package
单选题Your network consists of a single Active Directory domain named contoso.com. All servers run Windows Server 2003 Service Pack 2 (SP2). You deploy a Web server named Server1. Users access the server by using the URL http://server1.contoso.com. You need to create a new resource record that will allow users to access the server by using the URL http://www.contoso.com. The solution must prevent the need to modify the new record if the IP address of Server1 changes. Which type of resource record should you configure?（）Aalias（CNAME）Bhost （A）Cmail exchanger （MX）Dpointer（PTR）
单选题—Do you need more time to complete the task?—Yes. Another ten days ______ enough.AisBwasCareDwere