Microsoft Certification 70-463 Exam
Implementing Data Warehouses with Microsoft SQL Server 2012
· Exam Number/Code : 70-463 demo
· Exam Name : Implementing Data Warehouses with Microsoft SQL Server 2012
· Questions and Answers : 168 Q&As
· Update Time: 2013-09-10
· Price: $ 143.00 $ 116.00
Question: 1
You are designing a data warehouse that contains a customer dimension. The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved. The customer dimension design must:
•Support a Type 3 Slowly Changing Dimension (SCD) process
•Minimize the total storage consumed
You need to design a solution that meets these requirements. What should you do?
A. Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
B. Design two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.
C. Design a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.
D. Design a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.
Answer: A
Question: 2
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file. You need to implement the change to the existing package while minimizing the development effort. What should you use to call the web service to retrieve the daily exchange rates?
A. a Script task
B. a Script component
C. a Web Service task
D. a Web Service source
Answer: C
Question: 3
You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?
A. Copy and paste connection managers from one package to the others.
B. Implement parent package variables.
C. Implement project connection managers.
D. Implement package connection managers.
Question: 4
You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data flow task that reads the product stock levels from the HTML web page. Which data flow source should you use?
A. Add an OnError event handler to the SSIS project.
B. Open a command prompt and run the gacutil command.
C. Open a command prompt and run the dtutil /copy command.
D. Use an msi file to deploy the package on the server.
Answer: C
Question: 5
You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). You must develop an SSIS project and deploy it to the server by using the Project Deployment model. Operations Log records that are outside the configured retention period must be cleaned automatically. You need to create the SSIS catalog on the production server. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Enable CLR Integration.
B. Enable OLE Automation.
C. Enable XP Command Shell.
D. Enable Ad Hoc Remote Queries.
E. Enable Cross Database Ownership Chaining.
F. Start the SQL Server Agent service.
Answer: (F AND A) AND ONLY (F, A)
G. Start the SQL Server Browser service.
Question: 6
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain. You need to complete the mapping of the Group column. What should you do?
A. Create a composite domain that includes the Group column.
B. Add a column mapping for the Group column.
C. Add a domain for the Group column.
D. Map a composite domain to the source column.
Answer: C
Question: 7
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on Windows Azure SQL Database. Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart. You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented. What should you do?
A. Create a junk dimension for the geography dimension.
B. Create three geography dimensions.
C. Implement change data capture.
D. Create a conformed dimension for the geography dimension.
Answer: D
Question: 8
You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package contains a data flow task that has seven source–to-destination execution trees. Only three of the source-to-destination execution trees are running in parallel. You need to ensure that all the execution trees run in parallel. What should you do?
Place the data flow task in a For Loop container that is configured to execute seven times
Create seven data flow tasks that contain one source-to-destination execution tree each.
C. Set the MaxConcurrentExcecutables property of the package to 7.
D. Set the EngineThreads property of the data flow task to 7.
Answer: D
http://www.testonside.com/70-463.html
Implementing Data Warehouses with Microsoft SQL Server 2012
· Exam Number/Code : 70-463 demo
· Exam Name : Implementing Data Warehouses with Microsoft SQL Server 2012
· Questions and Answers : 168 Q&As
· Update Time: 2013-09-10
· Price: $ 143.00 $ 116.00
Question: 1
You are designing a data warehouse that contains a customer dimension. The customer dimension contains the original customer attributes as well as the most recent set of updated attributes. When a customer is updated, the original customer attributes must be preserved. The customer dimension design must:
•Support a Type 3 Slowly Changing Dimension (SCD) process
•Minimize the total storage consumed
You need to design a solution that meets these requirements. What should you do?
A. Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
B. Design two tables. One table will hold the original customer surrogate key and attributes. The other table will hold the most recent customer surrogate key and attributes.
C. Design a table as a Type 2 SCD dimension that holds the surrogate key for each customer and its attributes. Limit the number of records per customer within the table to two.
D. Design a table to hold the surrogate key for each customer and its attributes. Add a column to store an indicator that identifies the record as original data or recent data.
Answer: A
Question: 2
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file. You need to implement the change to the existing package while minimizing the development effort. What should you use to call the web service to retrieve the daily exchange rates?
A. a Script task
B. a Script component
C. a Web Service task
D. a Web Service source
Answer: C
Question: 3
You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?
A. Copy and paste connection managers from one package to the others.
B. Implement parent package variables.
C. Implement project connection managers.
D. Implement package connection managers.
Question: 4
You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data flow task that reads the product stock levels from the HTML web page. Which data flow source should you use?
A. Add an OnError event handler to the SSIS project.
B. Open a command prompt and run the gacutil command.
C. Open a command prompt and run the dtutil /copy command.
D. Use an msi file to deploy the package on the server.
Answer: C
Question: 5
You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). You must develop an SSIS project and deploy it to the server by using the Project Deployment model. Operations Log records that are outside the configured retention period must be cleaned automatically. You need to create the SSIS catalog on the production server. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Enable CLR Integration.
B. Enable OLE Automation.
C. Enable XP Command Shell.
D. Enable Ad Hoc Remote Queries.
E. Enable Cross Database Ownership Chaining.
F. Start the SQL Server Agent service.
Answer: (F AND A) AND ONLY (F, A)
G. Start the SQL Server Browser service.
Question: 6
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain. You need to complete the mapping of the Group column. What should you do?
A. Create a composite domain that includes the Group column.
B. Add a column mapping for the Group column.
C. Add a domain for the Group column.
D. Map a composite domain to the source column.
Answer: C
Question: 7
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on Windows Azure SQL Database. Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart. You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented. What should you do?
A. Create a junk dimension for the geography dimension.
B. Create three geography dimensions.
C. Implement change data capture.
D. Create a conformed dimension for the geography dimension.
Answer: D
Question: 8
You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package contains a data flow task that has seven source–to-destination execution trees. Only three of the source-to-destination execution trees are running in parallel. You need to ensure that all the execution trees run in parallel. What should you do?
Place the data flow task in a For Loop container that is configured to execute seven times
Create seven data flow tasks that contain one source-to-destination execution tree each.
C. Set the MaxConcurrentExcecutables property of the package to 7.
D. Set the EngineThreads property of the data flow task to 7.
Answer: D
http://www.testonside.com/70-463.html