70-467 무료 덤프문제 온라인 액세스

You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
* Include a columnstore index.
* Allow users to choose up to 10 dimension tables and up to five facts at one time.
* Maximize performance of queries that aggregate measures by using any of the 10 dimensions.
* Support billions of rows.
* Use the most efficient design strategy.
You need to design the fact table to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns.
• B.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns.
• C.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns.
• D.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns.

You are developing packages in a SQL Server Integration Services (SSIS) project to load a data warehouse.
You are designing a method for configuring the packages' connections when deployed to a production SSIS catalog. All packages load data from two source databases.
Two packages also load data from a third source database. Another SSIS project will use the same connections.
You need to meet the requirements.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Each term may be used once, more than once, or not at all.)

정답:

Explanation

A school stores information about teachers, students, classes, and enrollments in a Windows Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report parameter displays the correct subjects for each teacher.
Which item should you configure? To answer, select the appropriate item in the answer area.

정답:

Explanation

A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode.
After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
* Ensure that report writers can create only reports that display data which they have database permissions to view.
* Minimize the effort required to update connection strings for all reports developed by the report writers.
* Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create one shared data source that uses integrated security. Create a shared dataset for each department's data requirements.
• B.Create one shared data source that uses integrated security. Create an embedded dataset for each report.
• C.Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source views for each department's data requirements. Configure each data source to use integrated security.
• D.Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers.

You need to grant appropriate permissions to the SSISOwners SQL Server login.
What should you do?

• A.Map the login to the SSISDB database. Assign the user to the ssis_admin role.
• B.Map the login to the msdb database. Assign the user to the db_owner role.
• C.Map the login to the msdb database. Assign the user to the db_ssisadmin role.
• D.Map the login to the msdb database. Assign the user to the ssis_admin role.
• E.Map the login to the SSISDB database. Assign the user to the db_owner role.
• F.Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.