Online Access Free 070-467 Exam Questions

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table.
You have the following requirements:
* Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.
* Sort rows in ProductID order.
* Aggregate product units sold.
* Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.
• B.A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.
• C.A table-based OLE DB source; a Script component; and a Flat File destination.
• D.Only a SQL command-based OLE DB source and a Flat File destination.

You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint
2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Migrate SSRS content to new servers that run SSRS 2014.
• B.Perform an in-place upgrade of the SSRS environment.
• C.Migrate SSRS content to a separate instance of SSRS 2014 on the same server.
• D.Install SSRS 2014 on a new SharePoint farm and migrate content to the new farm.

You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?

• A.Microsoft SQL Server
• B.ODBC
• C.OLE DB
• D.OData

You are administering a SQL Server Analysis Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant read access to the financial cube for all users in the group USA\PowerUsers.
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.)

Correct Answer:

Explanation
Box 1: In the SQ L Management Studio (SSMS), connect to the SSAS instance on the server.
Box 2: Create a new role for the database.
Box 3: Add the USA\PowerUsers group to the role. Set the cube access for the role to Read.
Note:
* A member of the server role for Microsoft SQL Server Analysis Services, or a member of a database role that has Full Control (Administrator) permissions in a particular database, can create a database role that only has permission to process specified objects within the database. Giving a database role permission to process a database object lets an administrator delegate the task of processing certain objects, without also granting extraneous permissions to the user who is performing the processing.
* In SQL Server Management Studio, connect to the instance of Analysis Services, expandRolesfor the appropriate database in Object Explorer, and then double-click a database role (or right-click Rolesand selectNew Roleto create a new database role). If this is a new role, make sure that you enter a name for the role in theRole namebox.
* ClickCubesin theSelect a Pagepane, locate the cube in theCubelist, and then select theProcesscheck box for the cube.
* Click theOKbutton.
* To give a database role permission to process a cube
* There is no write permissions on a cube.
Reference: Grant Process Permissions on an Analysis Services Multidimensional Database

You need to update the Execute SQL task in the OnVariableValueChanged event handler of all SSIS packages.
Which additional variable should be logged?

• A.System::VariableID
• B.System::ExecutionInstanceGUID
• C.System::ServerExecutionID
• D.System::SourceID