fbpx

Compass College News

January 5, 2017

Local Film Students Create Music Video With Renowned Film Director

GRAND RAPIDS, Mich. (January 5, 2017) — Internationally recognized film director, Harold Cronk (God’s Not Dead , God’s Not Dead 2), teamed up with film students from Compass College of Cinematic Arts to create a stunning music video featuring singer-songwriter Micah Tyler and his chart-topping song, Never Been a Moment . Filming took place at the Grand Rapids Public Museum, with a large timepiece in the background creating a nostalgic backdrop for the video. The video is now available on VEVO.com and Tyler’s YouTube channel, MicahTylerVevo.

“It was a great opportunity to learn from an incredibly successful director,” said Brandon Patterson, a Compass College senior who was selected to be the First Assistant Director on set. “I was nervous, but Harold was very gracious and humble about it. I learned a lot from him and the crew.”

Cronk currently is in post-production for his next feature film, God Bless the Broken Road, which features Micah Tyler’s music. Several Compass College interns and alumni have been working on the film. When the opportunity arose to create a music video for Tyler, Cronk reached out to Compass College offering interns and students in the music video and sound design courses experience working with professionals.

QUESTION 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the

stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.

You need to ensure that you can perform auditing at the database level for DB1.

Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition.

Does the solution meet the goal?

A. Yes

B. No

Correct Answer: B

Explanation

Explanation/Reference:

All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 2016 SP1. Prior to that, database level

auditing was limited to Enterprise, Developer, and Evaluation editions.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql- server-audit-database-engine

QUESTION 6

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the

stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.

Solution: You add the DatabaseMailUserRole to Mail1 in the msdb database.

Does the solution meet the goal?

A. Yes

B. No

Correct Answer: A

Explanation

Explanation/Reference:

Database Mail is guarded by the database role DatabaseMailUserRole in the msdb database in order to prevent anyone from sending arbitrary emails. Database

users or roles must be created in the msdb database and must also be a member of DatabaseMailUserRole in order to send emails with the exception of

sysadmin who has all privileges.

Note: Database Mail was first introduced as a new feature in SQL Server 2005 and replaces the SQL Mail feature found in previous versions.

References:http://www.idevelopment.info/data/SQLServer/DBA_tips/Database_Administrati on/DBA_20.shtm

https://www.exam2pass.com/500-230.html

QUESTION 7

You have a server named Server1 that has 2 processors.

You plan to deploy multiple instances of SQL Server 2016 to Server1. Each instance will have multiple databases.

You need to recommend a method to allocate processor time to each database.

What should you include in the recommendation?

More than one answer choice may achieve the goal. Select the BEST answer.A. Resource Governor

B. Max Degree of Parallelism

C. Windows System Resource Manager (WSRM)

D. Processor affinity

Correct Answer: A

Explanation

Explanation/Reference:

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables

you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.

Reference: Resource Governor

Incorrect:

D: PROCESS AFFINITY

Enables hardware threads to be associated with CPUs.

QUESTION 8

You deploy a database by using SQL Server 2016. The database contains a table named Table1.

You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.

What should you recommend?

A. Change data capture

B. Statistics

C. A trigger

D. Master Data Services

Correct Answer: A

Explanation

Explanation/Reference:

Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an

easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table,

along with the metadata needed to understand the changes that have occurred.

Reference: About Change Data Capture (SQL Server)

“Harold is an excellent teacher who continually offers Compass students excellent on-set opportunities,” said Compass College President, Keri Lowe. “Even with his success as a filmmaker, he continues to look for ways to serve and give back to his community.”

Compass students worked on many different aspects of the music video project, from scouting locations to camera work, assistant directing, sound and editing.

For Compass College senior Paul Rice, “The most exciting part of the process has been post-production. I was selected to work as the primary editor for the project. It has been a great opportunity for me to work on a professional project.”

The music video can be viewed on Vevo.com and Micah Tyler’s YouTube channel, MicahTylerVEVO. God Bless the Broken Road is expected to hit theatres summer, 2017.