Free Microsoft 70-467 Exam Dumps Questions & Answers

You need to upgrade the SSASCluster.
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:

Box 2:

Box 3:

Note:
* From scenario:
/ The current SQL Server environment consists of a single instance failover cluster of SQL Server 2008 R2 Analysis Services (SSAS). The virtual server name of the cluster is SSASCluster. The cluster includes two nodes: Node1 and Node2. Node1 is currently the active node. In anticipation of the upgrade, the prerequisites and shared components have been upgraded on both nodes of the cluster, and each node was rebooted during a weekly maintenance window.
The upgrade must minimize user intervention and administrative effort. So we'll upgrade using the scripted method rather than the GUI method.
* (box 1)
/ SQL Server Setup provides the ability to generate a configuration file based upon the system default and run-time inputs. You can use the configuration file to deploy SQL Server throughout the enterprise with the same configuration. You can also standardize manual installations throughout the enterprise, by creating a batch file that launches Setup.exe.
/ How to generate a configuration file
Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
Follow the wizard through to the Ready to Install page. The path to the configuration file is specified in the Ready to Install page in the configuration file path section. For more information about how to install SQL Server, see Install SQL Server 2012 from the Installation Wizard (Setup).
Cancel the setup without actually completing the installation, to generate the INI file.
* (box 2) First upgrade the passive node node2.
To be able to use the configuration file we use the command prompt. After the upgrade, the cluster will fail over to the upgraded node.
*( Box 3) upgrade Node1 (which is now the passive node)
* You can upgrade a SQL Server failover cluster to a SQL Server 2008 failover cluster by using the SQL Server Installation Wizard or a command prompt. One of the main features of SQL Server 2008 failover clustering is minimal downtime for rolling upgrades and updates.
* To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter.
* To upgrade a SQL Server failover cluster to SQL Server 2008 R2, you must run the Setup on one failover cluster node at a time, starting with the passive nodes. Setup determines when to fail over to the upgraded node, depending on the total number of nodes in the failover cluster instance, and the number of nodes that have already been upgraded. When half of the nodes or more have already been upgraded, Setup by default will cause a failover to an upgraded node.
To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter to control the failover behavior before the upgrade operation takes the node offline. Use of this parameter is as follows:
/FAILOVERCLUSTERROLLOWNERSHIP=0 will not roll cluster ownership (move group) to upgraded nodes, and does not add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
/FAILOVERCLUSTERROLLOWNERSHIP=1 will roll cluster ownership (move group) to upgraded nodes, and will add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
/FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. It will be used if this parameter is not specified. This setting indicates that SQL Server Setup will manage cluster ownership (move group) as needed.
Reference: Install SQL Server 2012 Using a Configuration File
Reference: How to: Install SQL Server 2008 R2 from the Command Prompt

You develop a SQL Server Integration Services (SSIS) project named Project1 by using SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
* Configure Package1 so it can run within either a development environment or a test environment.
* Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
* The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
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:

Box 2:

Box 3:

You need to select and configure a tool for the monitoring solution.
What should you choose?

• A.  SQL Server Profiler configured with the Queries Events: Query Begin event
• B.  Performance Monitor configured with the MSAS11:Processing counter
• C.  Performance Monitor configured with the MSAS11:Storage Engine Query counter
• D.  SQL Server Profiler configured with the Query Processing: Query Subcube event

You need to develop the tabular project to support the date analysis requirements.
What should you do?

• A.  * Create one date table named Date.
  * Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
  * Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
• B.  * Create one date table named Date.
  * Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
  * Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
• C.  * Create two date tables, one named Order Date and one named Ship Date.
  * Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
  * Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
• D.  * Create two date tables, one named Order Date and one named Ship Date.
  * Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
  * Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.

You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

Correct Answer:

Explanation