[100% Pass] The Premium PassLeader Microsoft 70-463 283q PDF Practice Test For Free Download (181-200)
Posted on March 28, 2015 | By admin
Where To Get The 100% Valid 70-463 exam dumps? Come to PassLeader! Here you can get the latest version 70-463 PDF dumps or the actual dumps with vce exam simulator, we guarantee our 70-463 238q exam questions are the latest and you will get all the new questions and answers, which are not available on other wesites now! Now try our best 70-463 exam practice tests with VCE and you will acquire your Microsoft SQL Server 2012 certification immediately.
keywords: 70-463 exam,70-463 238q exam dumps,70-463 real exam questions,70-463 238q pdf dumps,70-463 vce dumps,70-463 vce test software,70-463 brain dumps,Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode. Some of the data to be loaded will reference products that need special processing logic in the data flow. You need to enable separate processing streams for a subset of rows based on the source product code. Which data flow transformation should you use?
A. Source Assistant
B. Destination Assistant
D. Script Component
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Package developers in your company must have permission to perform the following tasks only on their own projects:
– View projects and packages
– View Environments
– Validate packages
– Execute packages
You need to grant rights to the developers without assigning unnecessary privileges. What should you do? (Each correct answer presents part of a solution. Choose all that apply.)
A. Add developer logins to the db_ssisltduser role in the msdb database.
B. Add developer logins to the db_ssisoperator role in the msdb database.
C. Grant Execute permission in the projects for the developer logins.
D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments.
E. Add developer logins to the ssis_admin role in the SSISDB database.
F. Grant Modify permission in the projects for the developer logins.
To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The following requirements must be met:
– All the user information for a given Active Directory group must be downloaded to a SQL Server table.
– The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development effort. Which item should you use?
A. Script task
B. Script component configured as a transformation
C. Script component configured as a source
D. Script component configured as a destination
You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package has the following requirements:
– Every night, a very large amount of data is imported into the staging database.
– Package processing time must be minimized.
– The package must run on its own dedicated server when it is deployed to production.
– Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements. Which destination component should you use?
A. Raw File
C. Bulk Insert
D. OLE DB
You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from various flat files and a Windows Azure SQL Database database. Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate variable as the transaction date. You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL Database database when the package starts. You need to achieve this goal by using the least amount of development effort. What should you use to set the variable?
A. an Expression task
B. an Execute SQL task
C. a Script component
D. a Script task
You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met. What should you install?
A. Microsoft SharePoint Server 2010 Standard Edition SP1
B. Microsoft SharePoint Server 2010 Enterprise Edition SP1
C. SQL Server 2012 Data Center (64-bit) x64 on the database server
D. SQL Server 2012 Enterprise (64-bit) x64 on the database server
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012. The package fails when executed on the production server. You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal. What should you do?
A. Create a custom SSIS source component that encapsulates the 32-bit driver and compile it in 64-bit mode.
B. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
C. Execute the package by using the 32-bit run-time option.
D. Replace the SSIS Excel source with a SSIS Flat File source.
You are installing the Data Quality Server component of Data Quality Services. You need to provision the hardware and install the software for the server that runs the Data Quality Server. You must ensure that the minimum Data Quality Server prerequisites are met. What should you do?
A. Install Microsoft Internet Explorer 6.0 SP1 or later.
B. Install SQL Server 2012 Database Engine.
C. Make sure the server has at least 4 GB of RAM.
D. Install Microsoft SharePoint Server 2010 Standard Edition.
You are developing a SQL Server Integration Services (SSIS) package. The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certain groups of tasks will share variable and transaction scope. You need to group tasks together while enabling them to be collapsed and expanded as a group. Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item in the answer area.)
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database. The name of the target instance is passed to the package via an Environment variable. The Environment variable provides the server name to the Project parameter named ServerName. The OLE DB Project Connection Manager has been parameterized. You need to configure the Connection Manager property to accept the parameter. Which property and parameter should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Drag and Drop Questions
You administer a large and complex SQL Server Integration Services (SSIS) solution in the SSIS catalog. You are instructed to execute a package by using PowerShell. You need to create the correct PowerShell command. How should you place the four code segments in sequence? (To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.)
You are the Master Data Services (MDS) administrator at your company. An existing user needs to integrate data from other systems into MDS. You need to give the user permissions to integrate data. Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
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 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.
B. 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.
C. 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.
D. Design a table to hold the surrogate key for each customer and its attributes as well as additional columns to store the original attributes.
You are designing a data warehouse hosted on Windows Azure SQL Database. The data warehouse currently includes the dimUser and dimRegion dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse, and the dimRegion table contains information about sales regions. The system is accessed by users from certain regions, as well as by area supervisors and users from the corporate headquarters. You need to design a table structure to ensure that certain users can see sales data for only certain regions. Some users must be permitted to see sales data from multiple regions. What should you do?
A. For each region, create a view of the factSales table that includes a WHERE clause for the region.
B. Create a userRegion table that contains primary key columns from the dimUser and dimRegion tables.
C. Add a region column to the dimUser table.
D. Partition the factSales table on the region column.
You are developing a SQL Server Integration Services (SSIS) package. The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse. You need to create a separate data flow path for data that has been modified since it was last processed. Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)
B. Data Conversion
D. Slowly Changing Dimension
Drag and Drop Questions
You are the administrator for a Data Quality Server. You are adding a user who must have permission to:
– Edit and execute a project
– View the activity monitoring data
This user must not be able to:
– Perform any kind of knowledge management
– Create or change a knowledge base
Terminate an activity or perform administrative duties. You need to develop a Transact-SQL (T-SQL) script to meet these requirements. What should you do? (To answer, drag the appropriate code segment or segments to the correct location or locations in the answer area.)
Drag and Drop Questions
A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints:
– The operating system is Windows Server 2008 R2.
– The SSIS packages are stored in the SSIS catalog.
– Some of these SSIS packages use 32-bit custom components.
You need to install only the components that are required to deploy and run the packages on the new server. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task. Changes to the customer attributes must be tracked over time. You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution. You need to use the least amount of development effort to achieve this goal. Which transformation should you use? (To answer, select the appropriate transformation in the answer area.)
A SQL Server Integration Services (SSIS) package is designed to download data from a financial database hosted in SQL Azure. The connection string to the financial database is defined as a project parameter named FinConStr. The parameter value must be stored securely and must be set explicitly every time the package is executed. You need to configure the parameter to meet the requirements. What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
You are the Master Data Services (MDS) administrator at your company. An existing user must be denied access to a certain hierarchy node for an existing model. You need to configure the user’s permissions. Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)